Table of Contents



pears.ShiftTemplateGroup

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

For grouping shift templates

Columns

Column Type Null Default Comment
ShiftTemplateGroupID char(20) NOT NULL
Description char(20) NULL
CommentText char(100) NULL
DepartmentID char(2) NULL
ClientTempShiftCode char(12) NULL Allows standard shifts to be customised for clients or groups

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
department DepartmentID pears.Department (departmentid) ON DELETE SET NULL

Referenced By

Table Constraint Columns Referenced columns
pears.AutoMatchPersonPreferredShiftType ShiftTemplateGroup ShiftTemplateGroupID ShiftTemplateGroupID
pears.TemplateGroupTemplate ShiftTemplateGroup ShiftTemplateGroupID ShiftTemplateGroupID
pears.VacancyLimit ShiftTemplateGroup ShiftTemplateGroupID ShiftTemplateGroupID

Indexes

Triggers

Original SQL

-- 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