99 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| citation_curation_entity_curation_entity_num_fkey |
|
|
Restrict delete | ||
| citation_curation_entity_citation_num_fkey |
|
|
Restrict delete | ||
| fk_related_result_num_result_num |
|
|
Restrict delete | ||
| fk_related_result_relationship_type |
|
|
Restrict delete | ||
| fk_related_result_result |
|
|
Restrict delete | ||
| fk_text_data_result |
|
|
Cascade on delete | ||
| dataset_dataset_type_num_fkey |
|
|
Restrict delete | ||
| fk_sampling_feature_sampling_feature_type |
|
|
Restrict delete | ||
| fk_specimen_material |
|
|
Restrict delete | ||
| fk_specimen_sampling_feature |
|
|
Restrict delete | ||
| specimen_sampling_feature_num_fkey |
|
|
Restrict delete | ||
| specimen_material_num_fkey |
|
|
Restrict delete | ||
| fk_citation_external_identifier_external_identifier |
|
|
Restrict delete | ||
| fk_citation_external_identifier_citation |
|
|
Restrict delete | ||
| fk_person_external_identifier_person |
|
|
Restrict delete | ||
| fk_person_external_identifier_external_identifier |
|
|
Restrict delete | ||
| fk_feature_of_interest_annotation_annotation_num |
|
|
Restrict delete | ||
| fk_feature_of_interest_annotation_feature_of_interest_num |
|
|
Restrict delete | ||
| fk_feature_of_interest_sampling_feature |
|
|
Restrict delete | ||
| fk_feature_of_interest_feature_of_interest_cv |
|
|
Restrict delete | ||
| fk_feature_of_interest_feature_of_interest_type |
|
|
Restrict delete | ||
| fk_dataset_external_identifier_external_identifier |
|
|
Restrict delete | ||
| fk_dataset_external_identifier_dataset |
|
|
Restrict delete | ||
| fk_annotation_data_source_num |
|
|
Restrict delete | ||
| fk_annotation_annotation_type_num |
|
|
Restrict delete | ||
| action_external_identifier_external_identifier_system_num_fkey |
|
|
Restrict delete | ||
| action_external_identifier_action_num_fkey |
|
|
Restrict delete | ||
| orcid_citation_num_fkey |
|
|
Restrict delete | ||
| sampling_feature_type_sampling_feature_parent_type_num_fkey |
|
|
Restrict delete | ||
| sampling_feature_type_sampling_feature_parent_type_num_fkey1 |
|
|
Restrict delete | ||
| fk_taxonomic_classifier_external_identifer_external_identifier |
|
|
Restrict delete | ||
| fk_taxonomic_classifier_external_identifer_taxonomic_classifier |
|
|
Restrict delete | ||
| annotation_type_group_annotation_type_num_fkey |
|
|
Restrict delete | ||
| annotation_type_group_curation_entity_num_fkey |
|
|
Restrict delete | ||
| annotation_type_group_annotation_group_num_fkey |
|
|
Restrict delete | ||
| fk_spatial_offset3_unit |
|
|
Restrict delete | ||
| fk_spatial_offset1_unit |
|
|
Restrict delete | ||
| fk_spatial_offset2_unit |
|
|
Restrict delete | ||
| fk_spatial_offset_spatial_offset_type |
|
|
Restrict delete | ||
| fk_citation_dataset_citation |
|
|
Restrict delete | ||
| fk_citation_dataset_dataset |
|
|
Restrict delete | ||
| fk_citation_dataset_relationship_type |
|
|
Restrict delete | ||
| fk_sampling_feature_external_identifier_sampling_feature |
|
|
Restrict delete | ||
| fk_sampling_feature_external_identifier_external_identifier |
|
|
Restrict delete | ||
| sampling_feature_external_ide_external_identifier_system_n_fkey |
|
|
Restrict delete | ||
| sampling_feature_external_identifier_sample_feature_num_fkey |
|
|
Restrict delete | ||
| fk_numeric_data_result |
|
|
Restrict delete | ||
| fk_numeric_data_unit |
|
|
Restrict delete | ||
| fk_related_feature_relationship_type |
|
|
Restrict delete | ||
| fk_related_parent_sampling_feature_num |
|
|
Restrict delete | ||
| fk_feature_parent_spatial_offset |
|
|
Restrict delete | ||
| fk_current_sampling_feature_num |
|
|
Restrict delete | ||
| fk_method_method_type |
|
|
Restrict delete | ||
| fk_method_organization |
|
|
Restrict delete | ||
| fk_sampling_feature_taxonomic_classifier_taxonomic_classifier |
|
|
Restrict delete | ||
| fk_sampling_feature_taxonomic_classifier_sampling_feature |
|
|
Restrict delete | ||
| fk_author_list_citation |
|
|
Restrict delete | ||
| fk_author_list_person |
|
|
Restrict delete | ||
| fk_sampling_feature_annotation_annotation_num |
|
|
Restrict delete | ||
| fk_sampling_feature_annotation_sampling_feature_num |
|
|
Restrict delete | ||
| fk_state_country |
|
|
Restrict delete | ||
| ec_status_info_citation_num_fkey |
|
|
Restrict delete | ||
| fk_ec_status_control_citation |
|
|
Restrict delete | ||
| fk_reference_material_value_citation |
|
|
Restrict delete | ||
| fk_reference_material_value_variable |
|
|
Restrict delete | ||
| fk_reference_material_value_unit |
|
|
Restrict delete | ||
| fk_organization_country |
|
|
Restrict delete | ||
| fk_organization_state |
|
|
Restrict delete | ||
| fk_organization_organization_type |
|
|
Restrict delete | ||
| fk_organization_organization |
|
|
Restrict delete | ||
| fk_equipment_equipment_type |
|
|
Restrict delete | ||
| fk_variable_variable_type_num |
|
|
Restrict delete | ||
| fk_result_annotation_annotation_num |
|
|
Restrict delete | ||
| fk_result_annotation_result_num |
|
|
Restrict delete | ||
| fk_related_action_action |
|
|
Restrict delete | ||
| fk_parent_action_action |
|
|
Restrict delete | ||
| fk_related_action_relationship_type |
|
|
Restrict delete | ||
| fk_equipment_action_action |
|
|
Restrict delete | ||
| fk_equipment_action_equipment |
|
|
Restrict delete | ||
| bibcode_citation_num_fkey |
|
|
Restrict delete | ||
| fk_affiliation_organization |
|
|
Restrict delete | ||
| fk_affiliation_person |
|
|
Restrict delete | ||
| fk_action_by_affiliation |
|
|
Restrict delete | ||
| fk_action_person_role_organization_action |
|
|
Restrict delete | ||
| fk_action_annotation_action_num |
|
|
Restrict delete | ||
| fk_action_annotation_annotation_num |
|
|
Restrict delete | ||
| fk_feature_action_result_action |
|
|
Restrict delete | ||
| fk_feature_action_result_sampling_feature |
|
|
Restrict delete | ||
| fk_action_organization |
|
|
Restrict delete | ||
| fk_action_dataset |
|
|
Restrict delete | ||
| fk_action_method |
|
|
Restrict delete | ||
| fk_action_action_type |
|
|
Restrict delete | ||
| fk_taxonomic_classifier_taxonomic_classifier |
|
|
Restrict delete | ||
| fk_result_result_type |
|
|
Restrict delete | ||
| fk_result_feature_action |
|
|
Restrict delete | ||
| fk_result_reference_material_value |
|
|
Restrict delete | ||
| fk_result_taxonomic_classifier |
|
|
Restrict delete | ||
| fk_result_variable |
|
|
Restrict delete | ||
| fk_result_processing_level |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|