fam_user_group_xref

-1 rows


Description

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

Columns

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

Automatically generated key used to identify the uniqueness of a User within the FAM Application
group_id int8 19 null
fam_group.group_id reffam_group30 R
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.

Indexes

Constraint Name Type Sort Column(s)
fam_usr_rle_pk_1 Primary key Asc/Asc user_id + group_id
Ref230 Performance Asc group_id
Ref329 Performance Asc user_id

Relationships

Close relationships within degrees of separation