ARE (Areas)
| Documentation | Access control |
| Name | ARE |
| Title | Areas |
| Module | Infrastucture |
Functional access control areas.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | AREID (ID) | int | Area ID | |||||
| Area ID |
||||||||
| 2 | ARENAM (Name) | char(50) | Name of the area | |||||
| Name of the area |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| ACC (Roles-Areas) | ARE (Areas) | ACC.AREID = ARE.AREID | User-defined relation |
|
|
ACC.AREID = ARE.AREID Name: User-defined relation |
||||
| ARG (Areas-Doors) | ARE (Areas) | ARG.AREID = ARE.AREID | User-defined relation |
|
|
ARG.AREID = ARE.AREID Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| User-defined primary key | AREID | ||
Used by
| Name |
|---|
|
ARE (Areas)
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 17:49