Constraints

32 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
funding_source_external_identifie_external_identifier_system_i_
funding_source_external_identifier.external_identifier_system_id
external_identifier_system.external_identifier_system_id
Restrict delete
funding_source_external_identifier_funding_source_id_fkey
funding_source_external_identifier.funding_source_id
funding_source.funding_source_id
Restrict delete
author_list_person_num_fkey
author_list.person_num
person.person_num
Restrict delete
author_list_submission_id_fkey
author_list.submission_id
submissions.submission_id
Restrict delete
archive_file_checksum_submission_id_fkey
archive_file_checksum.submission_id
submissions.submission_id
Restrict delete
grl_user_country_id_fkey1
grl_user.country_id
country.country_id
Restrict delete
grl_user_country_id_fkey
grl_user.country_id
country.country_id
Restrict delete
fk_dataset_group_id
data_file_format_system_mapping.dataset_group_id
dataset_group.dataset_group_id
Restrict delete
fk_data_file_format_id
data_file_format_system_mapping.data_file_format_id
data_file_formats.data_file_format_id
Restrict delete
dataset_relation_submission_id_fkey
dataset_relation.submission_id
submissions.submission_id
Restrict delete
dataset_file_list_data_file_format_id_fkey
dataset_file_list.data_file_format_id
data_file_formats.data_file_format_id
Restrict delete
dataset_file_list_submission_id_fkey
dataset_file_list.submission_id
submissions.submission_id
Restrict delete
submission_external_identifie_external_identifier_system_i_fkey
submission_external_identifier.external_identifier_system_id
external_identifier_system.external_identifier_system_id
Restrict delete
submission_external_identifier_submission_id_fkey
submission_external_identifier.submission_id
submissions.submission_id
Restrict delete
submissions_created_by_fkey
submissions.created_by
grl_user.account_id
Restrict delete
submissions_owner_fkey
submissions.owner
grl_user.account_id
Restrict delete
submissions_dataset_type_id_fkey
submissions.dataset_type_id
dataset_types.dataset_type_id
Restrict delete
submissions_license_id_fkey
submissions.license_id
license.license_id
Restrict delete
submissions_language_id_fkey
submissions.language_id
languages.language_id
Restrict delete
submissions_system_id_fkey
submissions.system_id
dataset_group.dataset_group_id
Restrict delete
submissions_status_id_fkey
submissions.status_id
status.status_id
Restrict delete
submissions_submission_coverage_scope_id_fkey
submissions.submission_coverage_scope_id
submission_coverage_scopes.submission_coverage_scope_id
Restrict delete
submission_relation_related_submission_id_fkey
submission_relation.related_submission_id
submissions.submission_id
Restrict delete
submission_relation_submission_id_fkey
submission_relation.submission_id
submissions.submission_id
Restrict delete
fundings_submissions_fkey
fundings.submission_id
submissions.submission_id
Restrict delete
fundings_funding_source_id_fkey
fundings.funding_source_id
funding_source.funding_source_id
Restrict delete
download_stats_submission_id_fkey
download_stats.submission_id
submissions.submission_id
Restrict delete
fk_dataset_file_geometry_dataset_file_list
dataset_file_geometry.dataset_file_list_id
dataset_file_list.dataset_file_list_id
Restrict delete
data_type_list_data_type_id_fkey
data_type_list.data_type_id
data_type.data_type_id
Restrict delete
data_type_list_submission_id_fkey
data_type_list.submission_id
submissions.submission_id
Restrict delete
submission_geometry_submission_id_fkey
submission_geometry.submission_id
submissions.submission_id
Restrict delete
submission_geometry_srid_fkey
submission_geometry.srid
spatial_ref_sys.srid
Restrict delete

Check Constraints

Table Constraint Name Constraint