fam_user_role_xref

-1 rows


Description

User Role Xref is a cross-reference object that allows for the identification of Roles assigned to a user, as well as the users that belong to a given Role

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id int8 19 null
fam_user.user_id reffam_user10 R

Automatically generated key used to identify the uniqueness of a User within the FAM Application

role_id int8 19 null
fam_role.role_id reffam_role12 R

Automatically generated key used to identify the uniqueness of a Role within the FAM Application

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.

user_role_xref_id int8 19 null

Automatically generated key used to identify the uniqueness of a FamUserRoleXref within the FAM Application

Indexes

Constraint Name Type Sort Column(s)
fam_usr_rle_pk Primary key Asc user_role_xref_id
fam_usr_rle_usr_id_rle_id_uk Must be unique Asc/Asc user_id + role_id
Ref1212 Performance Asc role_id
Ref310 Performance Asc user_id

Relationships