CRA (Cards-Access)
| Documentation | Access control |
| Name | CRA |
| Title | Cards-Access |
| Module | Access control |
Definition of access for individual cards. This is a list of roles assigned to a card. Role defines access to areas.
Card-Role n-n relationship table.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | CRAID (ID) | int | Row ID | |||||
| Row ID |
||||||||
| 2 | CARID (Card) | int | CAR (Cards) | Card ID | ||||
| Card ID References: CAR (Cards) |
||||||||
| 3 | ROLID (Role) | int | ROL (Roles) | Role ID | ||||
| Role ID References: ROL (Roles) |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| CRA (Cards-Access) | CAR (Cards) | CRA.CARID = CAR.CARID | User-defined relation |
|
|
CRA.CARID = CAR.CARID 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 | CRAID | ||
Uses
| Name |
|---|
|
CRA (Cards-Access)
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 18:21