CREATE TABLE "product_interception_notice"( 
    "id"                        bigserial PRIMARY KEY,
    "packinglist_product_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 "product_interception_notice" ADD FOREIGN KEY ("packinglist_product_id") REFERENCES "packinglist_products" ("id");
ALTER TABLE "product_interception_notice" ADD FOREIGN KEY ("exportcompany_id") REFERENCES "exportcompanies" ("id");
ALTER TABLE "product_interception_notice" ADD FOREIGN KEY ("user_id") REFERENCES "users" ("id");