application_status

-1 rows


Description

Table containing information about possible application statuses

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
attachment.application_status_id attachment_application_status_id_fkey R

Unique ID for the application_status
application_id int4 10 √ null
application.id application_status_application_id_fkey R

ID of the application this status belongs to
status varchar 1000 √ null
application_status_type.name application_status_status_fkey R

The status of the application
created_by int4 10 √ null
ccbc_user.id application_status_created_by_fkey R

created by user id
created_at timestamptz 35,6 now()

created at timestamp
change_reason varchar 1000 √ null

Change reason for analyst status change
archived_by int4 10 √ null
ccbc_user.id application_status_archived_by_fkey R

archived by user id
archived_at timestamptz 35,6 √ null

archived at timestamp
updated_by int4 10 √ null
ccbc_user.id application_status_updated_by_fkey R

updated by user id
updated_at timestamptz 35,6 now()

updated at timestamp

Indexes

Constraint Name Type Sort Column(s)
application_status_pkey Primary key Asc id
application_status_application_id_index Performance Asc application_id
ccbc_public_application_status_archived_by_foreign_key Performance Asc archived_by
ccbc_public_application_status_created_by_foreign_key Performance Asc created_by
ccbc_public_application_status_updated_by_foreign_key Performance Asc updated_by

Relationships

Close relationships within degrees of separation