fam_role_type

-1 rows


Description

A role type is a code that is associated with roles that will influence what can be associate with a role. At time of implementation an abstract role can only have other roles related to it, while a concrete role can only have users associated with it

Columns

Column Type Size Nulls Auto Default Children Parents Comments
role_type_code varchar 2 null
fam_role.role_type_code reffam_role_type R

role type code
description varchar 100 √ null

Description of what the role_type_code represents
effective_date timestamptz 35,6 CURRENT_TIMESTAMP

The date and time the code was effective.
expiry_date timestamptz 35,6 √ null

The date and time the code expired.
update_date timestamptz 35,6 CURRENT_TIMESTAMP

The date and time the record was created or last updated.

Indexes

Constraint Name Type Sort Column(s)
fam_role_type_code_pk Primary key Asc role_type_code

Relationships

Close relationships within degrees of separation