CAR (Cards)
| Documentation | Access control |
| Name | CAR |
| Title | Cards |
| Module | Access control |
| Sensitive | Y |
Access control cards are physical cards that open doors. Each card has an unique number printed on it.
Each card shas assigned exactly one empolyee. Info1 column holds employee number.
There can be more than one than one card for employee but it is assumed that each employee has no more that one active card at any given time.
Emp no | Employee | Status | |
C131943 | 1 | John Smith | Lost |
C132369 | 1 | John Smith | Stolen |
C132795 | 1 | John Smith | Active |
Columns
| Key | Name | Data type | Null | Attributes | References | Description | Sensitive | ||
|---|---|---|---|---|---|---|---|---|---|
| 1 | CARID (ID) | int | Row ID | ||||||
| Row ID |
|||||||||
| 2 | CARNO (Card no) | char(12) | Card number printed on the card | ||||||
| Card number printed on the card |
|||||||||
| 3 | FNAM (First name) | char(50) | Card holder first name | Y | |||||
| Card holder first name Sensitive: Y |
|||||||||
| 4 | LNAM (Last name) | char(50) | Card holder last name | Y | |||||
| Card holder last name Sensitive: Y |
|||||||||
| 5 | DEP (Dept) | char(50) | HR.HR.DEPT (Departments) | Department code | |||||
| Department code References: HR.HR.DEPT (Departments) |
|||||||||
| 6 | STA (Status) | char(1) | Status: A - active, D - disabled, E - expired, L - lost, S - stolen. Only cards with status A open doors. | ||||||
| Status: A - active, D - disabled, E - expired, L - lost, S - stolen. Only cards with status A open doors. |
|||||||||
| 7 | VAL (Valid thru) | char(6) | Date card after which it expires. If status is A then it is switched to E. Format: MMDDYY | ||||||
| Date card after which it expires. If status is A then it is switched to E. Format: MMDDYY |
|||||||||
| 8 | INF1 (Emp no) | char(50) | HR.HR.EMP (Employees) | Employee no | |||||
| Employee no References: HR.HR.EMP (Employees) |
|||||||||
| 9 | INF2 | char(50) | Unused | ||||||
| Unused |
|||||||||
| 10 | INF3 (Int/Ext) | char(50) | Internal/employees ('I'), external/partners ('E') | ||||||
| Internal/employees ('I'), external/partners ('E') |
|||||||||
| 11 | INF4 (Issued) | char(50) | Issued date. Format: MMDDYY | ||||||
| Issued date. Format: MMDDYY |
|||||||||
| 12 | INF5 | char(50) | Unused | ||||||
| Unused |
|||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| CAR (Cards) | HR.HR.DEPT (Departments) | CAR.DEP = HR.HR.DEPT.CODE | User-defined relation |
|
|
CAR.DEP = HR.HR.DEPT.CODE Name: User-defined relation |
||||
| CAR (Cards) | HR.HR.EMP (Employees) | CAR.INF1 = HR.HR.EMP.EMP_NO | User-defined relation |
|
|
CAR.INF1 = HR.HR.EMP.EMP_NO Name: User-defined relation |
||||
| CRA (Cards-Access) | CAR (Cards) | CRA.CARID = CAR.CARID | User-defined relation |
|
|
CRA.CARID = CAR.CARID Name: User-defined relation |
||||
| ENT (Entries) | CAR (Cards) | ENT.CARID = CAR.CARID | User-defined relation |
|
|
ENT.CARID = CAR.CARID Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| User-defined primary key | CARID | ||
Uses
| Name |
|---|
|
CAR (Cards)
|
Used by
| Name |
|---|
|
CAR (Cards)
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 18:11