CREATE TABLE "consignmentstatustracker"( 
    "id"                    bigserial PRIMARY KEY,
    "consignment_no"        VARCHAR NOT NULL,
    "consignment_status"   VARCHAR NOT NULL,
    "reasons"               VARCHAR NULL,
    "notes"                 VARCHAR NULL,
    "created_at"            TIMESTAMPTZ NOT NULL DEFAULT(now())
);
ALTER TABLE "consignmentstatustracker" ADD FOREIGN KEY ("consignment_no") REFERENCES  "plannedconsignments" ("id");
