Constraints

28 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
report_version_view_report_version_fkey
report_version_view.report_version
report_version.id
Restrict delete
depends_report_version_fkey
depends.report_version
report_version.id
Restrict delete
depends_use_fkey
depends.use
file_artefact.id
Restrict delete
report_version_package_report_version_fkey
report_version_package.report_version
report_version.id
Restrict delete
report_version_batch_report_version_fkey
report_version_batch.report_version
report_version.id
Restrict delete
report_version_batch_report_batch_fkey
report_version_batch.report_batch
report_batch.id
Restrict delete
report_version_report_fkey
report_version.report
report.name
Restrict delete
report_version_tag_report_version_fkey
report_version_tag.report_version
report_version.id
Restrict delete
report_version_tag_tag_fkey
report_version_tag.tag
tag.id
Restrict delete
report_version_data_report_version_fkey
report_version_data.report_version
report_version.id
Restrict delete
report_version_data_hash_fkey
report_version_data.hash
data.hash
Restrict delete
report_version_custom_fields_key_fkey
report_version_custom_fields.key
custom_fields.id
Restrict delete
report_version_custom_fields_report_version_fkey
report_version_custom_fields.report_version
report_version.id
Restrict delete
file_input_global_file_input_fkey
file_input_global.file_input
file_input.id
Restrict delete
changelog_report_version_fkey
changelog.report_version
report_version.id
Restrict delete
changelog_label_fkey
changelog.label
changelog_label.id
Restrict delete
changelog_report_version_public_fkey
changelog.report_version_public
report_version.id
Restrict delete
report_version_artefact_report_version_fkey
report_version_artefact.report_version
report_version.id
Restrict delete
report_version_artefact_format_fkey
report_version_artefact.format
artefact_format.name
Restrict delete
file_input_file_hash_fkey
file_input.file_hash
file.hash
Restrict delete
file_input_file_purpose_fkey
file_input.file_purpose
file_purpose.name
Restrict delete
file_input_report_version_fkey
file_input.report_version
report_version.id
Restrict delete
report_version_instance_report_version_fkey
report_version_instance.report_version
report_version.id
Restrict delete
report_latest_fkey
report.latest
report_version.id
Restrict delete
parameters_report_version_fkey
parameters.report_version
report_version.id
Restrict delete
parameters_type_fkey
parameters.type
parameters_type.name
Restrict delete
file_artefact_artefact_fkey
file_artefact.artefact
report_version_artefact.id
Restrict delete
file_artefact_file_hash_fkey
file_artefact.file_hash
file.hash
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected