fam_application_admin

-1 rows


Description

Application Admin is a cross-reference object that allows for the identification of who are the administrators(User) for an Application, as well as which Applications the User can administer.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
application_admin_id int8 19 √ null

Automatically generated key used to identify the uniqueness of a User administers the Application.
user_id int8 19 null
fam_user.user_id reffam_application_admin_user R

Unique ID to reference and identify the user within FAM system.
application_id int8 19 null
fam_application.application_id reffam_application_admin_application R

Unique ID to reference and identify the application within FAM system.
create_user varchar 100 null

The user or proxy account that created the record.
create_date timestamp 29,6 CURRENT_DATE

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 timestamp 29,6 √ CURRENT_DATE

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

Indexes

Constraint Name Type Sort Column(s)
fam_app_admin_pk Primary key Asc application_admin_id
fam_app_admin_usr_app_uk Must be unique Asc/Asc user_id + application_id
ix_app_fam_fam_application_admin_application_id Performance Asc application_id
ix_app_fam_fam_application_admin_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation