Table of Contents



pears.TempProvTimeSheetHistory

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

Description

History for provisional timesheets.

Columns

Column Type Null Default Comment
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 current timestamp
ExternalUserID char(40) NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
TempProvTimeSheet TempProvTimeSheetID pears.TempProvTimeSheet (TempProvTimeSheetID) ON DELETE SET NULL
TempTimesheet TempTimeSheetID pears.TempTimeSheet (TempTimeSheetID) ON DELETE SET NULL
staff StaffID pears.staff (staffid) ON DELETE SET NULL

Referenced By

Indexes

Name Type Columns Detail
TempProvTimesheetHistory_ExternalUserIDWhenEntered Index ExternalUserID, WhenEntered

Triggers

Original SQL

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