fam_user

5 rows


Description

A user is a person or system that can authenticate and then interact with an application.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id int8 19 √ null
fam_access_control_privilege.user_id reffam_access_control_privilege_user R
fam_application_admin.user_id reffam_application_admin_user R
fam_privilege_change_audit.change_performer_user_id fk_change_performer_user R
fam_privilege_change_audit.change_target_user_id fk_change_target_user R
fam_user_group_xref.user_id reffam_user29 R
fam_user_role_xref.user_id reffam_user10 R
fam_user_terms_conditions.user_id reffam_user_terms_conditions_user R

Automatically generated key used to identify the uniqueness of a User within the FAM Application
user_guid varchar 32 √ null
cognito_user_id varchar 100 √ null
user_name varchar 100 null
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_type_code varchar 2 null
fam_user_type_code.user_type_code reffam_user_type R

Identifies which type of the user it belongs to; IDIR, BCeID etc.
business_guid varchar 32 √ null

The business guid of the user if is a business bceid user.
first_name varchar 50 √ null

The first name of the user
last_name varchar 50 √ null

The last name of the user.
email varchar 250 √ null

The email of the user.

Indexes

Constraint Name Type Sort Column(s)
fam_usr_pk Primary key Asc user_id
fam_usr_uk Must be unique Asc/Asc user_type_code + user_guid

Relationships

Close relationships within degrees of separation