ROL (Roles)
| Documentation | Access control |
| Name | ROL |
| Title | Roles |
| Module | Access control |
Roles, predefined set of access rules (areas) - e.g. sales, engineering, backoffice, ...
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | ROLID (ID) | int | Role ID | |||||
| Role ID |
||||||||
| 2 | ROLNAM (Name) | char(20) | Name | |||||
| Name |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| ACC (Roles-Areas) | ROL (Roles) | ACC.ROLID = ROL.ROLID | User-defined relation |
|
|
ACC.ROLID = ROL.ROLID Name: User-defined relation |
||||
| CRA (Cards-Access) | ROL (Roles) | CRA.ROLID = ROL.ROLID | User-defined relation |
|
|
CRA.ROLID = ROL.ROLID Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| User-defined primary key | ROLID | ||
Used by
| Name |
|---|
|
ROL (Roles)
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 17:49