ENT (Entries)
| Documentation | Access control |
| Name | ENT |
| Title | Entries |
| Module | Events |
Attempt to enter doors. Status defines whether successful or failed.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | TIM (Time) | char(10) | Date and time of entry. MMDDYYHH24mm | |||||
| Date and time of entry. MMDDYYHH24mm |
||||||||
| 2 | GATID (Door) | int | GAT (Doors) | Door ID | ||||
| Door ID References: GAT (Doors) |
||||||||
| 3 | CARID (Card) | int | CAR (Cards) | Card ID | ||||
| Card ID References: CAR (Cards) |
||||||||
| 4 | STA (Status) | char(1) | Status. O - access granted, door opened. F - access failed | |||||
| Status. O - access granted, door opened. F - access failed |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| ENT (Entries) | CAR (Cards) | ENT.CARID = CAR.CARID | User-defined relation |
|
|
ENT.CARID = CAR.CARID Name: User-defined relation |
||||
| ENT (Entries) | GAT (Doors) | ENT.GATID = GAT.GATID | User-defined relation |
|
|
ENT.GATID = GAT.GATID Name: User-defined relation |
||||
Uses
| Name |
|---|
|
ENT (Entries)
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 18:28