application

-1 rows


Description

Table containing the data associated with the CCBC respondents application

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
application_analyst_lead.application_id application_analyst_lead_application_id_fkey R
application_announcement.application_id application_announcement_application_id_fkey R
application_claims_data.application_id application_claims_data_application_id_fkey R
application_claims_excel_data.application_id application_claims_excel_data_application_id_fkey R
application_community_progress_report_data.application_id application_community_progress_report_data_application_id_fkey R
application_community_report_excel_data.application_id application_community_report_excel_data_application_id_fkey R
application_form_data.application_id application_form_data_application_id_fkey R
application_gis_assessment_hh.application_id application_gis_assessment_hh_application_id_fkey R
application_gis_data.application_id application_gis_data_application_id_fkey R
application_internal_description.application_id application_internal_description_application_id_fkey R
application_milestone_data.application_id application_milestone_data_application_id_fkey R
application_milestone_excel_data.application_id application_milestone_excel_data_application_id_fkey R
application_package.application_id application_package_application_id_fkey R
application_pending_change_request.application_id application_pending_change_request_application_id_fkey R
application_project_type.application_id application_project_type_application_id_fkey R
application_rfi_data.application_id application_rfi_data_application_id_fkey R
application_sow_data.application_id application_sow_data_application_id_fkey R
application_status.application_id application_status_application_id_fkey R
assessment_data.application_id assessment_data_application_id_fkey R
attachment.application_id attachment_application_id_fkey R
change_request_data.application_id change_request_data_application_id_fkey R
conditional_approval_data.application_id conditional_approval_data_application_id_fkey R
notification.application_id notification_application_id_fkey R
project_information_data.application_id project_information_data_application_id_fkey R

Primary key ID for the application
ccbc_number varchar 1000 √ null

Reference number assigned to the application
owner varchar 1000 null

The owner of the application, identified by its JWT sub
intake_id int4 10 √ null
intake.id application_intake_id_fkey R

The intake associated with the application, set when it is submitted
created_by int4 10 √ null
ccbc_user.id application_created_by_fkey R

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

created at timestamp
updated_by int4 10 √ null
ccbc_user.id application_updated_by_fkey R

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

updated at timestamp
archived_by int4 10 √ null
ccbc_user.id application_archived_by_fkey R

archived by user id
archived_at timestamptz 35,6 √ null

archived at timestamp

Indexes

Constraint Name Type Sort Column(s)
application_pkey Primary key Asc id
application_intake_id Performance Asc intake_id
ccbc_owner Performance Asc owner
ccbc_public_application_archived_by_foreign_key Performance Asc archived_by
ccbc_public_application_created_by_foreign_key Performance Asc created_by
ccbc_public_application_updated_by_foreign_key Performance Asc updated_by

Relationships

Close relationships within degrees of separation