Name |
Datatype |
Comment |
Is PK |
Is FK |
app_role_id |
bigint |
The automatically generated primary key of the app_role table. |
Yes |
No |
app_role_name |
varchar(255) |
The name of the Application Role. |
No |
No |
app_role_descr |
varchar(1024) |
A descriptive name of the Application Role. This descriptive name may be
localized.
|
No |
No |
defn_id |
bigint |
A Foreign Key to the Definition table. |
No |
Yes |
admin_type_id |
int |
A Foreign Key to the Administrator Type table. |
No |
Yes |
tmpl_app_role_id |
bigint |
A Foreign Key to the Application Role table. This indicates which Template Role
was used to create a built-in role in case some features concerning new
properties added to later release of the system will need to be added to
existing templates.
|
No |
Yes |
is_built_in |
bit |
Indicates that this instance of Application Role is a built-in instance that
cannot be changed by the end user.
|
No |
No |
user_type_id |
int |
A Foreign Key to the User Type table. |
No |
Yes |
defn_subtype_id |
int |
A Foreign Key to the Definition Subtype table. |
No |
Yes |