Store role information
Data model
Fields
| Field | Type | Description |
|---|---|---|
| modification_date | DATETIME | Date of last modification |
| modified_by | INT | Identifier of the last user who modified the record |
| role_application_id* | INT | App ID |
| role_concept_id | INT | Concept identifier |
| role_description | NVARCHAR (510) | Role Description |
| role_id* | INT | Role ID |
| role_is_active* | BIT | Determine if a role is active |
| role_is_builtin* | BIT | Indicator if a role is predefined |
| role_name* | NVARCHAR (80) | Role Name |
Primary Key
| PK_AFW_ROLES |
|---|
| role_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| role_application_id* | dbo.AFW_APPLICATIONS | appl_id | FK01_AFW_ROLES |
| role_concept_id | dbo.AFW_CONCEPT | id | FK02_AFW_ROLES |