103 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| tbl_monfungal_mon_id_fkey |
|
|
Cascade on delete | ||
| tbl_monfungal_species_fkey |
|
|
Restrict delete | ||
| tbl_strat_relationship_context_fkey |
|
|
Cascade on delete | ||
| tbl_strat_relationship_related_context_fkey |
|
|
Cascade on delete | ||
| tbl_strat_relationship_relationship_type_fkey |
|
|
Restrict delete | ||
| finds_fkey |
|
|
Restrict delete | ||
| tbl_monolith_sample_number_fkey |
|
|
Cascade on delete | ||
| tbl_monolith_context_fkey |
|
|
Restrict delete | ||
| tbl_monolith_pollen_recovery_fkey |
|
|
Restrict delete | ||
| insects_fkey |
|
|
Restrict delete | ||
| tbl_users_audit_audit_author_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_platform_preparation_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_platform_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_platform_features_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_stages_pid_fkey |
|
|
Cascade on delete | ||
| tbl_lithic_analysis_core_scar_orientation_fkey |
|
|
Restrict delete | ||
| tbl_monspec_species_fkey |
|
|
Restrict delete | ||
| tbl_monspec_mon_id_fkey |
|
|
Cascade on delete | ||
| tbl_lithic_analysis_core_core_shape_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_cortex_type_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_platform_features_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_flaked_pebbles_reason_discard_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_pid_fkey |
|
|
Cascade on delete | ||
| tbl_lithic_analysis_core_scar_orientation_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_extent_platform_area_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_platform_preparation_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_bipolar_working_stage_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_procent_cortext_remaining_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_platform_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_core_face_morphology_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_core_pebble_flint_original_pebble_size_fkey |
|
|
Restrict delete | ||
| tbl_contexts_phase_fkey |
|
|
Restrict delete | ||
| tbl_contexts_context_type_fkey |
|
|
Restrict delete | ||
| tbl_contexts_site_sub_div_fkey |
|
|
Restrict delete | ||
| tbl_contexts_category_fkey |
|
|
Restrict delete | ||
| tbl_contexts_period_fkey |
|
|
Restrict delete | ||
| tbl_pollen_species_fkey |
|
|
Restrict delete | ||
| tbl_sitesubdiv_ranges_site_sub_div_id_fkey |
|
|
Cascade on delete | ||
| tbl_cpr_matrix_enviro_id_fkey |
|
|
Cascade on delete | ||
| tbl_cpr_matrix_cprmatrix_fkey |
|
|
Restrict delete | ||
| tbl_evidence_log_audit_audit_author_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_sub_classification_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_shape_in_plan_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_shape_of_short_oblique_edge_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_area_description_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_position_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_use_gloss_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_microlith_retouch_position_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_invasive_retouch_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_cross_section_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_utilised_edge_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_survival_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_pid_fkey |
|
|
Cascade on delete | ||
| tbl_lithic_analysis_retouched_unmodified_type_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_retouched_type_fkey |
|
|
Restrict delete | ||
| tbl_context_entity_context_fkey |
|
|
Cascade on delete | ||
| tbl_contexts_entity_fkey |
|
|
Restrict delete | ||
| tbl_relationships_related_context_fkey |
|
|
Cascade on delete | ||
| tbl_relationships_relationship_type_fkey |
|
|
Restrict delete | ||
| tbl_relationships_context_fkey |
|
|
Cascade on delete | ||
| tbl_entities_nested_within_fkey |
|
|
Null on delete | ||
| tbl_wood_dendro_wood_number_fkey |
|
|
Cascade on delete | ||
| tbl_photos_audit_author_fkey |
|
|
Restrict delete | ||
| tbl_photos_audit_lithic_record_fkey |
|
|
Cascade on delete | ||
| tbl_lithic_classification_fkey |
|
|
Restrict delete | ||
| tbl_lithic_subType_fkey |
|
|
Restrict delete | ||
| tbl_lithic_type_fkey |
|
|
Restrict delete | ||
| tbl_lithic_rawMaterial_fkey |
|
|
Restrict delete | ||
| tbl_lithic_knapping_group_fkey |
|
|
Null on delete | ||
| tbl_lithic_analysis_table_fkey |
|
|
Null on delete | ||
| tbl_lithic_category_fkey |
|
|
Restrict delete | ||
| tbl_lithic_survival_fkey |
|
|
Restrict delete | ||
| tbl_wpr_species_b_wpr_botanical_fkey |
|
|
Restrict delete | ||
| tbl_wpr_species_b_enviro_id_fkey |
|
|
Cascade on delete | ||
| tbl_lithic_analysis_lithic_record_fkey |
|
|
Cascade on delete | ||
| tbl_lithic_analysis_colour_fkey |
|
|
Restrict delete | ||
| tbl_lithic_lithic_entity_fkey |
|
|
Restrict delete | ||
| tbl_lithic_lithic_refid_fkey |
|
|
Cascade on delete | ||
| tbl_lithic_entities_nested_within_fkey |
|
|
Null on delete | ||
| tbl_lithic_analysis_debitage_bulb_type_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_debitage_features_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_debitage_sub_classification_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_debitage_termination_type_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_debitage_fragmentation_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_debitage_core_trimming_sub_classificat_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_debitage_platform_preparation_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_debitage_condition_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_debitage_dorsal_scar_direction_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_debitage_core_trimming_dorsal_face_mor_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_debitage_reduction_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_debitage_platform_type_fkey |
|
|
Restrict delete | ||
| tbl_lithic_analysis_debitage_pid_fkey |
|
|
Cascade on delete | ||
| tbl_lithic_analysis_debitage_crested_blades_guide_pieces_fkey |
|
|
Restrict delete | ||
| tbl_charcoal_species_fkey |
|
|
Restrict delete | ||
| tbl_cpr_species_fkey |
|
|
Restrict delete | ||
| tbl_photos_lithic_record_fkey |
|
|
Cascade on delete | ||
| tbl_charcoal_b_taxa_fkey |
|
|
Restrict delete | ||
| tbl_charcoal_b_enviro_id_fkey |
|
|
Cascade on delete | ||
| tbl_cpr_b_cpr_sub_type_fkey |
|
|
Cascade on delete | ||
| tbl_cpr_b_enviro_id_fkey |
|
|
Cascade on delete | ||
| tbl_insects_species_fkey |
|
|
Restrict delete | ||
| tbl_wpr_matrix_b_enviro_id_fkey |
|
|
Cascade on delete | ||
| tbl_wpr_matrix_b_wpr_matrix_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|