pears.ShiftTemplateGroup

For grouping shift templates

• ShiftTemplateGroupID

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."ShiftTemplateGroup"
-- Table comment: For grouping shift templates
-- Statement count: 4
 
CREATE TABLE "pears"."ShiftTemplateGroup" (
    "ShiftTemplateGroupID"           CHAR(20) NOT NULL
   ,"Description"                    CHAR(20) NULL
   ,"CommentText"                    CHAR(100) NULL
   ,"DepartmentID"                   CHAR(2) NULL
   ,"ClientTempShiftCode"            CHAR(12) NULL
   ,PRIMARY KEY ("ShiftTemplateGroupID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."ShiftTemplateGroup"."ClientTempShiftCode" IS 
	'Allows standard shifts to be customised for clients or groups'
GO
 
 
COMMENT ON TABLE "pears"."ShiftTemplateGroup" IS 
	'For grouping shift templates'
GO
 
 
ALTER TABLE "pears"."ShiftTemplateGroup"
    ADD FOREIGN KEY "department" ("DepartmentID" ASC)
    REFERENCES "pears"."Department" ("departmentid")
    ON DELETE SET NULL
GO