CREATE TABLE "productothers_interception_notice"( 
    "id"                        bigserial PRIMARY KEY,
    "packinglist_other_id"      INT NOT NULL,
    "consignment_no"            VARCHAR NOT NULL,
    "exportcompany_id"          INT NOT NULL,
    "reason"                    VARCHAR NOT NULL,
    "action"                    VARCHAR NOT NULL,
    "notes"                     VARCHAR NOT NULL,
    "user_id"                   INT NOT NULL,
    "created_at"                TIMESTAMPTZ NOT NULL DEFAULT(now())
);
ALTER TABLE "productothers_interception_notice" ADD FOREIGN KEY ("packinglist_other_id") REFERENCES "packinglist_others" ("id");
ALTER TABLE "productothers_interception_notice" ADD FOREIGN KEY ("exportcompany_id") REFERENCES "exportcompanies" ("id");
ALTER TABLE "productothers_interception_notice" ADD FOREIGN KEY ("user_id") REFERENCES "users" ("id");