Constraints

75 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
veg_vouchers_herbarium_determination_fk
herbarium_determination.veg_barcode
veg_vouchers.veg_barcode
Restrict delete
lut_surface_soil_cond_visit_surface_soil_conditions_fk
visit_surface_soil_conditions.surface_soil_condition_id
lut_surface_soil_cond.id
Restrict delete
site_location_visit_visit_surface_soil_conditions_fk
visit_surface_soil_conditions.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
site_location_visit_visit_surface_coarse_frags_lithology_fk
visit_surface_coarse_frags_lithology.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
lut_lithology_visit_surface_coarse_frags_lithology_fk
visit_surface_coarse_frags_lithology.lithology_code
lut_lithology.code
Restrict delete
lut_state_herbarium_sheet_fk
herbarium_sheet.state
lut_state.state
Restrict delete
lut_coarse_frag_shape_characterisation_coarse_frags_shape_fk
characterisation_coarse_frags_shape.coarse_frag_shape_id
lut_coarse_frag_shape.id
Restrict delete
soil_characterisation_characterisation_coarse_frags_shape_fk
characterisation_coarse_frags_shape.soil_characterisation_id
soil_characterisation.id
Cascade on delete
lut_coarse_frag_size_visit_surface_coarse_frags_size_fk
visit_surface_coarse_frags_size.coarse_frag_size_id
lut_coarse_frag_size.id
Restrict delete
site_location_visit_visit_surface_coarse_frags_size_fk
visit_surface_coarse_frags_size.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
lut_coarse_frag_size_bob_fk
characterisation_coarse_frags_size.coarse_frag_size_id
lut_coarse_frag_size.id
Restrict delete
soil_characterisation_bob_fk
characterisation_coarse_frags_size.soil_characterisation_id
soil_characterisation.id
Cascade on delete
lut_growthform_point_intercept_fk
point_intercept.growth_form
lut_growth_form.growth_form
Restrict delete
veg_vouchers_point_intercept_fk
point_intercept.veg_barcode
veg_vouchers.veg_barcode
Cascade on delete
lut_substrate_point_intercept_fk
point_intercept.substrate
lut_substrate.substrate
Restrict delete
site_location_visit_point_intercept_fk
point_intercept.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
lut_mottleabund_soil_characterisation_fk
soil_characterisation.mottles_abundance
lut_mottle_abund.id
Restrict delete
lut_pedality_type_soil_characterisation_fk3
soil_characterisation.next_size_type_2
lut_pedality_type.id
Restrict delete
lut_pedality_type_soil_characterisation_fk2
soil_characterisation.next_size_type_1
lut_pedality_type.id
Restrict delete
lut_pedality_type_soil_characterisation_fk1
soil_characterisation.smallest_size_type_2
lut_pedality_type.id
Restrict delete
lut_mottlesize_soil_characterisation_fk
soil_characterisation.mottles_size
lut_mottle_size.id
Restrict delete
lut_structure_size_soil_characterisation_smallest_1_fk
soil_characterisation.smallest_size_1
lut_structure_size.id
Restrict delete
lut_effervscence_soil_characterisation_fk
soil_characterisation.effervescence
lut_effervescence.id
Restrict delete
lut_pedality_type_soil_characterisation_fk
soil_characterisation.smallest_size_type_1
lut_pedality_type.id
Restrict delete
lut_observer_soil_subsite_characterisation_fk1
soil_characterisation.collected_by
lut_observer.id
Restrict delete
lut_soiltexgrade_soil_characterisation_fk
soil_characterisation.texture_grade
lut_soil_tex_grade.code
Restrict delete
lut_segabundance_soil_characterisation_fk
soil_characterisation.segregations_abundance
lut_seg_abundance.id
Restrict delete
lut_pedalitygrade_soil_characterisation_fk
soil_characterisation.pedality_grade
lut_pedality_grade.id
Restrict delete
lut_segsize_soil_characterisation_fk
soil_characterisation.segregations_size
lut_seg_size.id
Restrict delete
lut_segnature_soil_characterisation_fk
soil_characterisation.segregations_nature
lut_seg_nature.id
Restrict delete
site_location_visit_soil_characterisation_fk
soil_characterisation.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
lut_segform_soil_characterisation_fk
soil_characterisation.segregations_form
lut_seg_form.id
Restrict delete
lut_pedalityfabric_soil_characterisation_fk
soil_characterisation.pedality_fabric
lut_pedality_fabric.id
Restrict delete
lut_soiltexmod_soil_characterisation_fk
soil_characterisation.texture_modifier
lut_soil_tex_mod.id
Restrict delete
lut_soiltexqual_soil_characterisation_fk
soil_characterisation.texture_qualifier
lut_soil_tex_qual.id
Restrict delete
site_location_visit_soil_bulk_density_fk
soil_bulk_density.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
herbarium_sheet_veg_vouchers_fk
veg_vouchers.herbarium_sheet_id
herbarium_sheet.herbarium_sheet_id
Restrict delete
site_location_visit_veg_vouchers_fk
veg_vouchers.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
lut_growth_form_veg_vouchers_fk
veg_vouchers.default_growth_form
lut_growth_form.growth_form
Restrict delete
lut_coarse_frag_abund_characterisation_coarse_frags_abundanc2
characterisation_coarse_frags_abundance.coarse_frag_abund_id
lut_coarse_frag_abund.id
Restrict delete
soil_characterisation_test_fk
characterisation_coarse_frags_abundance.soil_characterisation_id
soil_characterisation.id
Cascade on delete
site_location_site_location_point_fk
site_location_point.site_location_id
site_location.site_location_id
Restrict delete
lut_mga_zone_site_location_point_fk
site_location_point.zone
lut_mga_zone.mga_zone
Restrict delete
lut_datum_lut_mgazone_fk
lut_mga_zone.datum
lut_datum.datum
Restrict delete
site_location_visit_structural_summary_fk
structural_summary.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
site_location_visit_photopoints_fk
photopoints.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
site_location_visit_genetic_vouchers_fk
genetic_vouchers.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
lut_basalpoint_basal_area_fk
basal_area.point_id
lut_basal_point.point_id
Restrict delete
site_location_visit_basal_area_fk
basal_area.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
veg_vouchers_basal_area_fk
basal_area.veg_barcode
veg_vouchers.veg_barcode
Restrict delete
site_location_visit_visit_surface_coarse_frags_shape_fk
visit_surface_coarse_frags_type.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
lut_coarse_frag_shape_visit_surface_coarse_frags_type_fk
visit_surface_coarse_frags_type.coarse_frag_type_id
lut_coarse_frag_shape.id
Restrict delete
site_location_visit_visit_surface_coarse_frags_abundance_fk
visit_surface_coarse_frags_abundance.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
lut_coarse_frag_abund_visit_surface_coarse_frags_abundance_fk
visit_surface_coarse_frags_abundance.coarse_frag_abund_id
lut_coarse_frag_abund.id
Restrict delete
site_location_visit_lai_fk
lai.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
soil_characterisation_characterisation_coarse_frags_litholog863
characterisation_coarse_frags_lithology.soil_characterisation_id
soil_characterisation.id
Cascade on delete
lut_lithology_characterisation_coarse_frags_lithology_fk
characterisation_coarse_frags_lithology.lithology_code
lut_lithology.code
Restrict delete
site_location_visit_soil_subsite_observations_fk
soil_subsite_observations.site_location_visit_id
site_location_visit.site_location_visit_id
Restrict delete
lut_observer_soil_subsite_observations_fk1
soil_subsite_observations.observer
lut_observer.id
Restrict delete
lut_lithology_site_location_fk
site_location.outcrop_lithology
lut_lithology.code
Restrict delete
lut_ibra_site_location_fk
site_location.bioregion_name
lut_ibra.bioregion_name
Restrict delete
lut_lithology_site_location_fk1
site_location.other_outcrop_lithology
lut_lithology.code
Restrict delete
lut_landform_element_site_location_fk
site_location.landform_element
lut_landform_element.code
Restrict delete
lut_landform_pattern_site_location_fk
site_location.landform_pattern
lut_landform_pattern.id
Restrict delete
site_location_site_location_visit_fk
site_location_visit.site_location_id
site_location.site_location_id
Restrict delete
lut_erosionabund_site_location_visit_fk
site_location_visit.erosion_abundance
lut_erosion_abund.id
Restrict delete
lut_disturbance_site_location_visit_fk
site_location_visit.disturbance
lut_disturbance.id
Restrict delete
lut_erosionstate_site_location_visit_fk
site_location_visit.erosion_state
lut_erosion_state.id
Restrict delete
lut_observer_site_location_visit_fk2
site_location_visit.described_by
lut_observer.id
Restrict delete
lut_observer_site_location_visit_fk1
site_location_visit.observer_soil
lut_observer.id
Restrict delete
lut_erosiontype_site_location_visit_fk
site_location_visit.erosion_type
lut_erosion_type.id
Restrict delete
lut_drainage_site_location_visit_fk
site_location_visit.drainage_type
lut_drainage.id
Restrict delete
lut_soilobstype_site_location_visit_fk
site_location_visit.soil_observation_type
lut_soil_obs_type.id
Restrict delete
lut_microrelief_site_location_visit_fk
site_location_visit.microrelief
lut_microrelief.id
Restrict delete
lut_observer_site_location_visit_fk
site_location_visit.observer_veg
lut_observer.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected