191 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| project_information_data_updated_by_fkey |
|
|
Restrict delete | ||
| project_information_data_created_by_fkey |
|
|
Restrict delete | ||
| project_information_data_archived_by_fkey |
|
|
Restrict delete | ||
| project_information_data_application_id_fkey |
|
|
Restrict delete | ||
| email_record_updated_by_fkey |
|
|
Restrict delete | ||
| email_record_archived_by_fkey |
|
|
Restrict delete | ||
| email_record_created_by_fkey |
|
|
Restrict delete | ||
| assessment_data_assessment_data_type_fkey |
|
|
Restrict delete | ||
| assessment_data_created_by_fkey |
|
|
Restrict delete | ||
| assessment_data_application_id_fkey |
|
|
Restrict delete | ||
| assessment_data_updated_by_fkey |
|
|
Restrict delete | ||
| assessment_data_archived_by_fkey |
|
|
Restrict delete | ||
| application_form_template_9_data_application_id_fkey |
|
|
Restrict delete | ||
| application_form_template_9_data_archived_by_fkey |
|
|
Restrict delete | ||
| application_form_template_9_data_created_by_fkey |
|
|
Restrict delete | ||
| application_form_template_9_data_updated_by_fkey |
|
|
Restrict delete | ||
| application_gis_assessment_hh_created_by_fkey |
|
|
Restrict delete | ||
| application_gis_assessment_hh_updated_by_fkey |
|
|
Restrict delete | ||
| application_gis_assessment_hh_application_id_fkey |
|
|
Restrict delete | ||
| application_gis_assessment_hh_archived_by_fkey |
|
|
Restrict delete | ||
| application_sow_data_application_id_fkey |
|
|
Restrict delete | ||
| application_sow_data_created_by_fkey |
|
|
Restrict delete | ||
| application_sow_data_archived_by_fkey |
|
|
Restrict delete | ||
| application_sow_data_updated_by_fkey |
|
|
Restrict delete | ||
| rfi_data_updated_by_fkey |
|
|
Restrict delete | ||
| rfi_data_rfi_data_status_type_id_fkey |
|
|
Restrict delete | ||
| rfi_data_created_by_fkey |
|
|
Restrict delete | ||
| rfi_data_archived_by_fkey |
|
|
Restrict delete | ||
| application_form_data_application_id_fkey |
|
|
Restrict delete | ||
| application_form_data_form_data_id_fkey |
|
|
Restrict delete | ||
| application_dependencies_archived_by_fkey |
|
|
Restrict delete | ||
| application_dependencies_application_id_fkey |
|
|
Restrict delete | ||
| application_dependencies_updated_by_fkey |
|
|
Restrict delete | ||
| application_dependencies_created_by_fkey |
|
|
Restrict delete | ||
| application_claims_excel_data_updated_by_fkey |
|
|
Restrict delete | ||
| application_claims_excel_data_application_id_fkey |
|
|
Restrict delete | ||
| application_claims_excel_data_created_by_fkey |
|
|
Restrict delete | ||
| application_claims_excel_data_archived_by_fkey |
|
|
Restrict delete | ||
| analyst_created_by_fkey |
|
|
Restrict delete | ||
| analyst_updated_by_fkey |
|
|
Restrict delete | ||
| analyst_archived_by_fkey |
|
|
Restrict delete | ||
| cbc_project_communities_archived_by_fkey |
|
|
Restrict delete | ||
| cbc_project_communities_created_by_fkey |
|
|
Restrict delete | ||
| cbc_project_communities_updated_by_fkey |
|
|
Restrict delete | ||
| cbc_project_communities_cbc_id_fkey |
|
|
Restrict delete | ||
| cbc_project_communities_communities_source_data_id_fkey |
|
|
Restrict delete | ||
| intake_archived_by_fkey |
|
|
Restrict delete | ||
| intake_updated_by_fkey |
|
|
Restrict delete | ||
| intake_created_by_fkey |
|
|
Restrict delete | ||
| intake_counter_id_fkey |
|
|
Restrict delete | ||
| application_pending_change_request_created_by_fkey |
|
|
Restrict delete | ||
| application_pending_change_request_application_id_fkey |
|
|
Restrict delete | ||
| application_pending_change_request_archived_by_fkey |
|
|
Restrict delete | ||
| application_pending_change_request_updated_by_fkey |
|
|
Restrict delete | ||
| reporting_gcpe_updated_by_fkey |
|
|
Restrict delete | ||
| reporting_gcpe_created_by_fkey |
|
|
Restrict delete | ||
| reporting_gcpe_archived_by_fkey |
|
|
Restrict delete | ||
| announcement_updated_by_fkey |
|
|
Restrict delete | ||
| announcement_created_by_fkey |
|
|
Restrict delete | ||
| announcement_archived_by_fkey |
|
|
Restrict delete | ||
| application_milestone_excel_data_application_id_fkey |
|
|
Restrict delete | ||
| application_milestone_excel_data_created_by_fkey |
|
|
Restrict delete | ||
| application_milestone_excel_data_updated_by_fkey |
|
|
Restrict delete | ||
| application_milestone_excel_data_archived_by_fkey |
|
|
Restrict delete | ||
| communities_source_data_created_by_fkey |
|
|
Restrict delete | ||
| communities_source_data_updated_by_fkey |
|
|
Restrict delete | ||
| communities_source_data_archived_by_fkey |
|
|
Restrict delete | ||
| application_internal_description_created_by_fkey |
|
|
Restrict delete | ||
| application_internal_description_updated_by_fkey |
|
|
Restrict delete | ||
| application_internal_description_archived_by_fkey |
|
|
Restrict delete | ||
| application_internal_description_application_id_fkey |
|
|
Restrict delete | ||
| record_version_created_by_fkey |
|
|
Restrict delete | ||
| cbc_data_cbc_id_fkey |
|
|
Restrict delete | ||
| cbc_data_archived_by_fkey |
|
|
Restrict delete | ||
| cbc_data_created_by_fkey |
|
|
Restrict delete | ||
| cbc_data_updated_by_fkey |
|
|
Restrict delete | ||
| fk_cbc_data |
|
|
Restrict delete | ||
| attachment_created_by_fkey |
|
|
Restrict delete | ||
| attachment_application_status_id_fkey |
|
|
Restrict delete | ||
| attachment_application_id_fkey |
|
|
Restrict delete | ||
| attachment_updated_by_fkey |
|
|
Restrict delete | ||
| attachment_archived_by_fkey |
|
|
Restrict delete | ||
| ccbc_user_archived_by_fkey |
|
|
Restrict delete | ||
| ccbc_user_updated_by_fkey |
|
|
Restrict delete | ||
| ccbc_user_created_by_fkey |
|
|
Restrict delete | ||
| cbc_updated_by_fkey |
|
|
Restrict delete | ||
| cbc_created_by_fkey |
|
|
Restrict delete | ||
| cbc_archived_by_fkey |
|
|
Restrict delete | ||
| application_archived_by_fkey |
|
|
Restrict delete | ||
| application_updated_by_fkey |
|
|
Restrict delete | ||
| application_created_by_fkey |
|
|
Restrict delete | ||
| application_intake_id_fkey |
|
|
Restrict delete | ||
| application_analyst_lead_application_id_fkey |
|
|
Restrict delete | ||
| application_analyst_lead_archived_by_fkey |
|
|
Restrict delete | ||
| application_analyst_lead_analyst_id_fkey |
|
|
Restrict delete | ||
| application_analyst_lead_updated_by_fkey |
|
|
Restrict delete | ||
| application_analyst_lead_created_by_fkey |
|
|
Restrict delete | ||
| application_milestone_data_application_id_fkey |
|
|
Restrict delete | ||
| application_milestone_data_updated_by_fkey |
|
|
Restrict delete | ||
| application_milestone_data_created_by_fkey |
|
|
Restrict delete | ||
| application_milestone_data_archived_by_fkey |
|
|
Restrict delete | ||
| change_request_data_updated_by_fkey |
|
|
Restrict delete | ||
| change_request_data_archived_by_fkey |
|
|
Restrict delete | ||
| change_request_data_created_by_fkey |
|
|
Restrict delete | ||
| change_request_data_application_id_fkey |
|
|
Restrict delete | ||
| cbc_data_change_reason_cbc_data_id_fkey |
|
|
Restrict delete | ||
| cbc_data_change_reason_archived_by_fkey |
|
|
Restrict delete | ||
| cbc_data_change_reason_created_by_fkey |
|
|
Restrict delete | ||
| cbc_data_change_reason_updated_by_fkey |
|
|
Restrict delete | ||
| conditional_approval_data_updated_by_fkey |
|
|
Restrict delete | ||
| conditional_approval_data_created_by_fkey |
|
|
Restrict delete | ||
| conditional_approval_data_application_id_fkey |
|
|
Restrict delete | ||
| conditional_approval_data_archived_by_fkey |
|
|
Restrict delete | ||
| application_community_report_excel_data_application_id_fkey |
|
|
Restrict delete | ||
| application_community_report_excel_data_created_by_fkey |
|
|
Restrict delete | ||
| application_community_report_excel_data_archived_by_fkey |
|
|
Restrict delete | ||
| application_community_report_excel_data_updated_by_fkey |
|
|
Restrict delete | ||
| application_announced_updated_by_fkey |
|
|
Restrict delete | ||
| application_announced_created_by_fkey |
|
|
Restrict delete | ||
| application_announced_archived_by_fkey |
|
|
Restrict delete | ||
| application_announced_application_id_fkey |
|
|
Restrict delete | ||
| cbc_project_updated_by_fkey |
|
|
Restrict delete | ||
| cbc_project_created_by_fkey |
|
|
Restrict delete | ||
| cbc_project_archived_by_fkey |
|
|
Restrict delete | ||
| application_gis_data_created_by_fkey |
|
|
Restrict delete | ||
| application_gis_data_updated_by_fkey |
|
|
Restrict delete | ||
| application_gis_data_application_id_fkey |
|
|
Restrict delete | ||
| application_gis_data_archived_by_fkey |
|
|
Restrict delete | ||
| application_gis_data_batch_id_fkey |
|
|
Restrict delete | ||
| sow_tab_2_updated_by_fkey |
|
|
Restrict delete | ||
| sow_tab_2_sow_id_fkey |
|
|
Restrict delete | ||
| sow_tab_2_created_by_fkey |
|
|
Restrict delete | ||
| sow_tab_2_archived_by_fkey |
|
|
Restrict delete | ||
| application_status_status_fkey |
|
|
Restrict delete | ||
| application_status_updated_by_fkey |
|
|
Restrict delete | ||
| application_status_created_by_fkey |
|
|
Restrict delete | ||
| application_status_archived_by_fkey |
|
|
Restrict delete | ||
| application_status_application_id_fkey |
|
|
Restrict delete | ||
| application_announcement_application_id_fkey |
|
|
Restrict delete | ||
| application_announcement_announcement_id_fkey |
|
|
Restrict delete | ||
| application_announcement_updated_by_fkey |
|
|
Restrict delete | ||
| application_announcement_archived_by_fkey |
|
|
Restrict delete | ||
| application_announcement_created_by_fkey |
|
|
Restrict delete | ||
| form_form_type_fkey |
|
|
Restrict delete | ||
| sow_tab_1_created_by_fkey |
|
|
Restrict delete | ||
| sow_tab_1_updated_by_fkey |
|
|
Restrict delete | ||
| sow_tab_1_sow_id_fkey |
|
|
Restrict delete | ||
| sow_tab_1_archived_by_fkey |
|
|
Restrict delete | ||
| cbc_application_pending_change_request_created_by_fkey |
|
|
Restrict delete | ||
| cbc_application_pending_change_request_cbc_id_fkey |
|
|
Restrict delete | ||
| cbc_application_pending_change_request_archived_by_fkey |
|
|
Restrict delete | ||
| cbc_application_pending_change_request_updated_by_fkey |
|
|
Restrict delete | ||
| application_rfi_data_rfi_data_id_fkey |
|
|
Restrict delete | ||
| application_rfi_data_application_id_fkey |
|
|
Restrict delete | ||
| sow_tab_7_created_by_fkey |
|
|
Restrict delete | ||
| sow_tab_7_archived_by_fkey |
|
|
Restrict delete | ||
| sow_tab_7_updated_by_fkey |
|
|
Restrict delete | ||
| sow_tab_7_sow_id_fkey |
|
|
Restrict delete | ||
| application_project_type_archived_by_fkey |
|
|
Restrict delete | ||
| application_project_type_updated_by_fkey |
|
|
Restrict delete | ||
| application_project_type_created_by_fkey |
|
|
Restrict delete | ||
| application_project_type_application_id_fkey |
|
|
Restrict delete | ||
| application_community_progress_report_data_updated_by_fkey |
|
|
Restrict delete | ||
| application_community_progress_report_data_created_by_fkey |
|
|
Restrict delete | ||
| application_community_progress_report_data_archived_by_fkey |
|
|
Restrict delete | ||
| application_community_progress_report_data_application_id_fkey |
|
|
Restrict delete | ||
| gis_data_updated_by_fkey |
|
|
Restrict delete | ||
| gis_data_archived_by_fkey |
|
|
Restrict delete | ||
| gis_data_created_by_fkey |
|
|
Restrict delete | ||
| sow_tab_8_archived_by_fkey |
|
|
Restrict delete | ||
| sow_tab_8_updated_by_fkey |
|
|
Restrict delete | ||
| sow_tab_8_created_by_fkey |
|
|
Restrict delete | ||
| sow_tab_8_sow_id_fkey |
|
|
Restrict delete | ||
| application_claims_data_created_by_fkey |
|
|
Restrict delete | ||
| application_claims_data_updated_by_fkey |
|
|
Restrict delete | ||
| application_claims_data_archived_by_fkey |
|
|
Restrict delete | ||
| application_claims_data_application_id_fkey |
|
|
Restrict delete | ||
| notification_created_by_fkey |
|
|
Restrict delete | ||
| notification_application_id_fkey |
|
|
Restrict delete | ||
| notification_archived_by_fkey |
|
|
Restrict delete | ||
| notification_email_record_id_fkey |
|
|
Restrict delete | ||
| notification_updated_by_fkey |
|
|
Restrict delete | ||
| application_package_archived_by_fkey |
|
|
Restrict delete | ||
| application_package_application_id_fkey |
|
|
Restrict delete | ||
| application_package_created_by_fkey |
|
|
Restrict delete | ||
| application_package_updated_by_fkey |
|
|
Restrict delete | ||
| form_data_form_schema_id_fkey |
|
|
Restrict delete | ||
| form_data_archived_by_fkey |
|
|
Restrict delete | ||
| form_data_updated_by_fkey |
|
|
Restrict delete | ||
| form_data_created_by_fkey |
|
|
Restrict delete | ||
| form_data_form_data_status_type_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| application_status_type | no_invisible_status | ((visible_by_analyst OR visible_by_applicant)) |
| record_version | record_version_check | (((COALESCE(record_id, old_record_id) IS NOT NULL) OR (op = 'TRUNCATE'::audit.operation))) |
| record_version | record_version_check1 | (((op = ANY (ARRAY['INSERT'::audit.operation, 'UPDATE'::audit.operation])) = (record_id IS NOT NULL))) |
| record_version | record_version_check2 | (((op = ANY (ARRAY['INSERT'::audit.operation, 'UPDATE'::audit.operation])) = (record IS NOT NULL))) |
| record_version | record_version_check3 | (((op = ANY (ARRAY['UPDATE'::audit.operation, 'DELETE'::audit.operation])) = (old_record_id IS NOT NULL))) |
| record_version | record_version_check4 | (((op = ANY (ARRAY['UPDATE'::audit.operation, 'DELETE'::audit.operation])) = (old_record IS NOT NULL))) |
| application_project_type | application_project_type_project_type_check | ((((project_type)::text = ANY ((ARRAY['lastMile'::character varying, 'lastMileAndTransport'::character varying, 'transport'::character varying])::text[])) OR (project_type IS NULL))) |
| application_package | application_package_package_check | ((package > 0)) |