Table of Contents



pears.CardReaderImport

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

Description

Import table for Time & Attendance data (eg card swipes etc).

Columns

Column Type Null Default Comment
ID char(20) NOT NULL
BearBoxID integer NULL
MachineID char(20) NULL
CardID char(20) NULL
location char(100) NULL
thetime timestamp NULL
whenentered timestamp NULL
processed smallint NULL
personid char(20) NULL
cardholder char(100) NULL
clockin smallint NULL
event char(20) NULL
misread smallint NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
CardReaderSettings MachineID pears.CardReaderSettings (MachineID)

Referenced By

Indexes

Name Type Columns Detail
CardReaderImport_personid Index personid
CardReaderImport_cardid Index CardID

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."CardReaderImport"
-- Table comment: Import table for Time & Attendance data (eg card swipes etc).
-- Statement count: 5
 
CREATE TABLE "pears"."CardReaderImport" (
    "ID"                             CHAR(20) NOT NULL
   ,"BearBoxID"                      INTEGER NULL
   ,"MachineID"                      CHAR(20) NULL
   ,"CardID"                         CHAR(20) NULL
   ,"location"                       CHAR(100) NULL
   ,"thetime"                        TIMESTAMP NULL
   ,"whenentered"                    TIMESTAMP NULL
   ,"processed"                      SMALLINT NULL
   ,"personid"                       CHAR(20) NULL
   ,"cardholder"                     CHAR(100) NULL
   ,"clockin"                        SMALLINT NULL
   ,"event"                          CHAR(20) NULL
   ,"misread"                        SMALLINT NULL
   ,PRIMARY KEY ("ID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."CardReaderImport" IS 
	'Import table for Time & Attendance data (eg card swipes etc).'
GO
 
 
ALTER TABLE "pears"."CardReaderImport"
    ADD FOREIGN KEY "CardReaderSettings" ("MachineID" ASC)
    REFERENCES "pears"."CardReaderSettings" ("MachineID")
GO
 
 
CREATE INDEX "CardReaderImport_personid" ON "pears"."CardReaderImport"
    ( "personid" )
GO
 
 
CREATE INDEX "CardReaderImport_cardid" ON "pears"."CardReaderImport"
    ( "CardID" )
GO