pears.TempShiftPlanAuthorise

Record of (customer) authorisation of individual TempShiftPlan records.

• TempShiftPlanID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TempShiftPlanAuthorise"
-- Table comment: Record of (customer) authorisation of individual TempShiftPlan records.
-- Statement count: 3
 
CREATE TABLE "pears"."TempShiftPlanAuthorise" (
    "AuthorisedBy"                   CHAR(50) NULL
   ,"TempShiftPlanID"                CHAR(20) NOT NULL
   ,"WhoEntered"                     CHAR(20) NULL
   ,"WhenEntered"                    TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,PRIMARY KEY ("TempShiftPlanID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."TempShiftPlanAuthorise" IS 
	'Record of (customer) authorisation of individual TempShiftPlan records.'
GO
 
 
ALTER TABLE "pears"."TempShiftPlanAuthorise"
    ADD NOT NULL FOREIGN KEY "TempShiftPlan" ("TempShiftPlanID" ASC)
    REFERENCES "pears"."TempShiftPlan" ("TempShiftPlanID")
    ON DELETE CASCADE
GO