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_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_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_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_manifests_document_template_id_fkey |
|
|
Restrict delete | ||||||
| variable_manifests_created_by_fkey |
|
|
|||||||
| 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_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_image_values | variable_image_values_variable_type_id_check | (variable_type_id = 4) |
| variable_section_recommendations | variable_section_recommendations_section_variable_type_id_check | (section_variable_type_id = 8) |
| variable_values | text_value_is_text_or_email | ((text_value IS NULL) OR (variable_type_id = ANY (ARRAY[2, 9]))) |
| variable_values | variable_values_check | ((number_value IS NULL) OR (variable_type_id = 1)) |
| 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) |