GAT (Doors)
| Documentation | Access control |
| Name | GAT |
| Title | Doors |
| Module | Infrastucture |
Doors/gates
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | GATID (ID) | int | Door ID | |||||
| Door ID |
||||||||
| 2 | BLDID (Buidling) | int | BLD (Buildings) | ID of buidling door is located in | ||||
| ID of buidling door is located in References: BLD (Buildings) |
||||||||
| 3 | UID | char(12) | Unique door ID | |||||
| Unique door ID |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| GAT (Doors) | BLD (Buildings) | GAT.BLDID = BLD.BLDID | User-defined relation |
|
|
GAT.BLDID = BLD.BLDID Name: User-defined relation |
||||
| ARG (Areas-Doors) | GAT (Doors) | ARG.GATID = GAT.GATID | User-defined relation |
|
|
ARG.GATID = GAT.GATID Name: User-defined relation |
||||
| ENT (Entries) | GAT (Doors) | ENT.GATID = GAT.GATID | User-defined relation |
|
|
ENT.GATID = GAT.GATID Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| User-defined primary key | GATID | ||
Uses
| Name |
|---|
|
GAT (Doors)
|
Used by
| Name |
|---|
|
GAT (Doors)
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 18:05