pears.CardReaderCard

Current state (in or out) for each swipe card or equivalent.

• CardReaderCardID

• No incoming foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."CardReaderCard"
-- Table comment: Current state (in or out) for each swipe card or equivalent.
-- Statement count: 4
 
CREATE TABLE "pears"."CardReaderCard" (
    "CardReaderCardID"               CHAR(20) NOT NULL
   ,"MachineID"                      CHAR(20) NULL
   ,"CardID"                         CHAR(20) NULL
   ,"inorout"                        SMALLINT NULL
   ,PRIMARY KEY ("CardReaderCardID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."CardReaderCard" IS 
	'Current state (in or out) for each swipe card or equivalent.'
GO
 
 
ALTER TABLE "pears"."CardReaderCard"
    ADD FOREIGN KEY "CardReaderSettings" ("MachineID" ASC)
    REFERENCES "pears"."CardReaderSettings" ("MachineID")
GO
 
 
CREATE INDEX "CardReaderCard_cardid" ON "pears"."CardReaderCard"
    ( "CardID" )
GO