fam_role

4 rows


Description

A role is a qualifier that can be assigned to a user in order to identify a privilege within the context of an application.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
role_id int8 19 √ null
fam_access_control_privilege.role_id reffam_access_control_privilege_role R
fam_group_role_xref.role_id reffam_role17 R
fam_role.parent_role_id reffam_role23 R
fam_user_role_xref.role_id reffam_role12 R

Automatically generated key used to identify the uniqueness of a Role within the FAM Application
role_name varchar 100 null
role_purpose varchar 300 √ null
parent_role_id int8 19 √ null
fam_role.role_id reffam_role23 R

Automatically generated key used to identify the uniqueness of a Role within the FAM Application
application_id int8 19 null
fam_application.application_id reffam_application22 R
client_number_id int8 19 √ null
fam_forest_client.client_number_id reffam_forest_client24 R

Sequentially assigned number to identify a ministry client.
create_user varchar 100 null

The user or proxy account that created the record.
create_date timestamptz 35,6 CURRENT_TIMESTAMP

The date and time the record was created.
update_user varchar 100 √ null

The user or proxy account that created or last updated the record.
update_date timestamptz 35,6 CURRENT_TIMESTAMP

The date and time the record was created or last updated.
role_type_code varchar 2 null
fam_role_type.role_type_code reffam_role_type R

Identifies if the role is an abstract or concrete role. Users should only be assigned to roles where role_type=concrete
display_name varchar 100 √ null

Human redable name for the role

Indexes

Constraint Name Type Sort Column(s)
fam_rle_pk Primary key Asc role_id
fam_rlnm_app_uk Must be unique Asc/Asc role_name + application_id
Ref1223 Performance Asc parent_role_id
Ref424 Performance Asc client_number_id
Ref722 Performance Asc application_id

Relationships

Close relationships within degrees of separation