Table of Contents



pears.CardReaderLog

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

Description

History of card swipes / activity / adjustments. Used for reporting.

Columns

Column Type Null Default Comment
CardReaderLogID char(20) NOT NULL
MachineID char(20) NULL
CardID char(20) NULL
personid char(20) NULL
LogText long varchar NULL
WhenEntered timestamp NULL current timestamp
clockintime timestamp NULL
LogType char(1) NULL
MatchedToShiftID char(20) NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
CardReaderSettings MachineID pears.CardReaderSettings (MachineID)
tempshift MatchedToShiftID pears.TempShift (TempShiftID) ON DELETE SET NULL

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."CardReaderLog"
-- Table comment: History of card swipes / activity / adjustments. Used for reporting.
-- Statement count: 4
 
CREATE TABLE "pears"."CardReaderLog" (
    "CardReaderLogID"                CHAR(20) NOT NULL
   ,"MachineID"                      CHAR(20) NULL
   ,"CardID"                         CHAR(20) NULL
   ,"personid"                       CHAR(20) NULL
   ,"LogText"                        long VARCHAR NULL
   ,"WhenEntered"                    TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,"clockintime"                    TIMESTAMP NULL
   ,"LogType"                        CHAR(1) NULL
   ,"MatchedToShiftID"               CHAR(20) NULL
   ,PRIMARY KEY ("CardReaderLogID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."CardReaderLog" IS 
	'History of card swipes / activity / adjustments. Used for reporting.'
GO
 
 
ALTER TABLE "pears"."CardReaderLog"
    ADD FOREIGN KEY "CardReaderSettings" ("MachineID" ASC)
    REFERENCES "pears"."CardReaderSettings" ("MachineID")
GO
 
 
ALTER TABLE "pears"."CardReaderLog"
    ADD FOREIGN KEY "tempshift" ("MatchedToShiftID" ASC)
    REFERENCES "pears"."TempShift" ("TempShiftID")
    ON DELETE SET NULL
GO