pears.TempProvTimeSheetHistory

History for provisional timesheets.

• TempProvTimeSheetHistoryID

• No incoming foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TempProvTimeSheetHistory"
-- Table comment: History for provisional timesheets.
-- Statement count: 6
 
CREATE TABLE "pears"."TempProvTimeSheetHistory" (
    "TempProvTimeSheetHistoryID"     CHAR(20) NOT NULL
   ,"TempProvTimeSheetID"            CHAR(20) NULL
   ,"TempTimeSheetID"                CHAR(20) NULL
   ,"SerialNumber"                   CHAR(12) NULL
   ,"OldStatus"                      INTEGER NULL
   ,"NewStatus"                      INTEGER NULL
   ,"Description"                    CHAR(250) NULL
   ,"StaffID"                        CHAR(20) NULL
   ,"WhenEntered"                    TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,"ExternalUserID"                 CHAR(40) NULL
   ,PRIMARY KEY ("TempProvTimeSheetHistoryID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."TempProvTimeSheetHistory" IS 
	'History for provisional timesheets.'
GO
 
 
ALTER TABLE "pears"."TempProvTimeSheetHistory"
    ADD FOREIGN KEY "TempProvTimeSheet" ("TempProvTimeSheetID" ASC)
    REFERENCES "pears"."TempProvTimeSheet" ("TempProvTimeSheetID")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."TempProvTimeSheetHistory"
    ADD FOREIGN KEY "TempTimesheet" ("TempTimeSheetID" ASC)
    REFERENCES "pears"."TempTimeSheet" ("TempTimeSheetID")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."TempProvTimeSheetHistory"
    ADD FOREIGN KEY "staff" ("StaffID" ASC)
    REFERENCES "pears"."staff" ("staffid")
    ON DELETE SET NULL
GO
 
 
CREATE INDEX "TempProvTimesheetHistory_ExternalUserIDWhenEntered" ON "pears"."TempProvTimeSheetHistory"
    ( "ExternalUserID","WhenEntered" DESC )
GO