pears.CardReaderShift

Shifts assembled from Time & Attendance data.

• CardReaderShiftID

• No incoming foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."CardReaderShift"
-- Table comment: Shifts assembled from Time & Attendance data.
-- Statement count: 6
 
CREATE TABLE "pears"."CardReaderShift" (
    "CardReaderShiftID"              CHAR(20) NOT NULL
   ,"MachineID"                      CHAR(20) NULL
   ,"CardID"                         CHAR(20) NULL
   ,"personid"                       CHAR(20) NULL
   ,"clockintime"                    TIMESTAMP NULL
   ,"clockouttime"                   TIMESTAMP NULL
   ,"breakminutes"                   INTEGER NULL
   ,"FailedToClockOutInTime"         SMALLINT NULL
   ,"ShiftStateWrong"                CHAR(1) NULL
   ,"WasExtended"                    SMALLINT NULL DEFAULT 0
   ,"NoShiftFound"                   SMALLINT NULL DEFAULT 0
   ,"WasLate"                        SMALLINT NULL DEFAULT 0
   ,"MatchedToShiftID"               CHAR(20) NULL
   ,PRIMARY KEY ("CardReaderShiftID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."CardReaderShift" IS 
	'Shifts assembled from Time & Attendance data.'
GO
 
 
ALTER TABLE "pears"."CardReaderShift"
    ADD FOREIGN KEY "CardReaderSettings" ("MachineID" ASC)
    REFERENCES "pears"."CardReaderSettings" ("MachineID")
GO
 
 
ALTER TABLE "pears"."CardReaderShift"
    ADD FOREIGN KEY "tempshift" ("MatchedToShiftID" ASC)
    REFERENCES "pears"."TempShift" ("TempShiftID")
    ON DELETE SET NULL
GO
 
 
CREATE INDEX "CardReaderShift_personid" ON "pears"."CardReaderShift"
    ( "personid" )
GO
 
 
CREATE INDEX "CardReaderShift_cardid" ON "pears"."CardReaderShift"
    ( "CardID" )
GO