| fk_actionannotations_actions |
actionannotations.actionid |
actions.actionid |
Cascade on delete |
| fk_actionannotations_annotations |
actionannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_actiondirectives_actions |
actiondirectives.actionid |
actions.actionid |
Cascade on delete |
| fk_actiondirectives_directives |
actiondirectives.directiveid |
directives.directiveid |
Cascade on delete |
| fk_actionextensionpropertyvalues_actions |
actionextensionpropertyvalues.actionid |
actions.actionid |
Cascade on delete |
| fk_actionextensionpropertyvalues_extensionproperties |
actionextensionpropertyvalues.propertyid |
extensionproperties.propertyid |
Cascade on delete |
| fk_actionpeople_actions |
actionby.actionid |
actions.actionid |
Cascade on delete |
| fk_actionpeople_affiliations |
actionby.affiliationid |
affiliations.affiliationid |
Cascade on delete |
| fk_actions_cv_actiontype |
actions.actiontypecv |
cv_actiontype.name |
Cascade on delete |
| fk_actions_methods |
actions.methodid |
methods.methodid |
Cascade on delete |
| fk_affiliations_organizations |
affiliations.organizationid |
organizations.organizationid |
Cascade on delete |
| fk_affiliations_people |
affiliations.personid |
people.personid |
Cascade on delete |
| fk_annotations_citations |
annotations.citationid |
citations.citationid |
Cascade on delete |
| fk_annotations_cv_annotationtype |
annotations.annotationtypecv |
cv_annotationtype.name |
Cascade on delete |
| fk_annotations_people |
annotations.annotatorid |
people.personid |
Cascade on delete |
| fk_authorlists_citations |
authorlists.citationid |
citations.citationid |
Cascade on delete |
| fk_authorlists_people |
authorlists.personid |
people.personid |
Cascade on delete |
| fk_calibrationactions_actions |
calibrationactions.actionid |
actions.actionid |
Cascade on delete |
| fk_calibrationactions_instrumentoutputvariables |
calibrationactions.instrumentoutputvariableid |
instrumentoutputvariables.instrumentoutputvariableid |
Cascade on delete |
| fk_calibrationreferenceequipment_calibrationactions |
calibrationreferenceequipment.actionid |
calibrationactions.actionid |
Cascade on delete |
| fk_calibrationreferenceequipment_equipment |
calibrationreferenceequipment.equipmentid |
equipment.equipmentid |
Cascade on delete |
| fk_calibrationstandards_calibrationactions |
calibrationstandards.actionid |
calibrationactions.actionid |
Cascade on delete |
| fk_categoricalresults_cv_qualitycode |
categoricalresults.qualitycodecv |
cv_qualitycode.name |
Cascade on delete |
| fk_categoricalresults_results |
categoricalresults.resultid |
results.resultid |
Cascade on delete |
| fk_categoricalresults_spatialreferences |
categoricalresults.spatialreferenceid |
spatialreferences.spatialreferenceid |
Cascade on delete |
| fk_categoricalresultvalueannotations_annotations |
categoricalresultvalueannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_categoricalresultvalueannotations_categoricalresultvalues |
categoricalresultvalueannotations.valueid |
categoricalresultvalues.valueid |
Cascade on delete |
| fk_categoricalresultvalues_categoricalresults |
categoricalresultvalues.resultid |
categoricalresults.resultid |
Cascade on delete |
| fk_citationextensionpropertyvalues_citations |
citationextensionpropertyvalues.citationid |
citations.citationid |
Cascade on delete |
| fk_citationextensionpropertyvalues_extensionproperties |
citationextensionpropertyvalues.propertyid |
extensionproperties.propertyid |
Cascade on delete |
| fk_citationexternalidentifiers_citations |
citationexternalidentifiers.citationid |
citations.citationid |
Cascade on delete |
| fk_citationexternalidentifiers_externalidentifiersystems |
citationexternalidentifiers.externalidentifiersystemid |
externalidentifiersystems.externalidentifiersystemid |
Cascade on delete |
| fk_dataloggerfilecolumns_cv_aggregationstatistic |
dataloggerfilecolumns.aggregationstatisticcv |
cv_aggregationstatistic.name |
Cascade on delete |
| fk_dataloggerfilecolumns_dataloggerfiles |
dataloggerfilecolumns.dataloggerfileid |
dataloggerfiles.dataloggerfileid |
Cascade on delete |
| fk_dataloggerfilecolumns_instrumentoutputvariables |
dataloggerfilecolumns.instrumentoutputvariableid |
instrumentoutputvariables.instrumentoutputvariableid |
Cascade on delete |
| fk_dataloggerfilecolumns_recordingunits |
dataloggerfilecolumns.recordingintervalunitsid |
units.unitsid |
Cascade on delete |
| fk_dataloggerfilecolumns_results |
dataloggerfilecolumns.resultid |
results.resultid |
Cascade on delete |
| fk_dataloggerfilecolumns_scanunits |
dataloggerfilecolumns.scanintervalunitsid |
units.unitsid |
Cascade on delete |
| fk_dataloggerfiles_dataloggerprogramfiles |
dataloggerfiles.programid |
dataloggerprogramfiles.programid |
Cascade on delete |
| fk_dataloggerprogramfiles_affiliations |
dataloggerprogramfiles.affiliationid |
affiliations.affiliationid |
Cascade on delete |
| fk_dataquality_cv_dataqualitytype |
dataquality.dataqualitytypecv |
cv_dataqualitytype.name |
Cascade on delete |
| fk_dataquality_units |
dataquality.dataqualityvalueunitsid |
units.unitsid |
Cascade on delete |
| fk_datasetcitations_citations |
datasetcitations.citationid |
citations.citationid |
Cascade on delete |
| fk_datasetcitations_cv_relationshiptype |
datasetcitations.relationshiptypecv |
cv_relationshiptype.name |
Cascade on delete |
| fk_datasetcitations_datasets |
datasetcitations.datasetid |
datasets.datasetid |
Cascade on delete |
| fk_datasets_cv_datasettypecv |
datasets.datasettypecv |
cv_datasettype.name |
Cascade on delete |
| fk_datasetsresults_datasets |
datasetsresults.datasetid |
datasets.datasetid |
Cascade on delete |
| fk_datasetsresults_results |
datasetsresults.resultid |
results.resultid |
Cascade on delete |
| fk_directives_cv_directivetype |
directives.directivetypecv |
cv_directivetype.name |
Cascade on delete |
| fk_equipment_cv_equipmenttype |
equipment.equipmenttypecv |
cv_equipmenttype.name |
Cascade on delete |
| fk_equipment_equipmentmodels |
equipment.equipmentmodelid |
equipmentmodels.equipmentmodelid |
Cascade on delete |
| fk_equipment_organizations |
equipment.equipmentvendorid |
organizations.organizationid |
Cascade on delete |
| fk_equipment_people |
equipment.equipmentownerid |
people.personid |
Cascade on delete |
| fk_equipmentactions_actions |
equipmentused.actionid |
actions.actionid |
Cascade on delete |
| fk_equipmentactions_equipment |
equipmentused.equipmentid |
equipment.equipmentid |
Cascade on delete |
| fk_equipmentannotations_annotations |
equipmentannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_equipmentannotations_equipment |
equipmentannotations.equipmentid |
equipment.equipmentid |
Cascade on delete |
| fk_equipmentmodels_organizations |
equipmentmodels.modelmanufacturerid |
organizations.organizationid |
Cascade on delete |
| fk_extensionproperties_cv_propertydatatype |
extensionproperties.propertydatatypecv |
cv_propertydatatype.name |
Cascade on delete |
| fk_extensionproperties_units |
extensionproperties.propertyunitsid |
units.unitsid |
Cascade on delete |
| fk_externalidentifiersystems_organizations |
externalidentifiersystems.identifiersystemorganizationid |
organizations.organizationid |
Cascade on delete |
| fk_featureactions_actions |
featureactions.actionid |
actions.actionid |
Cascade on delete |
| fk_featureparents_spatialoffsets |
relatedfeatures.spatialoffsetid |
spatialoffsets.spatialoffsetid |
Cascade on delete |
| fk_fieldcalibrationstandards_referencematerials |
calibrationstandards.referencematerialid |
referencematerials.referencematerialid |
Cascade on delete |
| fk_instrumentoutputvariables_equipmentmodels |
instrumentoutputvariables.modelid |
equipmentmodels.equipmentmodelid |
Cascade on delete |
| fk_instrumentoutputvariables_methods |
instrumentoutputvariables.instrumentmethodid |
methods.methodid |
Cascade on delete |
| fk_instrumentoutputvariables_units |
instrumentoutputvariables.instrumentrawoutputunitsid |
units.unitsid |
Cascade on delete |
| fk_instrumentoutputvariables_variables |
instrumentoutputvariables.variableid |
variables.variableid |
Cascade on delete |
| fk_maintenanceactions_actions |
maintenanceactions.actionid |
actions.actionid |
Cascade on delete |
| fk_measurementresults_aiunits |
measurementresults.timeaggregationintervalunitsid |
units.unitsid |
Cascade on delete |
| fk_measurementresults_cv_aggregationstatistic |
measurementresults.aggregationstatisticcv |
cv_aggregationstatistic.name |
Cascade on delete |
| fk_measurementresults_cv_censorcode |
measurementresults.censorcodecv |
cv_censorcode.name |
Cascade on delete |
| fk_measurementresults_cv_qualitycode |
measurementresults.qualitycodecv |
cv_qualitycode.name |
Cascade on delete |
| fk_measurementresults_results |
measurementresults.resultid |
results.resultid |
Cascade on delete |
| fk_measurementresults_spatialreferences |
measurementresults.spatialreferenceid |
spatialreferences.spatialreferenceid |
Cascade on delete |
| fk_measurementresults_xunits |
measurementresults.xlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_measurementresults_yunits |
measurementresults.ylocationunitsid |
units.unitsid |
Cascade on delete |
| fk_measurementresults_zunits |
measurementresults.zlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_measurementresultvalueannotations_measurementresultvalues |
measurementresultvalueannotations.valueid |
measurementresultvalues.valueid |
Cascade on delete |
| fk_measurementresultvalues_measurementresults |
measurementresultvalues.resultid |
measurementresults.resultid |
Cascade on delete |
| fk_methodannotations_annotations |
methodannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_methodannotations_methods |
methodannotations.methodid |
methods.methodid |
Cascade on delete |
| fk_methodcitations_citations |
methodcitations.citationid |
citations.citationid |
Cascade on delete |
| fk_methodcitations_cv_relationshiptype |
methodcitations.relationshiptypecv |
cv_relationshiptype.name |
Cascade on delete |
| fk_methodcitations_methods |
methodcitations.methodid |
methods.methodid |
Cascade on delete |
| fk_methodextensionpropertyvalues_extensionproperties |
methodextensionpropertyvalues.propertyid |
extensionproperties.propertyid |
Cascade on delete |
| fk_methodextensionpropertyvalues_methods |
methodextensionpropertyvalues.methodid |
methods.methodid |
Cascade on delete |
| fk_methodexternalidentifiers_externalidentifiersystems |
methodexternalidentifiers.externalidentifiersystemid |
externalidentifiersystems.externalidentifiersystemid |
Cascade on delete |
| fk_methodexternalidentifiers_methods |
methodexternalidentifiers.methodid |
methods.methodid |
Cascade on delete |
| fk_methods_cv_methodtype |
methods.methodtypecv |
cv_methodtype.name |
Cascade on delete |
| fk_methods_organizations |
methods.organizationid |
organizations.organizationid |
Cascade on delete |
| fk_modelaffiliations_affiliations |
modelaffiliations.affiliationid |
affiliations.affiliationid |
Cascade on delete |
| fk_modelaffiliations_models |
modelaffiliations.modelid |
models.modelid |
Cascade on delete |
| fk_organizations_cv_organizationtype |
organizations.organizationtypecv |
cv_organizationtype.name |
Cascade on delete |
| fk_organizations_organizations |
organizations.parentorganizationid |
organizations.organizationid |
Cascade on delete |
| fk_parenttaxon_taxon |
taxonomicclassifiers.parenttaxonomicclassifierid |
taxonomicclassifiers.taxonomicclassifierid |
Cascade on delete |
| fk_personexternalidentifiers_externalidentifiersystems |
personexternalidentifiers.externalidentifiersystemid |
externalidentifiersystems.externalidentifiersystemid |
Cascade on delete |
| fk_personexternalidentifiers_people |
personexternalidentifiers.personid |
people.personid |
Cascade on delete |
| fk_pointcoverageresults_cv_aggregationstatistic |
pointcoverageresults.aggregationstatisticcv |
cv_aggregationstatistic.name |
Cascade on delete |
| fk_pointcoverageresults_results |
pointcoverageresults.resultid |
results.resultid |
Cascade on delete |
| fk_pointcoverageresults_spatialreferences |
pointcoverageresults.spatialreferenceid |
spatialreferences.spatialreferenceid |
Cascade on delete |
| fk_pointcoverageresults_xunits |
pointcoverageresults.intendedxspacingunitsid |
units.unitsid |
Cascade on delete |
| fk_pointcoverageresults_yunits |
pointcoverageresults.intendedyspacingunitsid |
units.unitsid |
Cascade on delete |
| fk_pointcoverageresults_zunits |
pointcoverageresults.zlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_pointcoverageresultvalueannotations_annotations |
pointcoverageresultvalueannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_pointcoverageresultvalueannotations_pointcoverageresultvalue |
pointcoverageresultvalueannotations.valueid |
pointcoverageresultvalues.valueid |
Cascade on delete |
| fk_pointcoverageresultvalues_cv_censorcode |
pointcoverageresultvalues.censorcodecv |
cv_censorcode.name |
Cascade on delete |
| fk_pointcoverageresultvalues_cv_qualitycode |
pointcoverageresultvalues.qualitycodecv |
cv_qualitycode.name |
Cascade on delete |
| fk_pointcoverageresultvalues_pointcoverageresults |
pointcoverageresultvalues.resultid |
pointcoverageresults.resultid |
Cascade on delete |
| fk_pointcoverageresultvalues_xunits |
pointcoverageresultvalues.xlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_pointcoverageresultvalues_yunits |
pointcoverageresultvalues.ylocationunitsid |
units.unitsid |
Cascade on delete |
| fk_profileresults_cv_aggregationstatistic |
profileresults.aggregationstatisticcv |
cv_aggregationstatistic.name |
Cascade on delete |
| fk_profileresults_dunits |
profileresults.intendedzspacingunitsid |
units.unitsid |
Cascade on delete |
| fk_profileresults_results |
profileresults.resultid |
results.resultid |
Cascade on delete |
| fk_profileresults_spatialreferences |
profileresults.spatialreferenceid |
spatialreferences.spatialreferenceid |
Cascade on delete |
| fk_profileresults_tunits |
profileresults.intendedtimespacingunitsid |
units.unitsid |
Cascade on delete |
| fk_profileresults_xunits |
profileresults.xlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_profileresults_yunits |
profileresults.ylocationunitsid |
units.unitsid |
Cascade on delete |
| fk_profileresultvalueannotations_annotations |
profileresultvalueannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_profileresultvalueannotations_profileresultvalues |
profileresultvalueannotations.valueid |
profileresultvalues.valueid |
Cascade on delete |
| fk_profileresultvalues_aiunits |
profileresultvalues.timeaggregationintervalunitsid |
units.unitsid |
Cascade on delete |
| fk_profileresultvalues_cv_censorcode |
profileresultvalues.censorcodecv |
cv_censorcode.name |
Cascade on delete |
| fk_profileresultvalues_cv_qualitycode |
profileresultvalues.qualitycodecv |
cv_qualitycode.name |
Cascade on delete |
| fk_profileresultvalues_dunits |
profileresultvalues.zlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_profileresultvalues_profileresults |
profileresultvalues.resultid |
profileresults.resultid |
Cascade on delete |
| fk_referencematerials_cv_medium |
referencematerials.referencematerialmediumcv |
cv_medium.name |
Cascade on delete |
| fk_referencematerials_organizations |
referencematerials.referencematerialorganizationid |
organizations.organizationid |
Cascade on delete |
| fk_referencematerialvalues_citations |
referencematerialvalues.citationid |
citations.citationid |
Cascade on delete |
| fk_referencematerialvalues_referencematerials |
referencematerialvalues.referencematerialid |
referencematerials.referencematerialid |
Cascade on delete |
| fk_referencematerialvalues_units |
referencematerialvalues.unitsid |
units.unitsid |
Cascade on delete |
| fk_referencematerialvalues_variables |
referencematerialvalues.variableid |
variables.variableid |
Cascade on delete |
| fk_refmaterialextidentifiers_extidentifiersystems |
referencematerialexternalidentifiers.externalidentifiersystemid |
externalidentifiersystems.externalidentifiersystemid |
Cascade on delete |
| fk_refmaterialextidentifiers_refmaterials |
referencematerialexternalidentifiers.referencematerialid |
referencematerials.referencematerialid |
Cascade on delete |
| fk_relatedactions_actions |
relatedactions.actionid |
actions.actionid |
Cascade on delete |
| fk_relatedactions_actions_arerelated |
relatedactions.relatedactionid |
actions.actionid |
Cascade on delete |
| fk_relatedactions_cv_relationshiptype |
relatedactions.relationshiptypecv |
cv_relationshiptype.name |
Cascade on delete |
| fk_relatedannotations_annotations |
relatedannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_relatedannotations_annotations_arerelated |
relatedannotations.relatedannotationid |
annotations.annotationid |
Cascade on delete |
| fk_relatedannotations_cv_relationshiptype |
relatedannotations.relationshiptypecv |
cv_relationshiptype.name |
Cascade on delete |
| fk_relatedcitations_citations |
relatedcitations.citationid |
citations.citationid |
Cascade on delete |
| fk_relatedcitations_citations_arerelated |
relatedcitations.relatedcitationid |
citations.citationid |
Cascade on delete |
| fk_relatedcitations_cv_relationshiptype |
relatedcitations.relationshiptypecv |
cv_relationshiptype.name |
Cascade on delete |
| fk_relateddatasets_cv_relationshiptype |
relateddatasets.relationshiptypecv |
cv_relationshiptype.name |
Cascade on delete |
| fk_relateddatasets_datasets |
relateddatasets.datasetid |
datasets.datasetid |
Cascade on delete |
| fk_relateddatasets_datasets_arerelated |
relateddatasets.relateddatasetid |
datasets.datasetid |
Cascade on delete |
| fk_relatedequipment_cv_relationshiptype |
relatedequipment.relationshiptypecv |
cv_relationshiptype.name |
Cascade on delete |
| fk_relatedequipment_equipment |
relatedequipment.equipmentid |
equipment.equipmentid |
Cascade on delete |
| fk_relatedequipment_equipment_arerelated |
relatedequipment.relatedequipmentid |
equipment.equipmentid |
Cascade on delete |
| fk_relatedfeatures_cv_relationshiptype |
relatedfeatures.relationshiptypecv |
cv_relationshiptype.name |
Cascade on delete |
| fk_relatedmodels_cv_relationshiptype |
relatedmodels.relationshiptypecv |
cv_relationshiptype.name |
Cascade on delete |
| fk_relatedmodels_models |
relatedmodels.modelid |
models.modelid |
Cascade on delete |
| fk_relatedresults_cv_relationshiptype |
relatedresults.relationshiptypecv |
cv_relationshiptype.name |
Cascade on delete |
| fk_relatedresults_results |
relatedresults.resultid |
results.resultid |
Cascade on delete |
| fk_relatedresults_results_arerelated |
relatedresults.relatedresultid |
results.resultid |
Cascade on delete |
| fk_resultannotations_annotations |
resultannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_resultannotations_results |
resultannotations.resultid |
results.resultid |
Cascade on delete |
| fk_resultderivationequations_derivationequations |
resultderivationequations.derivationequationid |
derivationequations.derivationequationid |
Cascade on delete |
| fk_resultderivationequations_results |
resultderivationequations.resultid |
results.resultid |
Cascade on delete |
| fk_resultextensionpropertyvalues_extensionproperties |
resultextensionpropertyvalues.propertyid |
extensionproperties.propertyid |
Cascade on delete |
| fk_resultextensionpropertyvalues_results |
resultextensionpropertyvalues.resultid |
results.resultid |
Cascade on delete |
| fk_resultnormalizationvalues_referencematerialvalues |
resultnormalizationvalues.normalizedbyreferencematerialvalueid |
referencematerialvalues.referencematerialvalueid |
Cascade on delete |
| fk_resultnormalizationvalues_results |
resultnormalizationvalues.resultid |
results.resultid |
Cascade on delete |
| fk_results_cv_medium |
results.sampledmediumcv |
cv_medium.name |
Cascade on delete |
| fk_results_cv_resulttype |
results.resulttypecv |
cv_resulttype.name |
Cascade on delete |
| fk_results_cv_status |
results.statuscv |
cv_status.name |
Cascade on delete |
| fk_results_featureactions |
results.featureactionid |
featureactions.featureactionid |
Cascade on delete |
| fk_results_processinglevels |
results.processinglevelid |
processinglevels.processinglevelid |
Cascade on delete |
| fk_results_taxonomicclassifiers |
results.taxonomicclassifierid |
taxonomicclassifiers.taxonomicclassifierid |
Cascade on delete |
| fk_results_units |
results.unitsid |
units.unitsid |
Cascade on delete |
| fk_results_variables |
results.variableid |
variables.variableid |
Cascade on delete |
| fk_resultsdataquality_dataquality |
resultsdataquality.dataqualityid |
dataquality.dataqualityid |
Cascade on delete |
| fk_resultsdataquality_results |
resultsdataquality.resultid |
results.resultid |
Cascade on delete |
| fk_resultvalueannotations_annotations |
measurementresultvalueannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_samplingfeatureannotations_annotations |
samplingfeatureannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_samplingfeatureextensionpropertyvalues_extensionproperties |
samplingfeatureextensionpropertyvalues.propertyid |
extensionproperties.propertyid |
Cascade on delete |
| fk_samplingfeatureexternalidentifiers_externalidentifiersystems |
samplingfeatureexternalidentifiers.externalidentifiersystemid |
externalidentifiersystems.externalidentifiersystemid |
Cascade on delete |
| fk_sectionresults_cv_aggregationstatistic |
sectionresults.aggregationstatisticcv |
cv_aggregationstatistic.name |
Cascade on delete |
| fk_sectionresults_results |
sectionresults.resultid |
results.resultid |
Cascade on delete |
| fk_sectionresults_spatialreferences |
sectionresults.spatialreferenceid |
spatialreferences.spatialreferenceid |
Cascade on delete |
| fk_sectionresults_tmunits |
sectionresults.intendedtimespacingunitsid |
units.unitsid |
Cascade on delete |
| fk_sectionresults_units |
sectionresults.ylocationunitsid |
units.unitsid |
Cascade on delete |
| fk_sectionresults_xunits |
sectionresults.intendedxspacingunitsid |
units.unitsid |
Cascade on delete |
| fk_sectionresults_zunits |
sectionresults.intendedzspacingunitsid |
units.unitsid |
Cascade on delete |
| fk_sectionresultvalueannotations_annotations |
sectionresultvalueannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_sectionresultvalueannotations_sectionresultvalues |
sectionresultvalueannotations.valueid |
sectionresultvalues.valueid |
Cascade on delete |
| fk_sectionresultvalues_aiunits |
sectionresultvalues.timeaggregationintervalunitsid |
units.unitsid |
Cascade on delete |
| fk_sectionresultvalues_cv_aggregationstatistic |
sectionresultvalues.aggregationstatisticcv |
cv_aggregationstatistic.name |
Cascade on delete |
| fk_sectionresultvalues_cv_censorcode |
sectionresultvalues.censorcodecv |
cv_censorcode.name |
Cascade on delete |
| fk_sectionresultvalues_cv_qualitycode |
sectionresultvalues.qualitycodecv |
cv_qualitycode.name |
Cascade on delete |
| fk_sectionresultvalues_sectionresults |
sectionresultvalues.resultid |
sectionresults.resultid |
Cascade on delete |
| fk_sectionresultvalues_xunits |
sectionresultvalues.xlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_sectionresultvalues_zunits |
sectionresultvalues.zlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_simulations_actions |
simulations.actionid |
actions.actionid |
Cascade on delete |
| fk_simulations_models |
simulations.modelid |
models.modelid |
Cascade on delete |
| fk_sites_cv_sitetype |
sites.sitetypecv |
cv_sitetype.name |
Cascade on delete |
| fk_sites_spatialreferences |
sites.spatialreferenceid |
spatialreferences.spatialreferenceid |
Cascade on delete |
| fk_spatialoffsets_cv_spatialoffsettype |
spatialoffsets.spatialoffsettypecv |
cv_spatialoffsettype.name |
Cascade on delete |
| fk_spatialoffsets_offset1units |
spatialoffsets.offset1unitid |
units.unitsid |
Cascade on delete |
| fk_spatialoffsets_offset2units |
spatialoffsets.offset2unitid |
units.unitsid |
Cascade on delete |
| fk_spatialoffsets_offset3units |
spatialoffsets.offset3unitid |
units.unitsid |
Cascade on delete |
| fk_spatialreferenceexternalidentifiers_externalidentifiersystem |
spatialreferenceexternalidentifiers.externalidentifiersystemid |
externalidentifiersystems.externalidentifiersystemid |
Cascade on delete |
| fk_spatialreferenceexternalidentifiers_spatialreferences |
spatialreferenceexternalidentifiers.spatialreferenceid |
spatialreferences.spatialreferenceid |
Cascade on delete |
| fk_specimenbatchpostions_featureactions |
specimenbatchpostions.featureactionid |
featureactions.featureactionid |
Cascade on delete |
| fk_specimens_cv_medium |
specimens.specimenmediumcv |
cv_medium.name |
Cascade on delete |
| fk_specimens_cv_specimentype |
specimens.specimentypecv |
cv_specimentype.name |
Cascade on delete |
| fk_specimentaxonomicclassifiers_citations |
specimentaxonomicclassifiers.citationid |
citations.citationid |
Cascade on delete |
| fk_specimentaxonomicclassifiers_specimens |
specimentaxonomicclassifiers.samplingfeatureid |
specimens.samplingfeatureid |
Cascade on delete |
| fk_specimentaxonomicclassifiers_taxonomicclassifiers |
specimentaxonomicclassifiers.taxonomicclassifierid |
taxonomicclassifiers.taxonomicclassifierid |
Cascade on delete |
| fk_spectraresults_cv_aggregationstatistic |
spectraresults.aggregationstatisticcv |
cv_aggregationstatistic.name |
Cascade on delete |
| fk_spectraresults_results |
spectraresults.resultid |
results.resultid |
Cascade on delete |
| fk_spectraresults_spatialreferences |
spectraresults.spatialreferenceid |
spatialreferences.spatialreferenceid |
Cascade on delete |
| fk_spectraresults_units |
spectraresults.intendedwavelengthspacingunitsid |
units.unitsid |
Cascade on delete |
| fk_spectraresults_xunits |
spectraresults.xlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_spectraresults_yunits |
spectraresults.ylocationunitsid |
units.unitsid |
Cascade on delete |
| fk_spectraresults_zunits |
spectraresults.zlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_spectraresultvalueannotations_annotations |
spectraresultvalueannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_spectraresultvalueannotations_spectraresultvalues |
spectraresultvalueannotations.valueid |
spectraresultvalues.valueid |
Cascade on delete |
| fk_spectraresultvalues_aiunits |
spectraresultvalues.timeaggregationintervalunitsid |
units.unitsid |
Cascade on delete |
| fk_spectraresultvalues_cv_censorcode |
spectraresultvalues.censorcodecv |
cv_censorcode.name |
Cascade on delete |
| fk_spectraresultvalues_cv_qualitycode |
spectraresultvalues.qualitycodecv |
cv_qualitycode.name |
Cascade on delete |
| fk_spectraresultvalues_spectraresults |
spectraresultvalues.resultid |
spectraresults.resultid |
Cascade on delete |
| fk_spectraresultvalues_wunits |
spectraresultvalues.wavelengthunitsid |
units.unitsid |
Cascade on delete |
| fk_taxonomicclassifierextids_extidsystems |
taxonomicclassifierexternalidentifiers.externalidentifiersystemid |
externalidentifiersystems.externalidentifiersystemid |
Cascade on delete |
| fk_taxonomicclassifierextids_taxonomicclassifiers |
taxonomicclassifierexternalidentifiers.taxonomicclassifierid |
taxonomicclassifiers.taxonomicclassifierid |
Cascade on delete |
| fk_taxonomicclassifiers_cv_taxonomicclassifiertype |
taxonomicclassifiers.taxonomicclassifiertypecv |
cv_taxonomicclassifiertype.name |
Cascade on delete |
| fk_timeseriesresults_cv_aggregationstatistic |
timeseriesresults.aggregationstatisticcv |
cv_aggregationstatistic.name |
Cascade on delete |
| fk_timeseriesresults_results |
timeseriesresults.resultid |
results.resultid |
Cascade on delete |
| fk_timeseriesresults_spatialreferences |
timeseriesresults.spatialreferenceid |
spatialreferences.spatialreferenceid |
Cascade on delete |
| fk_timeseriesresults_tunits |
timeseriesresults.intendedtimespacingunitsid |
units.unitsid |
Cascade on delete |
| fk_timeseriesresults_xunits |
timeseriesresults.xlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_timeseriesresults_yunits |
timeseriesresults.ylocationunitsid |
units.unitsid |
Cascade on delete |
| fk_timeseriesresults_zunits |
timeseriesresults.zlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_timeseriesresultvalueannotations_annotations |
timeseriesresultvalueannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_timeseriesresultvalueannotations_timeseriesresultvalues |
timeseriesresultvalueannotations.valueid |
timeseriesresultvalues.valueid |
Cascade on delete |
| fk_timeseriesresultvalues_aiunits |
timeseriesresultvalues.timeaggregationintervalunitsid |
units.unitsid |
Cascade on delete |
| fk_timeseriesresultvalues_cv_censorcode |
timeseriesresultvalues.censorcodecv |
cv_censorcode.name |
Cascade on delete |
| fk_timeseriesresultvalues_cv_qualitycode |
timeseriesresultvalues.qualitycodecv |
cv_qualitycode.name |
Cascade on delete |
| fk_timeseriesresultvalues_timeseriesresults |
timeseriesresultvalues.resultid |
timeseriesresults.resultid |
Cascade on delete |
| fk_trajectoryresults_cv_aggregationstatistic |
trajectoryresults.aggregationstatisticcv |
cv_aggregationstatistic.name |
Cascade on delete |
| fk_trajectoryresults_results |
trajectoryresults.resultid |
results.resultid |
Cascade on delete |
| fk_trajectoryresults_spatialreferences |
trajectoryresults.spatialreferenceid |
spatialreferences.spatialreferenceid |
Cascade on delete |
| fk_trajectoryresults_tsunits |
trajectoryresults.intendedtrajectoryspacingunitsid |
units.unitsid |
Cascade on delete |
| fk_trajectoryresults_tunits |
trajectoryresults.intendedtimespacingunitsid |
units.unitsid |
Cascade on delete |
| fk_trajectoryresultvalueannotations_annotations |
trajectoryresultvalueannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_trajectoryresultvalueannotations_trajectoryresultvalues |
trajectoryresultvalueannotations.valueid |
trajectoryresultvalues.valueid |
Cascade on delete |
| fk_trajectoryresultvalues_aiunits |
trajectoryresultvalues.timeaggregationintervalunitsid |
units.unitsid |
Cascade on delete |
| fk_trajectoryresultvalues_cv_censorcode |
trajectoryresultvalues.censorcodecv |
cv_censorcode.name |
Cascade on delete |
| fk_trajectoryresultvalues_cv_qualitycode |
trajectoryresultvalues.qualitycodecv |
cv_qualitycode.name |
Cascade on delete |
| fk_trajectoryresultvalues_distanceunits |
trajectoryresultvalues.trajectorydistanceunitsid |
units.unitsid |
Cascade on delete |
| fk_trajectoryresultvalues_trajectoryresults |
trajectoryresultvalues.resultid |
trajectoryresults.resultid |
Cascade on delete |
| fk_trajectoryresultvalues_xunits |
trajectoryresultvalues.xlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_trajectoryresultvalues_yunits |
trajectoryresultvalues.ylocationunitsid |
units.unitsid |
Cascade on delete |
| fk_trajectoryresultvalues_zunits |
trajectoryresultvalues.zlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_transectresults_cv_aggregationstatistic |
transectresults.aggregationstatisticcv |
cv_aggregationstatistic.name |
Cascade on delete |
| fk_transectresults_results |
transectresults.resultid |
results.resultid |
Cascade on delete |
| fk_transectresults_spatialreferences |
transectresults.spatialreferenceid |
spatialreferences.spatialreferenceid |
Cascade on delete |
| fk_transectresults_tmunits |
transectresults.intendedtimespacingunitsid |
units.unitsid |
Cascade on delete |
| fk_transectresults_tsunits |
transectresults.intendedtransectspacingunitsid |
units.unitsid |
Cascade on delete |
| fk_transectresults_units |
transectresults.zlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_transectresultvalueannotations_annotations |
transectresultvalueannotations.annotationid |
annotations.annotationid |
Cascade on delete |
| fk_transectresultvalueannotations_transectresultvalues |
transectresultvalueannotations.valueid |
transectresultvalues.valueid |
Cascade on delete |
| fk_transectresultvalues_aiunits |
transectresultvalues.timeaggregationintervalunitsid |
units.unitsid |
Cascade on delete |
| fk_transectresultvalues_cv_aggregationstatistic |
transectresultvalues.aggregationstatisticcv |
cv_aggregationstatistic.name |
Cascade on delete |
| fk_transectresultvalues_cv_censorcode |
transectresultvalues.censorcodecv |
cv_censorcode.name |
Cascade on delete |
| fk_transectresultvalues_cv_qualitycode |
transectresultvalues.qualitycodecv |
cv_qualitycode.name |
Cascade on delete |
| fk_transectresultvalues_distanceunits |
transectresultvalues.transectdistanceunitsid |
units.unitsid |
Cascade on delete |
| fk_transectresultvalues_transectresults |
transectresultvalues.resultid |
transectresults.resultid |
Cascade on delete |
| fk_transectresultvalues_xunits |
transectresultvalues.xlocationunitsid |
units.unitsid |
Cascade on delete |
| fk_transectresultvalues_yunits |
transectresultvalues.ylocationunitsid |
units.unitsid |
Cascade on delete |
| fk_units_cv_unitstype |
units.unitstypecv |
cv_unitstype.name |
Cascade on delete |
| fk_variableextensionpropertyvalues_extensionproperties |
variableextensionpropertyvalues.propertyid |
extensionproperties.propertyid |
Cascade on delete |
| fk_variableextensionpropertyvalues_variables |
variableextensionpropertyvalues.variableid |
variables.variableid |
Cascade on delete |
| fk_variableexternalidentifiers_externalidentifiersystems |
variableexternalidentifiers.externalidentifiersystemid |
externalidentifiersystems.externalidentifiersystemid |
Cascade on delete |
| fk_variableexternalidentifiers_variables |
variableexternalidentifiers.variableid |
variables.variableid |
Cascade on delete |
| fk_variables_cv_speciation |
variables.speciationcv |
cv_speciation.name |
Cascade on delete |
| fk_variables_cv_variablename |
variables.variablenamecv |
cv_variablename.name |
Cascade on delete |
| fk_variables_cv_variabletype |
variables.variabletypecv |
cv_variabletype.name |
Cascade on delete |