73 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| user_following_group_user_id_fkey |
|
|
Cascade on delete | ||
| user_following_group_group_id_fkey |
|
|
Cascade on delete | ||
| user_following_dataset_follower_id_fkey |
|
|
Cascade on delete | ||
| user_following_dataset_object_id_fkey |
|
|
Cascade on delete | ||
| api_token_user_id_fkey |
|
|
Restrict delete | ||
| group_revision_revision_id_fkey |
|
|
Restrict delete | ||
| dcpr_error_report_csi_reviewer_fkey |
|
|
Restrict delete | ||
| dcpr_error_report_metadata_record_fkey |
|
|
Restrict delete | ||
| dcpr_error_report_owner_user_fkey |
|
|
Restrict delete | ||
| user_following_user_object_id_fkey |
|
|
Cascade on delete | ||
| user_following_user_follower_id_fkey |
|
|
Cascade on delete | ||
| harvest_job_source_id_fkey |
|
|
Restrict delete | ||
| dcpr_geospatial_request_nsif_reviewer_fkey |
|
|
Restrict delete | ||
| dcpr_geospatial_request_owner_user_fkey |
|
|
Restrict delete | ||
| dcpr_geospatial_request_csi_reviewer_fkey |
|
|
Restrict delete | ||
| package_relationship_subject_package_id_fkey |
|
|
Restrict delete | ||
| package_relationship_object_package_id_fkey |
|
|
Restrict delete | ||
| saved_searches_owner_user_fkey |
|
|
Restrict delete | ||
| resource_revision_revision_id_fkey |
|
|
Restrict delete | ||
| rating_package_id_fkey |
|
|
Restrict delete | ||
| rating_user_id_fkey |
|
|
Restrict delete | ||
| package_tag_revision_revision_id_fkey |
|
|
Restrict delete | ||
| package_tag_revision_tag_id_fkey |
|
|
Restrict delete | ||
| harvest_object_harvest_job_id_fkey |
|
|
Restrict delete | ||
| harvest_object_package_id_fkey |
|
|
Restrict delete | ||
| harvest_object_harvest_source_id_fkey |
|
|
Restrict delete | ||
| system_info_revision_continuity_id_fkey |
|
|
Restrict delete | ||
| system_info_revision_revision_id_fkey |
|
|
Restrict delete | ||
| package_relationship_revision_continuity_id_fkey |
|
|
Restrict delete | ||
| package_relationship_revision_subject_package_id_fkey |
|
|
Restrict delete | ||
| package_relationship_revision_revision_id_fkey |
|
|
Restrict delete | ||
| package_relationship_revision_object_package_id_fkey |
|
|
Restrict delete | ||
| error_report_notification_group_id_fkey |
|
|
Restrict delete | ||
| error_report_notification_user_id_fkey |
|
|
Restrict delete | ||
| error_report_notification_error_report_id_fkey |
|
|
Restrict delete | ||
| harvest_gather_error_harvest_job_id_fkey |
|
|
Restrict delete | ||
| member_revision_revision_id_fkey |
|
|
Restrict delete | ||
| package_extra_package_id_fkey |
|
|
Restrict delete | ||
| harvest_object_extra_harvest_object_id_fkey |
|
|
Restrict delete | ||
| group_extra_group_id_fkey |
|
|
Restrict delete | ||
| package_extra_revision_revision_id_fkey |
|
|
Restrict delete | ||
| group_extra_revision_group_id_fkey |
|
|
Restrict delete | ||
| group_extra_revision_revision_id_fkey |
|
|
Restrict delete | ||
| member_group_id_fkey |
|
|
Restrict delete | ||
| resource_view_resource_id_fkey |
|
|
Cascade on delete | ||
| activity_detail_activity_id_fkey |
|
|
Restrict delete | ||
| dashboard_user_id_fkey |
|
|
Cascade on delete | ||
| package_revision_revision_id_fkey |
|
|
Restrict delete | ||
| error_report_metadata_record_fkey |
|
|
Restrict delete | ||
| error_report_nsif_reviewer_fkey |
|
|
Restrict delete | ||
| error_report_owner_user_fkey |
|
|
Restrict delete | ||
| dcpr_request_notification_dcpr_request_id_fkey |
|
|
Restrict delete | ||
| dcpr_request_notification_group_id_fkey |
|
|
Restrict delete | ||
| dcpr_request_notification_user_id_fkey |
|
|
Restrict delete | ||
| dcpr_request_organization_id_fkey |
|
|
Restrict delete | ||
| dcpr_request_owner_user_fkey |
|
|
Restrict delete | ||
| dcpr_request_csi_moderator_fkey |
|
|
Restrict delete | ||
| dcpr_request_nsif_reviewer_fkey |
|
|
Restrict delete | ||
| user_extra_fields_user_id_fkey |
|
|
Restrict delete | ||
| dcpr_geospatial_request_notific_dcpr_geospatial_request_id_fkey |
|
|
Restrict delete | ||
| dcpr_geospatial_request_notification_group_id_fkey |
|
|
Restrict delete | ||
| dcpr_geospatial_request_notification_user_id_fkey |
|
|
Restrict delete | ||
| harvest_object_error_harvest_object_id_fkey |
|
|
Restrict delete | ||
| dcpr_request_dataset_dcpr_request_id_fkey |
|
|
Restrict delete | ||
| dcpr_error_report_notification_user_id_fkey |
|
|
Restrict delete | ||
| dcpr_error_report_notification_dcpr_error_report_id_fkey |
|
|
Restrict delete | ||
| dcpr_error_report_notification_group_id_fkey |
|
|
Restrict delete | ||
| package_tag_tag_id_fkey |
|
|
Restrict delete | ||
| package_tag_package_id_fkey |
|
|
Restrict delete | ||
| package_member_package_id_fkey |
|
|
Restrict delete | ||
| package_member_user_id_fkey |
|
|
Restrict delete | ||
| reporting_tool_owner_user_fkey |
|
|
Restrict delete | ||
| tag_vocabulary_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| spatial_ref_sys | spatial_ref_sys_srid_check | (((srid > 0) AND (srid <= 998999))) |