ACC (Roles-Areas)
| Documentation | Access control |
| Name | ACC |
| Title | Roles-Areas |
| Module | Access control |
Roles access to areas.
Roles-Areas n-n relationship table.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | ACCID (ID) | int | Row ID | |||||
| Row ID |
||||||||
| 2 | ROLID (Role) | int | ROL (Roles) | Role ID | ||||
| Role ID References: ROL (Roles) |
||||||||
| 3 | AREID (Area) | int | ARE (Areas) | Area ID | ||||
| Area ID References: ARE (Areas) |
||||||||
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 |
||||
| ACC (Roles-Areas) | ROL (Roles) | ACC.ROLID = ROL.ROLID | User-defined relation |
|
|
ACC.ROLID = ROL.ROLID Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| User-defined primary key | ACCID | ||
Uses
| Name |
|---|
|
ACC (Roles-Areas)
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 18:21