Relationships

• [datastream].sensor –> [sensor].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [datastream].guid_thing –> [thing].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [datastream].code_unitofmeasure –> [unitofmeasure].code (ON UPDATE CASCADE, ON DELETE CASCADE)
• [derivedprofilepresenceinsoilbody].guid_soilprofile –> [soilprofile].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [derivedprofilepresenceinsoilbody].guid_soilbody –> [soilbody].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [faohorizonnotationtype].guid_profileelement –> [profileelement].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [isbasedonobservedsoilprofile].guid_soilprofile –> [soilprofile].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [isbasedonobservedsoilprofile].guid_soilderivedobject –> [soilderivedobject].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [isbasedonsoilbody].guid_soilbody –> [soilbody].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [isbasedonsoilbody].guid_soilderivedobject –> [soilderivedobject].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [isbasedonsoilderivedobject].guid_related –> [soilderivedobject].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [isbasedonsoilderivedobject].guid_base –> [soilderivedobject].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [isderivedfrom].guid_related –> [soilprofile].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [isderivedfrom].guid_base –> [soilprofile].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [observation].guid_datastream –> [datastream].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [obsprocedure_obsdproperty].guid_observedproperty –> [observedproperty].guid (ON UPDATE CASCADE, ON DELETE RESTRICT)
• [obsprocedure_obsdproperty].guid_observingprocedure –> [observingprocedure].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [obsprocedure_sensor].guid_sensor –> [sensor].guid (ON UPDATE CASCADE, ON DELETE RESTRICT)
• [obsprocedure_sensor].guid_observingprocedure –> [observingprocedure].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [otherhorizon_profileelement].guid_otherhorizonnotationtype –> [otherhorizonnotationtype].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [otherhorizon_profileelement].guid_profileelement –> [profileelement].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [othersoilnametype].othersoilname –> [soilprofile].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [profileelement].ispartof –> [soilprofile].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilbody_geom].guid_soilbody –> [soilbody].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilplot].locatedon –> [soilsite].guid (ON UPDATE CASCADE, ON DELETE NO ACTION)
• [soilprofile].location –> [soilplot].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [wrbqualifiergroup_profile].guid_wrbqualifiergrouptype –> [wrbqualifiergrouptype].guid (ON UPDATE CASCADE, ON DELETE CASCADE)
• [wrbqualifiergroup_profile].guid_soilprofile –> [soilprofile].guid (ON UPDATE CASCADE, ON DELETE CASCADE)

Reverse relationships (parent → children):

• [datastream].guid –> [observation].guid_datastream (ON UPDATE CASCADE, ON DELETE CASCADE)
• [observedproperty].guid –> [datastream].guid_observedproperty (ON UPDATE CASCADE, ON DELETE CASCADE)
• [observedproperty].guid –> [obsprocedure_obsdproperty].guid_observedproperty (ON UPDATE CASCADE, ON DELETE RESTRICT)
• [observingprocedure].guid –> [datastream].guid_observingprocedure (ON UPDATE CASCADE, ON DELETE SET NULL)
• [observingprocedure].guid –> [obsprocedure_obsdproperty].guid_observingprocedure (ON UPDATE CASCADE, ON DELETE CASCADE)
• [observingprocedure].guid –> [obsprocedure_sensor].guid_observingprocedure (ON UPDATE CASCADE, ON DELETE CASCADE)
• [otherhorizonnotationtype].guid –> [otherhorizon_profileelement].guid_otherhorizonnotationtype (ON UPDATE CASCADE, ON DELETE CASCADE)
• [profileelement].guid –> [datastream].guid_profileelement (ON UPDATE CASCADE, ON DELETE CASCADE)
• [profileelement].guid –> [faohorizonnotationtype].guid_profileelement (ON UPDATE CASCADE, ON DELETE CASCADE)
• [profileelement].guid –> [otherhorizon_profileelement].guid_profileelement (ON UPDATE CASCADE, ON DELETE CASCADE)
• [sensor].guid –> [datastream].guid_sensor (ON UPDATE CASCADE, ON DELETE CASCADE)
• [sensor].guid –> [obsprocedure_sensor].guid_sensor (ON UPDATE CASCADE, ON DELETE RESTRICT)
• [soilbody].guid –> [derivedprofilepresenceinsoilbody].guid_soilbody (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilbody].guid –> [isbasedonsoilbody].guid_soilbody (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilbody].guid –> [soilbody_geom].guid_soilbody (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilderivedobject].guid –> [datastream].guid_soilderivedobject (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilderivedobject].guid –> [isbasedonobservedsoilprofile].guid_soilderivedobject (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilderivedobject].guid –> [isbasedonsoilbody].guid_soilderivedobject (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilderivedobject].guid –> [isbasedonsoilderivedobject].guid_related (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilderivedobject].guid –> [isbasedonsoilderivedobject].guid_base (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilplot].guid –> [soilprofile].location (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilprofile].guid –> [datastream].guid_soilprofile (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilprofile].guid –> [derivedprofilepresenceinsoilbody].guid_soilprofile (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilprofile].guid –> [isbasedonobservedsoilprofile].guid_soilprofile (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilprofile].guid –> [isderivedfrom].guid_related (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilprofile].guid –> [isderivedfrom].guid_base (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilprofile].guid –> [othersoilnametype].othersoilname (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilprofile].guid –> [profileelement].ispartof (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilprofile].guid –> [wrbqualifiergroup_profile].guid_soilprofile (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilsite].guid –> [datastream].guid_soilsite (ON UPDATE CASCADE, ON DELETE CASCADE)
• [soilsite].guid –> [soilplot].locatedon (ON UPDATE CASCADE, ON DELETE NO ACTION)
• [thing].guid –> [datastream].guid_thing (ON UPDATE CASCADE, ON DELETE CASCADE)
• [unitofmeasure].code –> [datastream].code_unitofmeasure (ON UPDATE CASCADE, ON DELETE CASCADE)
• [wrbqualifiergrouptype].guid –> [wrbqualifiergroup_profile].guid_wrbqualifiergrouptype (ON UPDATE CASCADE, ON DELETE CASCADE)

Legend:

• column name prefixed with ‘*’ denotes PRIMARY KEY in table boxes.
• arrow ‘child –> parent’ indicates a many-to-one relationship.
• arrow ‘parent –> child’ indicates the reverse view of the same FK.