220 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fk_taxa_tree_genera_family_id |
|
|
Cascade on delete | ||
| fk_taxa_reference_specimens_contact_id |
|
|
Restrict delete | ||
| fk_taxa_reference_specimens_taxon_id |
|
|
Restrict delete | ||
| fk_measured_value_dimensions_dimension_id |
|
|
Restrict delete | ||
| fk_measured_weights_value_id |
|
|
Restrict delete | ||
| fk_ceramics_analysis_entity_id |
|
|
Restrict delete | ||
| fk_ceramics_ceramics_lookup_id |
|
|
Restrict delete | ||
| fk_text_biology_taxon_id |
|
|
Cascade on delete | ||
| fk_text_biology_biblio_id |
|
|
Restrict delete | ||
| fk_sample_locations_sample_location_type_id |
|
|
Restrict delete | ||
| fk_sample_locations_physical_sample_id |
|
|
Restrict delete | ||
| fk_rdb_codes_rdb_system_id |
|
|
Restrict delete | ||
| fk_taxonomic_order_taxonomic_order_system_id |
|
|
Restrict delete | ||
| fk_taxonomic_order_taxon_id |
|
|
Cascade on delete | ||
| fk_taxonomy_notes_taxon_id |
|
|
Cascade on delete | ||
| fk_taxonomy_notes_biblio_id |
|
|
Restrict delete | ||
| fk_abundance_modifications_modification_type_id |
|
|
Restrict delete | ||
| fk_abundance_modifications_abundance_id |
|
|
Restrict delete | ||
| fk_sample_descriptions_sample_description_type_id |
|
|
Restrict delete | ||
| fk_sample_descriptions_physical_sample_id |
|
|
Restrict delete | ||
| fk_sample_group_references_biblio_id |
|
|
Restrict delete | ||
| fk_sample_group_references_sample_group_id |
|
|
Restrict delete | ||
| fk_taxa_images_taxa_tree_master_id |
|
|
Restrict delete | ||
| fk_taxa_images_image_type_id |
|
|
Restrict delete | ||
| fk_site_preservation_status_site_id |
|
|
Restrict delete | ||
| fk_sample_location_sampling_contexts_sampling_context_id |
|
|
Restrict delete | ||
| fk_sample_location_type_sampling_context_id |
|
|
Restrict delete | ||
| tbl_analysis_boolean_values_analysis_value_id_fkey |
|
|
Restrict delete | ||
| fk_ceramics_lookup_method_id |
|
|
Restrict delete | ||
| fk_tbl_relative_dates_to_tbl_analysis_entities |
|
|
Restrict delete | ||
| fk_relative_dates_relative_age_id |
|
|
Restrict delete | ||
| fk_relative_dates_method_id |
|
|
Restrict delete | ||
| fk_relative_dates_dating_uncertainty_id |
|
|
Restrict delete | ||
| fk_taxa_synonyms_family_id |
|
|
Restrict delete | ||
| fk_taxa_synonyms_genus_id |
|
|
Restrict delete | ||
| fk_taxa_synonyms_taxa_tree_author_id |
|
|
Restrict delete | ||
| fk_taxa_synonyms_taxon_id |
|
|
Cascade on delete | ||
| fk_taxa_synonyms_biblio_id |
|
|
Restrict delete | ||
| fk_tbl_sample_group_notes_sample_groups |
|
|
Restrict delete | ||
| fk_geochron_refs_biblio_id |
|
|
Restrict delete | ||
| fk_geochron_refs_geochron_id |
|
|
Restrict delete | ||
| fk_sample_group_descriptions_sample_group_description_type_id |
|
|
Restrict delete | ||
| fk_sample_groups_sample_group_descriptions_id |
|
|
Restrict delete | ||
| fk_dataset_masters_biblio_id |
|
|
Restrict delete | ||
| fk_dataset_masters_contact_id |
|
|
Restrict delete | ||
| tbl_analysis_categorical_values_analysis_value_id_fkey |
|
|
Restrict delete | ||
| tbl_analysis_categorical_values_value_type_item_id_fkey |
|
|
Restrict delete | ||
| fk_geochronology_analysis_entity_id |
|
|
Restrict delete | ||
| fk_geochronology_dating_uncertainty_id |
|
|
Restrict delete | ||
| fk_geochronology_dating_labs_id |
|
|
Restrict delete | ||
| fk_sample_group_positions_coordinate_method_dimension_id |
|
|
Restrict delete | ||
| fk_sample_group_positions_sample_group_id |
|
|
Restrict delete | ||
| tbl_analysis_numerical_values_analysis_value_id_fkey |
|
|
Restrict delete | ||
| tbl_analysis_numerical_values_qualifier_fkey |
|
|
Restrict delete | ||
| fk_physical_samples_sample_type_id |
|
|
Restrict delete | ||
| fk_physical_samples_sample_name_type_id |
|
|
Restrict delete | ||
| fk_samples_sample_group_id |
|
|
Restrict delete | ||
| fk_relative_ages_location_id |
|
|
Restrict delete | ||
| fk_relative_ages_relative_age_type_id |
|
|
Restrict delete | ||
| fk_taxonomic_order_biblio_biblio_id |
|
|
Restrict delete | ||
| fk_taxonomic_order_biblio_taxonomic_order_system_id |
|
|
Restrict delete | ||
| fk_abundances_analysis_entity_id |
|
|
Restrict delete | ||
| fk_abundances_abundance_elements_id |
|
|
Restrict delete | ||
| fk_abundances_taxon_id |
|
|
Cascade on delete | ||
| tbl_analysis_taxon_counts_taxon_id_fkey |
|
|
Restrict delete | ||
| tbl_analysis_taxon_counts_analysis_value_id_fkey |
|
|
Restrict delete | ||
| fk_horizons_method_id |
|
|
Restrict delete | ||
| tbl_value_types_data_type_id_fkey |
|
|
Restrict delete | ||
| tbl_value_types_unit_id_fkey |
|
|
Restrict delete | ||
| tbl_value_type_items_value_type_id_fkey |
|
|
Restrict delete | ||
| fk_measured_values_analysis_entity_id |
|
|
Restrict delete | ||
| fk_sample_alt_refs_physical_sample_id |
|
|
Restrict delete | ||
| fk_sample_alt_refs_alt_ref_type_id |
|
|
Restrict delete | ||
| fk_lithology_sample_group_id |
|
|
Restrict delete | ||
| fk_taxa_common_names_language_id |
|
|
Restrict delete | ||
| fk_taxa_common_names_taxon_id |
|
|
Restrict delete | ||
| fk_taxa_tree_families_order_id |
|
|
Cascade on delete | ||
| fk_colours_method_id |
|
|
Restrict delete | ||
| tbl_analysis_values_analysis_entity_id_fkey |
|
|
Restrict delete | ||
| tbl_analysis_values_value_class_id_fkey |
|
|
Restrict delete | ||
| fk_chronologies_contact_id |
|
|
Restrict delete | ||
| fk_site_other_records_biblio_id |
|
|
Restrict delete | ||
| fk_site_other_records_site_id |
|
|
Restrict delete | ||
| fk_site_other_records_record_type_id |
|
|
Restrict delete | ||
| fk_analysis_entity_prep_methods_method_id |
|
|
Restrict delete | ||
| fk_analysis_entity_prep_methods_analysis_entity_id |
|
|
Restrict delete | ||
| fk_taxa_tree_master_genus_id |
|
|
Cascade on delete | ||
| fk_taxa_tree_master_author_id |
|
|
Restrict delete | ||
| fk_analysis_entity_ages_analysis_entity_id |
|
|
Restrict delete | ||
| fk_analysis_entity_ages_chronology_id |
|
|
Restrict delete | ||
| fk_dating_material_abundance_elements_id |
|
|
Restrict delete | ||
| fk_dating_material_geochronology_geochron_id |
|
|
Restrict delete | ||
| fk_dating_material_taxa_tree_master_taxon_id |
|
|
Restrict delete | ||
| fk_projects_project_type_id |
|
|
Restrict delete | ||
| fk_projects_project_stage_id |
|
|
Restrict delete | ||
| fk_text_identification_keys_biblio_id |
|
|
Restrict delete | ||
| fk_text_identification_keys_taxon_id |
|
|
Cascade on delete | ||
| fk_abundance_elements_record_type_id |
|
|
Restrict delete | ||
| fk_methods_biblio_id |
|
|
Restrict delete | ||
| fk_methods_record_type_id |
|
|
Restrict delete | ||
| fk_methods_method_group_id |
|
|
Restrict delete | ||
| fk_methods_unit_id |
|
|
Restrict delete | ||
| fk_sample_dimensions_physical_sample_id |
|
|
Restrict delete | ||
| fk_sample_dimensions_measurement_method_id |
|
|
Restrict delete | ||
| fk_sample_dimensions_dimension_id |
|
|
Restrict delete | ||
| fk_locations_location_type_id |
|
|
Restrict delete | ||
| fk_tephra_refs_tephra_id |
|
|
Restrict delete | ||
| fk_tephra_refs_biblio_id |
|
|
Restrict delete | ||
| fk_abundance_ident_levels_identification_level_id |
|
|
Restrict delete | ||
| fk_abundance_ident_levels_abundance_id |
|
|
Restrict delete | ||
| tbl_analysis_identifiers_analysis_value_id_fkey |
|
|
Restrict delete | ||
| fk_site_references_site_id |
|
|
Restrict delete | ||
| fk_site_references_biblio_id |
|
|
Restrict delete | ||
| fk_taxa_measured_attributes_taxon_id |
|
|
Cascade on delete | ||
| fk_sample_coordinates_physical_sample_id |
|
|
Restrict delete | ||
| fk_sample_coordinates_coordinate_method_dimension_id |
|
|
Restrict delete | ||
| fk_sample_group_sampling_context_id |
|
|
Restrict delete | ||
| fk_sample_groups_method_id |
|
|
Restrict delete | ||
| fk_sample_groups_site_id |
|
|
Restrict delete | ||
| fk_feature_type_id_feature_type_id |
|
|
Cascade on delete | ||
| fk_dating_labs_contact_id |
|
|
Restrict delete | ||
| fk_ecocode_systems_biblio_id |
|
|
Restrict delete | ||
| fk_taxa_tree_orders_record_type_id |
|
|
Restrict delete | ||
| fk_sample_horizons_physical_sample_id |
|
|
Restrict delete | ||
| fk_sample_horizons_horizon_id |
|
|
Restrict delete | ||
| fk_sample_group_sampling_context_id0 |
|
|
Restrict delete | ||
| fk_sample_group_description_type_sampling_context_id |
|
|
Restrict delete | ||
| fk_data_types_data_type_group_id |
|
|
Restrict delete | ||
| fk_locations_site_id |
|
|
Restrict delete | ||
| fk_locations_location_id |
|
|
Restrict delete | ||
| fk_mcr_summary_data_taxon_id |
|
|
Restrict delete | ||
| fk_sample_colours_colour_id |
|
|
Restrict delete | ||
| fk_sample_colours_physical_sample_id |
|
|
Restrict delete | ||
| fk_text_distribution_taxon_id |
|
|
Cascade on delete | ||
| fk_text_distribution_biblio_id |
|
|
Restrict delete | ||
| tbl_value_qualifier_symbols_cardinal_qualifier_id_fkey |
|
|
Restrict delete | ||
| fk_site_natgridrefs_method_id |
|
|
Restrict delete | ||
| fk_site_natgridrefs_sites_id |
|
|
Restrict delete | ||
| fk_species_associations_association_type_id |
|
|
Restrict delete | ||
| fk_species_associations_associated_taxon_id |
|
|
Restrict delete | ||
| fk_species_associations_biblio_id |
|
|
Restrict delete | ||
| fk_species_associations_taxon_id |
|
|
Restrict delete | ||
| fk_site_preservation_status_site_preservation_status_id |
|
|
Restrict delete | ||
| fk_rdb_rdb_code_id |
|
|
Restrict delete | ||
| fk_tbl_rdb_tbl_location_id |
|
|
Restrict delete | ||
| fk_rdb_taxon_id |
|
|
Cascade on delete | ||
| tbl_analysis_integer_ranges_analysis_value_id_fkey |
|
|
Restrict delete | ||
| tbl_analysis_integer_ranges_low_qualifier_fkey |
|
|
Restrict delete | ||
| tbl_analysis_integer_ranges_high_qualifier_fkey |
|
|
Restrict delete | ||
| fk_mcrdata_birmbeetledat_taxon_id |
|
|
Restrict delete | ||
| tbl_analysis_dating_ranges_analysis_value_id_fkey |
|
|
Restrict delete | ||
| tbl_analysis_dating_ranges_high_qualifier_fkey |
|
|
Restrict delete | ||
| tbl_analysis_dating_ranges_low_qualifier_fkey |
|
|
Restrict delete | ||
| tbl_analysis_dating_ranges_season_id_fkey |
|
|
Restrict delete | ||
| tbl_analysis_dating_ranges_age_type_id_fkey |
|
|
Restrict delete | ||
| tbl_analysis_dating_ranges_dating_uncertainty_id_fkey |
|
|
Restrict delete | ||
| fk_sample_images_image_type_id |
|
|
Restrict delete | ||
| fk_sample_images_physical_sample_id |
|
|
Restrict delete | ||
| fk_sample_notes_physical_sample_id |
|
|
Restrict delete | ||
| fk_ceramics_measurements_method_id |
|
|
Restrict delete | ||
| fk_dataset_contacts_contact_type_id |
|
|
Restrict delete | ||
| fk_dataset_contacts_contact_id |
|
|
Restrict delete | ||
| fk_dataset_contacts_dataset_id |
|
|
Restrict delete | ||
| fk_datasets_method_id |
|
|
Restrict delete | ||
| fk_datasets_data_type_id |
|
|
Restrict delete | ||
| fk_datasets_master_set_id |
|
|
Restrict delete | ||
| fk_datasets_updated_dataset_id |
|
|
Restrict delete | ||
| fk_datasets_project_id |
|
|
Restrict delete | ||
| fk_datasets_biblio_id |
|
|
Restrict delete | ||
| fk_ecocodes_ecocodedef_id |
|
|
Restrict delete | ||
| fk_ecocodes_taxon_id |
|
|
Restrict delete | ||
| fk_rdb_systems_location_id |
|
|
Restrict delete | ||
| fk_rdb_systems_biblio_id |
|
|
Restrict delete | ||
| fk_imported_taxa_replacements_taxon_id |
|
|
Cascade on delete | ||
| fk_sample_group_dimensions_sample_group_id |
|
|
Restrict delete | ||
| fk_sample_group_dimensions_dimension_id |
|
|
Restrict delete | ||
| tbl_analysis_value_dimensions_analysis_value_id_fkey |
|
|
Restrict delete | ||
| tbl_analysis_value_dimensions_dimension_id_fkey |
|
|
Restrict delete | ||
| fk_taxa_seasonality_activity_type_id |
|
|
Restrict delete | ||
| fk_taxa_seasonality_location_id |
|
|
Restrict delete | ||
| fk_taxa_seasonality_season_id |
|
|
Restrict delete | ||
| fk_taxa_seasonality_taxon_id |
|
|
Cascade on delete | ||
| fk_dimensions_method_group_id |
|
|
Restrict delete | ||
| fk_dimensions_unit_id |
|
|
Restrict delete | ||
| fk_sample_description_sample_group_contexts_sampling_context_id |
|
|
Restrict delete | ||
| fk_sample_description_types_sample_group_context_id |
|
|
Restrict delete | ||
| fk_analysis_entities_physical_sample_id |
|
|
Restrict delete | ||
| fk_analysis_entities_dataset_id |
|
|
Restrict delete | ||
| fk_site_images_contact_id |
|
|
Restrict delete | ||
| fk_site_images_image_type_id |
|
|
Restrict delete | ||
| fk_site_images_site_id |
|
|
Restrict delete | ||
| fk_coordinate_method_dimensions_dimensions_id |
|
|
Restrict delete | ||
| fk_coordinate_method_dimensions_method_id |
|
|
Restrict delete | ||
| fk_seasons_season_type_id |
|
|
Restrict delete | ||
| fk_physical_sample_features_feature_id |
|
|
Cascade on delete | ||
| fk_physical_sample_features_physical_sample_id |
|
|
Cascade on delete | ||
| tbl_analysis_numerical_ranges_low_qualifier_fkey |
|
|
Restrict delete | ||
| tbl_analysis_numerical_ranges_analysis_value_id_fkey |
|
|
Restrict delete | ||
| tbl_analysis_numerical_ranges_high_qualifier_fkey |
|
|
Restrict delete | ||
| tbl_analysis_integer_values_analysis_value_id_fkey |
|
|
Restrict delete | ||
| tbl_analysis_integer_values_qualifier_fkey |
|
|
Restrict delete | ||
| fk_ecocode_definitions_ecocode_group_id |
|
|
Restrict delete | ||
| tbl_value_classes_value_type_id_fkey |
|
|
Restrict delete | ||
| tbl_value_classes_method_id_fkey |
|
|
Restrict delete | ||
| tbl_value_classes_parent_id_fkey |
|
|
Restrict delete | ||
| fk_tephra_dates_tephra_id |
|
|
Restrict delete | ||
| fk_tephra_dates_analysis_entity_id |
|
|
Restrict delete | ||
| fk_tephra_dates_dating_uncertainty_id |
|
|
Restrict delete | ||
| fk_relative_age_refs_relative_age_id |
|
|
Restrict delete | ||
| fk_relative_age_refs_biblio_id |
|
|
Restrict delete | ||
| fk_sample_group_images_image_type_id |
|
|
Restrict delete | ||
| fk_sample_group_images_sample_group_id |
|
|
Restrict delete | ||
| fk_dataset_submissions_contact_id |
|
|
Restrict delete | ||
| fk_dataset_submission_submission_type_id |
|
|
Restrict delete | ||
| fk_dataset_submissions_dataset_id |
|
|
Restrict delete | ||
| fk_ecocode_groups_ecocode_system_id |
|
|
Restrict delete | ||
| fk_mcr_names_taxon_id |
|
|
Restrict delete | ||
| tbl_analysis_notes_analysis_value_id_fkey |
|
|
Restrict delete | ||
| fk_analysis_entity_dimensions_analysis_entity_id |
|
|
Cascade on delete | ||
| fk_analysis_entity_dimensions_dimension_id |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|