fam_application

-1 rows


Description

An application is a digital product that fulfills a specific user goal. It can be a front-end application, a back-end API, a combination of these, or something else entirely.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
application_id int8 19 √ null
fam_application_admin.application_id reffam_application_admin_application R
fam_application_client.application_id reffam_application31 R
fam_application_group_xref.application_id reffam_application20 R
fam_privilege_change_audit.application_id fk_application R
fam_role.application_id reffam_application22 R

Automatically generated key used to identify the uniqueness of an Application registered under FAM
application_name varchar 100 null
application_description varchar 200 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.
app_environment varchar 4 √ null
fam_app_environment.app_environment reffam_app_env R

Identifies which environment the application is for; DEV, TEST, PROD etc.

Indexes

Constraint Name Type Sort Column(s)
fam_app_pk Primary key Asc application_id
fam_app_name_uk Must be unique Asc application_name

Relationships

Close relationships within degrees of separation