Constraints

66 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
tdis_model_model_type_model_fk
tdis_model_model_type.model_id
tdis_model.element_id
Cascade on delete
tdis_model_model_type_type_fk
tdis_model_model_type.model_type_id
tdis_model_type.id
Cascade on delete
tdis_model_isa_member_element_fk
tdis_model.element_id
tdis_member.element_id
Cascade on delete
tdis_model_dimension_fk
tdis_model.dimension_id
tdis_dimension.id
Restrict delete
tdis_session_user_fk
tdis_session.user_id
tdis_user.contact_id
Cascade on delete
tdis_element_contact_element_fk
tdis_element_contact.element_id
tdis_element.id
Cascade on delete
tdis_element_contact_contact_fk
tdis_element_contact.contact_id
tdis_contact.id
Cascade on delete
tdis_element_contact_role_fk
tdis_element_contact.role_id
tdis_contact_role.id
Restrict delete
tdis_layer_horizontal_projection_fk
tdis_member.horizontal_projection_id
tdis_horizontal_projection.id
Restrict delete
tdis_member_status_fk
tdis_member.status_id
tdis_status.id
Restrict delete
tdis_member_software_fk
tdis_member.software_id
tdis_software.id
Restrict delete
tdis_member_distribution_method_fk
tdis_member.distribution_method_id
tdis_distribution_method.id
Restrict delete
tdis_member_data_stage_fk
tdis_member.data_stage_id
tdis_data_stage.id
Restrict delete
tdis_layer_vertical_datum_fk
tdis_member.vertical_datum_id
tdis_vertical_datum.id
Restrict delete
tdis_member_jurisdiction_type_fk
tdis_member.jurisdiction_type_id
tdis_jurisdiction_type.id
Restrict delete
tdis_member_spatial_accuracy_fk
tdis_member.spatial_accuracy_id
tdis_spatial_accuracy.id
Restrict delete
tdis_layer_horizontal_datum_fk
tdis_member.horizontal_datum_id
tdis_horizontal_datum.id
Restrict delete
tdis_layer_vertical_projection_fk
tdis_member.vertical_projection_id
tdis_vertical_projection.id
Restrict delete
tdis_member_update_interval_fk
tdis_member.update_interval_id
tdis_update_interval.id
Restrict delete
tdis_member_collection_fk
tdis_member.collection_id
tdis_collection.element_id
Restrict delete
tdis_member_isan_element_fk
tdis_member.element_id
tdis_element.id
Cascade on delete
tdis_member_publisher_distributor_agency_fk
tdis_member.publisher_distributor_agency_id
tdis_agency.id
Restrict delete
tdis_member_endpoint_type_fk
tdis_member.end_point_type_id
tdis_endpoint_type.id
Restrict delete
tdis_member_accessibility_fk
tdis_member.accessibility_id
tdis_accessibility.id
Restrict delete
tdis_member_completeness_fk
tdis_member.completeness_id
tdis_completeness.id
Restrict delete
tdis_member_jurisdiction_member_fk
tdis_member_jurisdiction.member_id
tdis_member.element_id
Cascade on delete
tdis_member_jurisdiction_jurisdiction_fk
tdis_member_jurisdiction.jurisdiction_id
tdis_jurisdiction.id
Cascade on delete
tdis_attribute_layer_fkey
tdis_attribute.layer_id
tdis_layer.element_id
Cascade on delete
tdis_attribute_domain_type_fkey
tdis_attribute.domain_type_id
tdis_domain_type.id
Restrict delete
tdis_element_history_user_fk
tdis_element_history.user_id
tdis_user.contact_id
Restrict delete
tdis_element_history_element_fk
tdis_element_history.element_id
tdis_element.id
Cascade on delete
tdis_user_isa_contact_fk
tdis_user.contact_id
tdis_contact.id
Restrict delete
tdis_collection_project_fk
tdis_collection.project_id
tdis_project.id
Restrict delete
tdis_collection_isan_element_fk
tdis_collection.element_id
tdis_element.id
Cascade on delete
tdis_collection_region_fk
tdis_collection.jurisdiction_id
tdis_jurisdiction.id
Restrict delete
tdis_layer_isa_artifact_member_element_fk
tdis_layer.element_id
tdis_artifact.element_id
Cascade on delete
tdis_layer_spatial_data_type_fk
tdis_layer.spatial_data_type_id
tdis_spatial_data_type.id
Restrict delete
tdis_artifact_class_type_fkey
tdis_artifact.class_type_id
tdis_class_type.id
Restrict delete
tdis_artifact_process_source_fk
tdis_artifact.process_source_id
tdis_agency.id
Restrict delete
tdis_artifact_file_format_fk
tdis_artifact.file_format_id
tdis_file_format.id
Restrict delete
tdis_artifact_isa_member_element_fk
tdis_artifact.element_id
tdis_member.element_id
Cascade on delete
tdis_artifact_class_term_fkey
tdis_artifact.class_term_id
tdis_class_term.id
Restrict delete
tdis_project_jurisdiction_project_fk
tdis_project_jurisdiction.project_id
tdis_project.id
Cascade on delete
tdis_project_jurisdiction_jurisdiction_fk
tdis_project_jurisdiction.jurisdiction_id
tdis_jurisdiction.id
Cascade on delete
tdis_element_controlled_vocabulary_fk
tdis_element.controlled_vocabulary_id
tdis_controlled_vocabulary.id
Restrict delete
tdis_element_user_fk
tdis_element.user_id
tdis_user.contact_id
Restrict delete
tdis_element_scale_fk
tdis_element.scale_id
tdis_scale.id
Restrict delete
tdis_notification_member_fk
tdis_notification.member_id
tdis_member.element_id
Cascade on delete
tdis_notification_user_fk
tdis_notification.user_id
tdis_user.contact_id
Restrict delete
tdis_notification_status_fk
tdis_notification.status_id
tdis_status.id
Restrict delete
tdis_notification_type_fk
tdis_notification.type_id
tdis_notification_type.id
Restrict delete
tdis_upload_element_fk
tdis_upload.element_id
tdis_element.id
Cascade on delete
tdis_upload_parent_fk
tdis_upload.parent_id
tdis_upload.id
Cascade on delete
tdis_upload_upload_type_fk
tdis_upload.type_id
tdis_upload_type.id
Restrict delete
tdis_user_project_role_user_fk
tdis_user_project_role.user_id
tdis_user.contact_id
Cascade on delete
tdis_user_project_role_role_fk
tdis_user_project_role.role_id
tdis_user_role.id
Cascade on delete
tdis_user_project_role_project_fk
tdis_user_project_role.project_id
tdis_project.id
Cascade on delete
tdis_user_keyword_user_fk
tdis_user_keyword.user_id
tdis_user.contact_id
Cascade on delete
tdis_contact_agency_fk
tdis_contact.agency_id
tdis_agency.id
Restrict delete
tdis_user_report_user_fk
tdis_user_report.user_id
tdis_user.contact_id
Cascade on delete
tdis_user_search_user_fk
tdis_user_search.user_id
tdis_user.contact_id
Cascade on delete
tdis_member_constraint_constraint_fk
tdis_member_constraint.constraint_id
tdis_constraint.id
Cascade on delete
tdis_member_constraint_member_fk
tdis_member_constraint.member_id
tdis_member.element_id
Cascade on delete
tdis_jurisdiction_type_fk
tdis_jurisdiction.jurisdiction_type_id
tdis_jurisdiction_type.id
Restrict delete
tdis_jurisdiction_type_distributor_jurisdiction_type_fk
tdis_jurisdiction_type_distributor.jurisdiction_type_id
tdis_jurisdiction_type.id
Cascade on delete
tdis_jurisdiction_type_distributor_agency_fk
tdis_jurisdiction_type_distributor.distributor_id
tdis_agency.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint