pears.AutoMatchPersonPreferredShiftType

Preferred shift template group

• AutoMatchPersonPreferredShiftTypeID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."AutoMatchPersonPreferredShiftType"
-- Table comment: Preferred shift template group
-- Statement count: 4
 
CREATE TABLE "pears"."AutoMatchPersonPreferredShiftType" (
    "AutoMatchPersonPreferredShiftTypeID" CHAR(20) NOT NULL
   ,"PersonID"                       CHAR(20) NULL
   ,"ShiftTemplateGroupID"           CHAR(20) NULL
   ,"Created"                        TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,"Weighting"                      tinyint NULL
   ,PRIMARY KEY ("AutoMatchPersonPreferredShiftTypeID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."AutoMatchPersonPreferredShiftType" IS 
	'Preferred shift template group'
GO
 
 
ALTER TABLE "pears"."AutoMatchPersonPreferredShiftType"
    ADD FOREIGN KEY "Person" ("PersonID" ASC)
    REFERENCES "pears"."Person" ("personid")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."AutoMatchPersonPreferredShiftType"
    ADD FOREIGN KEY "ShiftTemplateGroup" ("ShiftTemplateGroupID" ASC)
    REFERENCES "pears"."ShiftTemplateGroup" ("ShiftTemplateGroupID")
    ON DELETE CASCADE
GO