91 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||||
|---|---|---|---|---|---|---|---|---|---|
| variable_section_default_values_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_default_valu_variable_id_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_default_values_variable_manifest_id_fkey |
|
|
Cascade on delete | ||||||
| variable_section_default_values_used_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_default_values_usage_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_default_values_display_style_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_default_valu_used_variable_id_used_variab_fkey |
|
|
Restrict delete | ||||||
| variable_section_default_values_used_variable_id_fkey |
|
|
Cascade on delete | ||||||
| variable_section_default_values_variable_id_fkey |
|
|
Cascade on delete | ||||||
| variable_link_values_variable_value_id_variable_id_variabl_fkey |
|
|
Restrict delete | ||||||
| variable_link_values_variable_value_id_fkey |
|
|
Cascade on delete | ||||||
| variable_link_values_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_link_values_variable_id_fkey |
|
|
Restrict delete | ||||||
| documents_project_id_fkey |
|
|
Restrict delete | ||||||
| documents_variable_manifest_id_fkey |
|
|
Restrict delete | ||||||
| documents_document_template_id_fkey |
|
|
Restrict delete | ||||||
| documents_owned_by_fkey |
|
|
|||||||
| documents_modified_by_fkey |
|
|
|||||||
| documents_created_by_fkey |
|
|
|||||||
| documents_status_id_fkey |
|
|
Restrict delete | ||||||
| variable_workflow_history_created_by_fkey |
|
|
Restrict delete | ||||||
| variable_workflow_history_variable_workflow_status_id_fkey |
|
|
Restrict delete | ||||||
| variable_workflow_history_max_variable_value_id_fkey |
|
|
Restrict delete | ||||||
| variable_workflow_history_project_id_fkey |
|
|
Cascade on delete | ||||||
| variable_workflow_history_variable_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_recommendations_recommended_variable_id_fkey |
|
|
Cascade on delete | ||||||
| variable_section_recommendations_section_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_recommendations_variable_manifest_id_fkey |
|
|
Cascade on delete | ||||||
| variable_section_recommendations_section_variable_id_fkey |
|
|
Cascade on delete | ||||||
| variable_image_values_file_id_fkey |
|
|
Restrict delete | ||||||
| variable_image_values_variable_value_id_fkey |
|
|
Cascade on delete | ||||||
| variable_image_values_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_image_values_variable_value_id_variable_id_variab_fkey |
|
|
Restrict delete | ||||||
| variable_image_values_variable_id_fkey |
|
|
Restrict delete | ||||||
| variable_values_project_id_fkey |
|
|
Cascade on delete | ||||||
| variable_values_variable_id_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_values_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_values_created_by_fkey |
|
|
|||||||
| variable_values_variable_id_fkey |
|
|
Restrict delete | ||||||
| variable_owners_project_id_fkey |
|
|
Cascade on delete | ||||||
| variable_owners_variable_id_fkey |
|
|
Restrict delete | ||||||
| variable_owners_owned_by_fkey |
|
|
Cascade on delete | ||||||
| document_saved_versions_created_by_fkey |
|
|
|||||||
| document_saved_versions_document_id_fkey |
|
|
Cascade on delete | ||||||
| document_saved_versions_variable_manifest_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_values_used_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_values_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_values_used_variable_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_values_usage_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_values_used_variable_id_used_variable_typ_fkey |
|
|
Restrict delete | ||||||
| variable_section_values_variable_value_id_variable_id_vari_fkey |
|
|
Restrict delete | ||||||
| variable_section_values_display_style_id_fkey |
|
|
Restrict delete | ||||||
| variable_section_values_variable_value_id_fkey |
|
|
Cascade on delete | ||||||
| variable_section_values_variable_id_fkey |
|
|
Restrict delete | ||||||
| variable_manifests_document_template_id_fkey |
|
|
Restrict delete | ||||||
| variable_manifests_created_by_fkey |
|
|
|||||||
| variable_select_option_values_option_id_fkey |
|
|
Restrict delete | ||||||
| variable_select_option_values_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_select_option_values_option_id_variable_id_fkey |
|
|
Restrict delete | ||||||
| variable_select_option_values_variable_value_id_fkey |
|
|
Cascade on delete | ||||||
| variable_select_option_values_variable_value_id_variable_i_fkey |
|
|
Restrict delete | ||||||
| variable_select_option_values_variable_id_fkey |
|
|
Restrict delete | ||||||
| variable_manifest_entries_variable_manifest_id_fkey |
|
|
Restrict delete | ||||||
| variable_manifest_entries_variable_id_fkey |
|
|
Restrict delete | ||||||
| variable_table_columns_table_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_table_columns_table_variable_id_table_variable_ty_fkey |
|
|
Cascade on delete | ||||||
| variable_table_columns_table_variable_id_fkey |
|
|
Restrict delete | ||||||
| variable_table_columns_variable_id_fkey |
|
|
Restrict delete | ||||||
| variable_selects_variable_id_variable_type_id_fkey |
|
|
Cascade on delete | ||||||
| variable_selects_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_select_options_variable_id_variable_type_id_fkey |
|
|
Cascade on delete | ||||||
| variable_select_options_variable_id_fkey |
|
|
Cascade on delete | ||||||
| variable_select_options_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_value_table_rows_variable_value_id_fkey |
|
|
Cascade on delete | ||||||
| variable_value_table_rows_table_row_value_id_fkey |
|
|
Cascade on delete | ||||||
| variable_tables_table_style_id_fkey |
|
|
Restrict delete | ||||||
| variable_tables_variable_id_variable_type_id_fkey |
|
|
Cascade on delete | ||||||
| variable_tables_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_numbers_variable_id_fkey |
|
|
Cascade on delete | ||||||
| variable_numbers_variable_id_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_numbers_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_texts_variable_id_variable_type_id_fkey |
|
|
Cascade on delete | ||||||
| variable_texts_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_texts_variable_text_type_id_fkey |
|
|
Restrict delete | ||||||
| variables_dependency_condition_id_fkey |
|
|
Restrict delete | ||||||
| variables_replaces_variable_id_fkey |
|
|
Null on delete | ||||||
| variables_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_sections_variable_id_variable_type_id_fkey |
|
|
Cascade on delete | ||||||
| variable_sections_variable_type_id_fkey |
|
|
Restrict delete | ||||||
| variable_sections_parent_variable_id_parent_variable_type__fkey |
|
|
Cascade on delete | ||||||
| variable_sections_parent_variable_type_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| variable_section_default_values | cannot_have_both_text_and_reference | (((text_value IS NULL) OR (used_variable_id IS NULL))) |
| variable_section_default_values | cannot_reference_other_sections | (((used_variable_type_id IS NULL) OR (used_variable_type_id <> 8))) |
| variable_section_default_values | must_have_text_or_reference | (((text_value IS NOT NULL) OR (used_variable_id IS NOT NULL))) |
| variable_section_default_values | variable_section_default_values_variable_type_id_check | ((variable_type_id = 8)) |
| variable_link_values | variable_link_values_variable_type_id_check | ((variable_type_id = 7)) |
| variable_section_recommendations | variable_section_recommendations_section_variable_type_id_check | ((section_variable_type_id = 8)) |
| variable_image_values | variable_image_values_variable_type_id_check | ((variable_type_id = 4)) |
| variable_values | variable_values_check | (((number_value IS NULL) OR (variable_type_id = 1))) |
| variable_values | variable_values_check1 | (((text_value IS NULL) OR (variable_type_id = 2))) |
| variable_section_values | cannot_have_both_text_and_reference | (((text_value IS NULL) OR (used_variable_id IS NULL))) |
| variable_section_values | cannot_inject_sections | ((NOT ((usage_type_id = 1) AND (used_variable_type_id = 8)))) |
| variable_section_values | cannot_reference_other_sections | (((used_variable_type_id IS NULL) OR (used_variable_type_id <> 8))) |
| variable_section_values | injection_has_display_style | (((usage_type_id = 1) = (display_style_id IS NOT NULL))) |
| variable_section_values | must_have_text_or_reference | (((text_value IS NOT NULL) OR (used_variable_id IS NOT NULL))) |
| variable_section_values | reference_only_for_figures_and_sections | (((usage_type_id <> 2) OR (used_variable_type_id = ANY (ARRAY[4, 6, 8])))) |
| variable_section_values | usages_must_have_types | (((used_variable_id IS NULL) = (usage_type_id IS NULL))) |
| variable_select_option_values | variable_select_option_values_variable_type_id_check | ((variable_type_id = 5)) |
| variable_table_columns | variable_table_columns_table_variable_type_id_check | ((table_variable_type_id = 6)) |
| variable_selects | variable_selects_variable_type_id_check | ((variable_type_id = 5)) |
| variable_tables | variable_tables_variable_type_id_check | ((variable_type_id = 6)) |
| variable_numbers | variable_numbers_variable_type_id_check | ((variable_type_id = 1)) |
| variable_texts | variable_texts_variable_type_id_check | ((variable_type_id = 2)) |
| variable_sections | variable_sections_parent_variable_type_id_check | (((parent_variable_type_id IS NULL) OR (parent_variable_type_id = 8))) |
| variable_sections | variable_sections_variable_type_id_check | ((variable_type_id = 8)) |