====== pears.CardReaderSettings ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Description =====
Configuration for each individual Time & Attendance site / system.

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **MachineID** | char(20) | NOT NULL |  |  |
| Description | char(250) | NOT NULL |  |  |
| ShortDescription | char(60) | NULL |  |  |
| maxbreaklength | integer | NULL | 120 |  |
| MaxLateness | integer | NULL | 3 |  |
| MaxEarlyness | integer | NULL | 2 |  |
| maxshiftlength | integer | NULL | 840 |  |
| defaultshiftlength | integer | NULL | 480 |  |
| MinBeforeExtending | integer | NULL | 30 |  |
| MinBeforeExtendStart | integer | NULL | 30 |  |
| MaxExtraBreakTime | integer | NULL | 5 |  |
| MinBreakLength | integer | NULL | 60 |  |
| BearBoxLinked | smallint | NULL |  |  |
| LastIdentifier | integer | NULL |  |  |

===== Primary Key =====
  * MachineID

===== Foreign Keys =====
  * No outgoing foreign keys found.

===== Referenced By =====
^ Table ^ Constraint ^ Columns ^ Referenced columns ^
| [[database:tables:pears_cardreadercard|pears.CardReaderCard]] | CardReaderSettings | MachineID | MachineID |
| [[database:tables:pears_cardreaderimport|pears.CardReaderImport]] | CardReaderSettings | MachineID | MachineID |
| [[database:tables:pears_cardreaderlog|pears.CardReaderLog]] | CardReaderSettings | MachineID | MachineID |
| [[database:tables:pears_cardreaderoverridesettings|pears.CardReaderOverrideSettings]] | CardReaderSettings | MachineID | MachineID |
| [[database:tables:pears_cardreadershift|pears.CardReaderShift]] | CardReaderSettings | MachineID | MachineID |

===== Indexes =====
  * No indexes found.

===== Triggers =====
  * No triggers found.

===== Original SQL =====
<code sql>
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."CardReaderSettings"
-- Table comment: Configuration for each individual Time & Attendance site / system.
-- Statement count: 2

CREATE TABLE "pears"."CardReaderSettings" (
    "MachineID"                      char(20) NOT NULL
   ,"Description"                    char(250) NOT NULL
   ,"ShortDescription"               char(60) NULL
   ,"maxbreaklength"                 integer NULL DEFAULT 120
   ,"MaxLateness"                    integer NULL DEFAULT 3
   ,"MaxEarlyness"                   integer NULL DEFAULT 2
   ,"maxshiftlength"                 integer NULL DEFAULT 840
   ,"defaultshiftlength"             integer NULL DEFAULT 480
   ,"MinBeforeExtending"             integer NULL DEFAULT 30
   ,"MinBeforeExtendStart"           integer NULL DEFAULT 30
   ,"MaxExtraBreakTime"              integer NULL DEFAULT 5
   ,"MinBreakLength"                 integer NULL DEFAULT 60
   ,"BearBoxLinked"                  smallint NULL
   ,"LastIdentifier"                 integer NULL
   ,PRIMARY KEY ("MachineID" ASC) 
)
go


COMMENT ON TABLE "pears"."CardReaderSettings" IS 
	'Configuration for each individual Time & Attendance site / system.'
go
</code>