pears.MasterRosterFailLog

Records of failure to create or fill shifts from a Master Roster.

• MasterRosterFailLogID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."MasterRosterFailLog"
-- Table comment: Records of failure to create or fill shifts from a Master Roster.
-- Statement count: 5
 
CREATE TABLE "pears"."MasterRosterFailLog" (
    "MasterRosterFailLogID"          CHAR(20) NOT NULL
   ,"MasterRosterShiftID"            CHAR(20) NOT NULL
   ,"PersonID"                       CHAR(20) NULL
   ,"ShiftDate"                      DATE NOT NULL
   ,"Details"                        long VARCHAR NULL
   ,"WhenEntered"                    TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,PRIMARY KEY ("MasterRosterFailLogID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."MasterRosterFailLog"."PersonID" IS 
	'Filled if booking failure, empty if creation failure'
GO
 
 
COMMENT ON TABLE "pears"."MasterRosterFailLog" IS 
	'Records of failure to create or fill shifts from a Master Roster.'
GO
 
 
ALTER TABLE "pears"."MasterRosterFailLog"
    ADD NOT NULL FOREIGN KEY "MasterRosterShift" ("MasterRosterShiftID" ASC)
    REFERENCES "pears"."MasterRosterShift" ("MasterRosterShiftID")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."MasterRosterFailLog"
    ADD FOREIGN KEY "person" ("PersonID" ASC)
    REFERENCES "pears"."Person" ("personid")
    ON DELETE CASCADE
GO