pears.AutoMatchShiftQueue

For use by Auto-matching procedures

• AutoMatchShiftQueueID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."AutoMatchShiftQueue"
-- Table comment: For use by Auto-matching procedures
-- Statement count: 5
 
CREATE TABLE "pears"."AutoMatchShiftQueue" (
    "AutoMatchShiftQueueID"          BIGINT NOT NULL DEFAULT autoincrement
   ,"TempShiftPlanID"                CHAR(20) NULL
   ,"Created"                        TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,"Completed"                      TIMESTAMP NULL
   ,"NotRequired"                    tinyint NULL DEFAULT 0
   ,"ActionType"                     CHAR(15) NULL
   ,PRIMARY KEY ("AutoMatchShiftQueueID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchShiftQueue"."Completed" IS 
	'means has been used'
GO
 
 
COMMENT ON COLUMN "pears"."AutoMatchShiftQueue"."NotRequired" IS 
	'Remove by sweeper job?'
GO
 
 
COMMENT ON TABLE "pears"."AutoMatchShiftQueue" IS 
	'For use by Auto-matching procedures'
GO
 
 
ALTER TABLE "pears"."AutoMatchShiftQueue"
    ADD FOREIGN KEY "tempshiftplan" ("TempShiftPlanID" ASC)
    REFERENCES "pears"."TempShiftPlan" ("TempShiftPlanID")
    ON DELETE CASCADE
GO