ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ActionAnnotations_Actions	ODM2Core.Actions	ODM2Annotations.ActionAnnotations	ActionID	ActionID
fk_ActionAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.ActionAnnotations	AnnotationID	AnnotationID
fk_Annotations_Citations	ODM2Provenance.Citations	ODM2Annotations.Annotations	CitationID	CitationID
fk_Annotations_CV_AnnotationType	ODM2CV.CV_AnnotationType	ODM2Annotations.Annotations	Name	AnnotationTypeCV
fk_Annotations_People	ODM2Core.People	ODM2Annotations.Annotations	PersonID	AnnotatorID
fk_CategoricalResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.CategoricalResultValueAnnotations	AnnotationID	AnnotationID
fk_CategoricalResultValueAnnotations_CategoricalResultValues	ODM2Results.CategoricalResultValues	ODM2Annotations.CategoricalResultValueAnnotations	ValueID	ValueID
fk_EquipmentAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.EquipmentAnnotations	AnnotationID	AnnotationID
fk_EquipmentAnnotations_Equipment	ODM2Equipment.Equipment	ODM2Annotations.EquipmentAnnotations	EquipmentID	EquipmentID
fk_MeasurementResultValueAnnotations_MeasurementResultValues	ODM2Results.MeasurementResultValues	ODM2Annotations.MeasurementResultValueAnnotations	ValueID	ValueID
fk_ResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.MeasurementResultValueAnnotations	AnnotationID	AnnotationID
fk_MethodAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.MethodAnnotations	AnnotationID	AnnotationID
fk_MethodAnnotations_Methods	ODM2Core.Methods	ODM2Annotations.MethodAnnotations	MethodID	MethodID
fk_PointCoverageResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.PointCoverageResultValueAnnotations	AnnotationID	AnnotationID
fk_PointCoverageResultValueAnnotations_PointCoverageResultValues	ODM2Results.PointCoverageResultValues	ODM2Annotations.PointCoverageResultValueAnnotations	ValueID	ValueID
fk_ProfileResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.ProfileResultValueAnnotations	AnnotationID	AnnotationID
fk_ProfileResultValueAnnotations_ProfileResultValues	ODM2Results.ProfileResultValues	ODM2Annotations.ProfileResultValueAnnotations	ValueID	ValueID
fk_ResultAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.ResultAnnotations	AnnotationID	AnnotationID
fk_ResultAnnotations_Results	ODM2Core.Results	ODM2Annotations.ResultAnnotations	ResultID	ResultID
fk_SamplingFeatureAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.SamplingFeatureAnnotations	AnnotationID	AnnotationID
fk_SamplingFeatureAnnotations_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2Annotations.SamplingFeatureAnnotations	SamplingFeatureID	SamplingFeatureID
fk_SectionResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.SectionResultValueAnnotations	AnnotationID	AnnotationID
fk_SectionResultValueAnnotations_SectionResultValues	ODM2Results.SectionResultValues	ODM2Annotations.SectionResultValueAnnotations	ValueID	ValueID
fk_SpectraResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.SpectraResultValueAnnotations	AnnotationID	AnnotationID
fk_SpectraResultValueAnnotations_SpectraResultValues	ODM2Results.SpectraResultValues	ODM2Annotations.SpectraResultValueAnnotations	ValueID	ValueID
fk_TimeSeriesResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.TimeSeriesResultValueAnnotations	AnnotationID	AnnotationID
fk_TimeSeriesResultValueAnnotations_TimeSeriesResultValues	ODM2Results.TimeSeriesResultValues	ODM2Annotations.TimeSeriesResultValueAnnotations	ValueID	ValueID
fk_TrajectoryResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.TrajectoryResultValueAnnotations	AnnotationID	AnnotationID
fk_TrajectoryResultValueAnnotations_TrajectoryResultValues	ODM2Results.TrajectoryResultValues	ODM2Annotations.TrajectoryResultValueAnnotations	ValueID	ValueID
fk_TransectResultValueAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Annotations.TransectResultValueAnnotations	AnnotationID	AnnotationID
fk_TransectResultValueAnnotations_TransectResultValues	ODM2Results.TransectResultValues	ODM2Annotations.TransectResultValueAnnotations	ValueID	ValueID
fk_ActionPeople_Actions	ODM2Core.Actions	ODM2Core.ActionBy	ActionID	ActionID
fk_ActionPeople_Affiliations	ODM2Core.Affiliations	ODM2Core.ActionBy	AffiliationID	AffiliationID
fk_Actions_CV_ActionType	ODM2CV.CV_ActionType	ODM2Core.Actions	Name	ActionTypeCV
fk_Actions_Methods	ODM2Core.Methods	ODM2Core.Actions	MethodID	MethodID
fk_Affiliations_Organizations	ODM2Core.Organizations	ODM2Core.Affiliations	OrganizationID	OrganizationID
fk_Affiliations_People	ODM2Core.People	ODM2Core.Affiliations	PersonID	PersonID
fk_Datasets_CV_DatasetTypeCV	ODM2CV.CV_DatasetType	ODM2Core.Datasets	Name	DatasetTypeCV
fk_DataSetsResults_DataSets	ODM2Core.Datasets	ODM2Core.DatasetsResults	DatasetID	DatasetID
fk_DataSetsResults_Results	ODM2Core.Results	ODM2Core.DatasetsResults	ResultID	ResultID
fk_FeatureActions_Actions	ODM2Core.Actions	ODM2Core.FeatureActions	ActionID	ActionID
fk_FeatureActions_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2Core.FeatureActions	SamplingFeatureID	SamplingFeatureID
fk_Methods_CV_MethodType	ODM2CV.CV_MethodType	ODM2Core.Methods	Name	MethodTypeCV
fk_Methods_Organizations	ODM2Core.Organizations	ODM2Core.Methods	OrganizationID	OrganizationID
fk_Organizations_CV_OrganizationType	ODM2CV.CV_OrganizationType	ODM2Core.Organizations	Name	OrganizationTypeCV
fk_Organizations_Organizations	ODM2Core.Organizations	ODM2Core.Organizations	OrganizationID	ParentOrganizationID
fk_RelatedActions_Actions	ODM2Core.Actions	ODM2Core.RelatedActions	ActionID	ActionID
fk_RelatedActions_Actions_AreRelated	ODM2Core.Actions	ODM2Core.RelatedActions	ActionID	RelatedActionID
fk_RelatedActions_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Core.RelatedActions	Name	RelationshipTypeCV
fk_Results_CV_Medium	ODM2CV.CV_Medium	ODM2Core.Results	Name	SampledMediumCV
fk_Results_CV_ResultType	ODM2CV.CV_ResultType	ODM2Core.Results	Name	ResultTypeCV
fk_Results_CV_Status	ODM2CV.CV_Status	ODM2Core.Results	Name	StatusCV
fk_Results_FeatureActions	ODM2Core.FeatureActions	ODM2Core.Results	FeatureActionID	FeatureActionID
fk_Results_ProcessingLevels	ODM2Core.ProcessingLevels	ODM2Core.Results	ProcessingLevelID	ProcessingLevelID
fk_Results_TaxonomicClassifiers	ODM2Core.TaxonomicClassifiers	ODM2Core.Results	TaxonomicClassifierID	TaxonomicClassifierID
fk_Results_Units	ODM2Core.Units	ODM2Core.Results	UnitsID	UnitsID
fk_Results_Variables	ODM2Core.Variables	ODM2Core.Results	VariableID	VariableID
fk_SamplingFeatures_CV_ElevationDatum	ODM2CV.CV_ElevationDatum	ODM2Core.SamplingFeatures	Name	ElevationDatumCV
fk_SamplingFeatures_CV_SamplingFeatureGeoType	ODM2CV.CV_SamplingFeatureGeoType	ODM2Core.SamplingFeatures	Name	SamplingFeatureGeotypeCV
fk_SamplingFeatures_CV_SamplingFeatureType	ODM2CV.CV_SamplingFeatureType	ODM2Core.SamplingFeatures	Name	SamplingFeatureTypeCV
fk_ParentTaxon_Taxon	ODM2Core.TaxonomicClassifiers	ODM2Core.TaxonomicClassifiers	TaxonomicClassifierID	ParentTaxonomicClassifierID
fk_TaxonomicClassifiers_CV_TaxonomicClassifierType	ODM2CV.CV_TaxonomicClassifierType	ODM2Core.TaxonomicClassifiers	Name	TaxonomicClassifierTypeCV
fk_Units_CV_UnitsType	ODM2CV.CV_UnitsType	ODM2Core.Units	Name	UnitsTypeCV
fk_Variables_CV_Speciation	ODM2CV.CV_Speciation	ODM2Core.Variables	Name	SpeciationCV
fk_Variables_CV_VariableName	ODM2CV.CV_VariableName	ODM2Core.Variables	Name	VariableNameCV
fk_Variables_CV_VariableType	ODM2CV.CV_VariableType	ODM2Core.Variables	Name	VariableTypeCV
fk_DataQuality_CV_DataQualityType	ODM2CV.CV_DataQualityType	ODM2DataQuality.DataQuality	Name	DataQualityTypeCV
fk_DataQuality_Units	ODM2Core.Units	ODM2DataQuality.DataQuality	UnitsID	DataQualityValueUnitsID
fk_ReferenceMaterials_CV_Medium	ODM2CV.CV_Medium	ODM2DataQuality.ReferenceMaterials	Name	ReferenceMaterialMediumCV
fk_ReferenceMaterials_Organizations	ODM2Core.Organizations	ODM2DataQuality.ReferenceMaterials	OrganizationID	ReferenceMaterialOrganizationID
fk_ReferenceMaterials_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2DataQuality.ReferenceMaterials	SamplingFeatureID	SamplingFeatureID
fk_ReferenceMaterialValues_Citations	ODM2Provenance.Citations	ODM2DataQuality.ReferenceMaterialValues	CitationID	CitationID
fk_ReferenceMaterialValues_ReferenceMaterials	ODM2DataQuality.ReferenceMaterials	ODM2DataQuality.ReferenceMaterialValues	ReferenceMaterialID	ReferenceMaterialID
fk_ReferenceMaterialValues_Units	ODM2Core.Units	ODM2DataQuality.ReferenceMaterialValues	UnitsID	UnitsID
fk_ReferenceMaterialValues_Variables	ODM2Core.Variables	ODM2DataQuality.ReferenceMaterialValues	VariableID	VariableID
fk_ResultNormalizationValues_ReferenceMaterialValues	ODM2DataQuality.ReferenceMaterialValues	ODM2DataQuality.ResultNormalizationValues	ReferenceMaterialValueID	NormalizedByReferenceMaterialValueID
fk_ResultNormalizationValues_Results	ODM2Core.Results	ODM2DataQuality.ResultNormalizationValues	ResultID	ResultID
fk_ResultsDataQuality_DataQuality	ODM2DataQuality.DataQuality	ODM2DataQuality.ResultsDataQuality	DataQualityID	DataQualityID
fk_ResultsDataQuality_Results	ODM2Core.Results	ODM2DataQuality.ResultsDataQuality	ResultID	ResultID
fk_CalibrationActions_Actions	ODM2Core.Actions	ODM2Equipment.CalibrationActions	ActionID	ActionID
fk_CalibrationActions_InstrumentOutputVariables	ODM2Equipment.InstrumentOutputVariables	ODM2Equipment.CalibrationActions	InstrumentOutputVariableID	InstrumentOutputVariableID
fk_CalibrationReferenceEquipment_CalibrationActions	ODM2Equipment.CalibrationActions	ODM2Equipment.CalibrationReferenceEquipment	ActionID	ActionID
fk_CalibrationReferenceEquipment_Equipment	ODM2Equipment.Equipment	ODM2Equipment.CalibrationReferenceEquipment	EquipmentID	EquipmentID
fk_CalibrationStandards_CalibrationActions	ODM2Equipment.CalibrationActions	ODM2Equipment.CalibrationStandards	ActionID	ActionID
fk_FieldCalibrationStandards_ReferenceMaterials	ODM2DataQuality.ReferenceMaterials	ODM2Equipment.CalibrationStandards	ReferenceMaterialID	ReferenceMaterialID
fk_DataloggerFileColumns_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Equipment.DataloggerFileColumns	Name	AggregationStatisticCV
fk_DataloggerFileColumns_DataLoggerFiles	ODM2Equipment.DataLoggerFiles	ODM2Equipment.DataloggerFileColumns	DataLoggerFileID	DataLoggerFileID
fk_DataloggerFileColumns_InstrumentOutputVariables	ODM2Equipment.InstrumentOutputVariables	ODM2Equipment.DataloggerFileColumns	InstrumentOutputVariableID	InstrumentOutputVariableID
fk_DataloggerFileColumns_RecordingUnits	ODM2Core.Units	ODM2Equipment.DataloggerFileColumns	UnitsID	RecordingIntervalUnitsID
fk_DataloggerFileColumns_Results	ODM2Core.Results	ODM2Equipment.DataloggerFileColumns	ResultID	ResultID
fk_DataloggerFileColumns_ScanUnits	ODM2Core.Units	ODM2Equipment.DataloggerFileColumns	UnitsID	ScanIntervalUnitsID
fk_DataLoggerFiles_DataloggerProgramFiles	ODM2Equipment.DataloggerProgramFiles	ODM2Equipment.DataLoggerFiles	ProgramID	ProgramID
fk_DataloggerProgramFiles_Affiliations	ODM2Core.Affiliations	ODM2Equipment.DataloggerProgramFiles	AffiliationID	AffiliationID
fk_Equipment_CV_EquipmentType	ODM2CV.CV_EquipmentType	ODM2Equipment.Equipment	Name	EquipmentTypeCV
fk_Equipment_EquipmentModels	ODM2Equipment.EquipmentModels	ODM2Equipment.Equipment	EquipmentModelID	EquipmentModelID
fk_Equipment_Organizations	ODM2Core.Organizations	ODM2Equipment.Equipment	OrganizationID	EquipmentVendorID
fk_Equipment_People	ODM2Core.People	ODM2Equipment.Equipment	PersonID	EquipmentOwnerID
fk_EquipmentModels_Organizations	ODM2Core.Organizations	ODM2Equipment.EquipmentModels	OrganizationID	ModelManufacturerID
fk_EquipmentActions_Actions	ODM2Core.Actions	ODM2Equipment.EquipmentUsed	ActionID	ActionID
fk_EquipmentActions_Equipment	ODM2Equipment.Equipment	ODM2Equipment.EquipmentUsed	EquipmentID	EquipmentID
fk_InstrumentOutputVariables_EquipmentModels	ODM2Equipment.EquipmentModels	ODM2Equipment.InstrumentOutputVariables	EquipmentModelID	ModelID
fk_InstrumentOutputVariables_Methods	ODM2Core.Methods	ODM2Equipment.InstrumentOutputVariables	MethodID	InstrumentMethodID
fk_InstrumentOutputVariables_Units	ODM2Core.Units	ODM2Equipment.InstrumentOutputVariables	UnitsID	InstrumentRawOutputUnitsID
fk_InstrumentOutputVariables_Variables	ODM2Core.Variables	ODM2Equipment.InstrumentOutputVariables	VariableID	VariableID
fk_MaintenanceActions_Actions	ODM2Core.Actions	ODM2Equipment.MaintenanceActions	ActionID	ActionID
fk_RelatedEquipment_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Equipment.RelatedEquipment	Name	RelationshipTypeCV
fk_RelatedEquipment_Equipment	ODM2Equipment.Equipment	ODM2Equipment.RelatedEquipment	EquipmentID	EquipmentID
fk_RelatedEquipment_Equipment_AreRelated	ODM2Equipment.Equipment	ODM2Equipment.RelatedEquipment	EquipmentID	RelatedEquipmentID
fk_ActionExtensionPropertyValues_Actions	ODM2Core.Actions	ODM2ExtensionProperties.ActionExtensionPropertyValues	ActionID	ActionID
fk_ActionExtensionPropertyValues_ExtensionProperties	ODM2ExtensionProperties.ExtensionProperties	ODM2ExtensionProperties.ActionExtensionPropertyValues	PropertyID	PropertyID
fk_CitationExtensionPropertyValues_Citations	ODM2Provenance.Citations	ODM2ExtensionProperties.CitationExtensionPropertyValues	CitationID	CitationID
fk_CitationExtensionPropertyValues_ExtensionProperties	ODM2ExtensionProperties.ExtensionProperties	ODM2ExtensionProperties.CitationExtensionPropertyValues	PropertyID	PropertyID
fk_ExtensionProperties_CV_PropertyDataType	ODM2CV.CV_PropertyDataType	ODM2ExtensionProperties.ExtensionProperties	Name	PropertyDataTypeCV
fk_ExtensionProperties_Units	ODM2Core.Units	ODM2ExtensionProperties.ExtensionProperties	UnitsID	PropertyUnitsID
fk_MethodExtensionPropertyValues_ExtensionProperties	ODM2ExtensionProperties.ExtensionProperties	ODM2ExtensionProperties.MethodExtensionPropertyValues	PropertyID	PropertyID
fk_MethodExtensionPropertyValues_Methods	ODM2Core.Methods	ODM2ExtensionProperties.MethodExtensionPropertyValues	MethodID	MethodID
fk_ResultExtensionPropertyValues_ExtensionProperties	ODM2ExtensionProperties.ExtensionProperties	ODM2ExtensionProperties.ResultExtensionPropertyValues	PropertyID	PropertyID
fk_ResultExtensionPropertyValues_Results	ODM2Core.Results	ODM2ExtensionProperties.ResultExtensionPropertyValues	ResultID	ResultID
fk_SamplingFeatureExtensionPropertyValues_ExtensionProperties	ODM2ExtensionProperties.ExtensionProperties	ODM2ExtensionProperties.SamplingFeatureExtensionPropertyValues	PropertyID	PropertyID
fk_SamplingFeatureExtensionPropertyValues_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2ExtensionProperties.SamplingFeatureExtensionPropertyValues	SamplingFeatureID	SamplingFeatureID
fk_VariableExtensionPropertyValues_ExtensionProperties	ODM2ExtensionProperties.ExtensionProperties	ODM2ExtensionProperties.VariableExtensionPropertyValues	PropertyID	PropertyID
fk_VariableExtensionPropertyValues_Variables	ODM2Core.Variables	ODM2ExtensionProperties.VariableExtensionPropertyValues	VariableID	VariableID
fk_CitationExternalIdentifiers_Citations	ODM2Provenance.Citations	ODM2ExternalIdentifiers.CitationExternalIdentifiers	CitationID	CitationID
fk_CitationExternalIdentifiers_ExternalIdentifierSystems	ODM2ExternalIdentifiers.ExternalIdentifierSystems	ODM2ExternalIdentifiers.CitationExternalIdentifiers	ExternalIdentifierSystemID	ExternalIdentifierSystemID
fk_ExternalIdentifierSystems_Organizations	ODM2Core.Organizations	ODM2ExternalIdentifiers.ExternalIdentifierSystems	OrganizationID	IdentifierSystemOrganizationID
fk_MethodExternalIdentifiers_ExternalIdentifierSystems	ODM2ExternalIdentifiers.ExternalIdentifierSystems	ODM2ExternalIdentifiers.MethodExternalIdentifiers	ExternalIdentifierSystemID	ExternalIdentifierSystemID
fk_MethodExternalIdentifiers_Methods	ODM2Core.Methods	ODM2ExternalIdentifiers.MethodExternalIdentifiers	MethodID	MethodID
fk_PersonExternalIdentifiers_ExternalIdentifierSystems	ODM2ExternalIdentifiers.ExternalIdentifierSystems	ODM2ExternalIdentifiers.PersonExternalIdentifiers	ExternalIdentifierSystemID	ExternalIdentifierSystemID
fk_PersonExternalIdentifiers_People	ODM2Core.People	ODM2ExternalIdentifiers.PersonExternalIdentifiers	PersonID	PersonID
fk_RefMaterialExtIdentifiers_ExtIdentifierSystems	ODM2ExternalIdentifiers.ExternalIdentifierSystems	ODM2ExternalIdentifiers.ReferenceMaterialExternalIdentifiers	ExternalIdentifierSystemID	ExternalIdentifierSystemID
fk_RefMaterialExtIdentifiers_RefMaterials	ODM2DataQuality.ReferenceMaterials	ODM2ExternalIdentifiers.ReferenceMaterialExternalIdentifiers	ReferenceMaterialID	ReferenceMaterialID
fk_SamplingFeatureExternalIdentifiers_ExternalIdentifierSystems	ODM2ExternalIdentifiers.ExternalIdentifierSystems	ODM2ExternalIdentifiers.SamplingFeatureExternalIdentifiers	ExternalIdentifierSystemID	ExternalIdentifierSystemID
fk_SamplingFeatureExternalIdentifiers_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2ExternalIdentifiers.SamplingFeatureExternalIdentifiers	SamplingFeatureID	SamplingFeatureID
fk_SpatialReferenceExternalIdentifiers_ExternalIdentifierSystems	ODM2ExternalIdentifiers.ExternalIdentifierSystems	ODM2ExternalIdentifiers.SpatialReferenceExternalIdentifiers	ExternalIdentifierSystemID	ExternalIdentifierSystemID
fk_SpatialReferenceExternalIdentifiers_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2ExternalIdentifiers.SpatialReferenceExternalIdentifiers	SpatialReferenceID	SpatialReferenceID
fk_TaxonomicClassifierExtIDs_ExtIDSystems	ODM2ExternalIdentifiers.ExternalIdentifierSystems	ODM2ExternalIdentifiers.TaxonomicClassifierExternalIdentifiers	ExternalIdentifierSystemID	ExternalIdentifierSystemID
fk_TaxonomicClassifierExtIDs_TaxonomicClassifiers	ODM2Core.TaxonomicClassifiers	ODM2ExternalIdentifiers.TaxonomicClassifierExternalIdentifiers	TaxonomicClassifierID	TaxonomicClassifierID
fk_VariableExternalIdentifiers_ExternalIdentifierSystems	ODM2ExternalIdentifiers.ExternalIdentifierSystems	ODM2ExternalIdentifiers.VariableExternalIdentifiers	ExternalIdentifierSystemID	ExternalIdentifierSystemID
fk_VariableExternalIdentifiers_Variables	ODM2Core.Variables	ODM2ExternalIdentifiers.VariableExternalIdentifiers	VariableID	VariableID
fk_ActionDirectives_Actions	ODM2Core.Actions	ODM2LabAnalyses.ActionDirectives	ActionID	ActionID
fk_ActionDirectives_Directives	ODM2LabAnalyses.Directives	ODM2LabAnalyses.ActionDirectives	DirectiveID	DirectiveID
fk_Directives_CV_DirectiveType	ODM2CV.CV_DirectiveType	ODM2LabAnalyses.Directives	Name	DirectiveTypeCV
fk_SpecimenBatchPostions_FeatureActions	ODM2Core.FeatureActions	ODM2LabAnalyses.SpecimenBatchPostions	FeatureActionID	FeatureActionID
fk_AuthorLists_Citations	ODM2Provenance.Citations	ODM2Provenance.AuthorLists	CitationID	CitationID
fk_AuthorLists_People	ODM2Core.People	ODM2Provenance.AuthorLists	PersonID	PersonID
fk_DataSetCitations_Citations	ODM2Provenance.Citations	ODM2Provenance.DatasetCitations	CitationID	CitationID
fk_DatasetCitations_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Provenance.DatasetCitations	Name	RelationshipTypeCV
fk_DataSetCitations_DataSets	ODM2Core.Datasets	ODM2Provenance.DatasetCitations	DatasetID	DataSetID
fk_MethodCitations_Citations	ODM2Provenance.Citations	ODM2Provenance.MethodCitations	CitationID	CitationID
fk_MethodCitations_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Provenance.MethodCitations	Name	RelationshipTypeCV
fk_MethodCitations_Methods	ODM2Core.Methods	ODM2Provenance.MethodCitations	MethodID	MethodID
fk_RelatedAnnotations_Annotations	ODM2Annotations.Annotations	ODM2Provenance.RelatedAnnotations	AnnotationID	AnnotationID
fk_RelatedAnnotations_Annotations_AreRelated	ODM2Annotations.Annotations	ODM2Provenance.RelatedAnnotations	AnnotationID	RelatedAnnotationID
fk_RelatedAnnotations_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Provenance.RelatedAnnotations	Name	RelationshipTypeCV
fk_RelatedCitations_Citations	ODM2Provenance.Citations	ODM2Provenance.RelatedCitations	CitationID	CitationID
fk_RelatedCitations_Citations_AreRelated	ODM2Provenance.Citations	ODM2Provenance.RelatedCitations	CitationID	RelatedCitationID
fk_RelatedCitations_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Provenance.RelatedCitations	Name	RelationshipTypeCV
fk_RelatedDatasets_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Provenance.RelatedDatasets	Name	RelationshipTypeCV
fk_RelatedDatasets_DataSets	ODM2Core.Datasets	ODM2Provenance.RelatedDatasets	DatasetID	DataSetID
fk_RelatedDatasets_DataSets_AreRelated	ODM2Core.Datasets	ODM2Provenance.RelatedDatasets	DatasetID	RelatedDatasetID
fk_RelatedResults_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Provenance.RelatedResults	Name	RelationshipTypeCV
fk_RelatedResults_Results	ODM2Core.Results	ODM2Provenance.RelatedResults	ResultID	ResultID
fk_RelatedResults_Results_AreRelated	ODM2Core.Results	ODM2Provenance.RelatedResults	ResultID	RelatedResultID
fk_ResultDerivationEquations_DerivationEquations	ODM2Provenance.DerivationEquations	ODM2Provenance.ResultDerivationEquations	DerivationEquationID	DerivationEquationID
fk_ResultDerivationEquations_Results	ODM2Core.Results	ODM2Provenance.ResultDerivationEquations	ResultID	ResultID
fk_CategoricalResults_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.CategoricalResults	Name	QualityCodeCV
fk_CategoricalResults_Results	ODM2Core.Results	ODM2Results.CategoricalResults	ResultID	ResultID
fk_CategoricalResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.CategoricalResults	SpatialReferenceID	SpatialReferenceID
fk_CategoricalResultValues_CategoricalResults	ODM2Results.CategoricalResults	ODM2Results.CategoricalResultValues	ResultID	ResultID
fk_MeasurementResults_AIUnits	ODM2Core.Units	ODM2Results.MeasurementResults	UnitsID	TimeAggregationIntervalUnitsID
fk_MeasurementResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.MeasurementResults	Name	AggregationStatisticCV
fk_MeasurementResults_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.MeasurementResults	Name	CensorCodeCV
fk_MeasurementResults_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.MeasurementResults	Name	QualityCodeCV
fk_MeasurementResults_Results	ODM2Core.Results	ODM2Results.MeasurementResults	ResultID	ResultID
fk_MeasurementResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.MeasurementResults	SpatialReferenceID	SpatialReferenceID
fk_MeasurementResults_XUnits	ODM2Core.Units	ODM2Results.MeasurementResults	UnitsID	XLocationUnitsID
fk_MeasurementResults_YUnits	ODM2Core.Units	ODM2Results.MeasurementResults	UnitsID	YLocationUnitsID
fk_MeasurementResults_ZUnits	ODM2Core.Units	ODM2Results.MeasurementResults	UnitsID	ZLocationUnitsID
fk_MeasurementResultValues_MeasurementResults	ODM2Results.MeasurementResults	ODM2Results.MeasurementResultValues	ResultID	ResultID
fk_PointCoverageResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.PointCoverageResults	Name	AggregationStatisticCV
fk_PointCoverageResults_Results	ODM2Core.Results	ODM2Results.PointCoverageResults	ResultID	ResultID
fk_PointCoverageResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.PointCoverageResults	SpatialReferenceID	SpatialReferenceID
fk_PointCoverageResults_XUnits	ODM2Core.Units	ODM2Results.PointCoverageResults	UnitsID	IntendedXSpacingUnitsID
fk_PointCoverageResults_YUnits	ODM2Core.Units	ODM2Results.PointCoverageResults	UnitsID	IntendedYSpacingUnitsID
fk_PointCoverageResults_ZUnits	ODM2Core.Units	ODM2Results.PointCoverageResults	UnitsID	ZLocationUnitsID
fk_PointCoverageResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.PointCoverageResultValues	Name	CensorCodeCV
fk_PointCoverageResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.PointCoverageResultValues	Name	QualityCodeCV
fk_PointCoverageResultValues_PointCoverageResults	ODM2Results.PointCoverageResults	ODM2Results.PointCoverageResultValues	ResultID	ResultID
fk_PointCoverageResultValues_XUnits	ODM2Core.Units	ODM2Results.PointCoverageResultValues	UnitsID	XLocationUnitsID
fk_PointCoverageResultValues_YUnits	ODM2Core.Units	ODM2Results.PointCoverageResultValues	UnitsID	YLocationUnitsID
fk_ProfileResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.ProfileResults	Name	AggregationStatisticCV
fk_ProfileResults_DUnits	ODM2Core.Units	ODM2Results.ProfileResults	UnitsID	IntendedZSpacingUnitsID
fk_ProfileResults_Results	ODM2Core.Results	ODM2Results.ProfileResults	ResultID	ResultID
fk_ProfileResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.ProfileResults	SpatialReferenceID	SpatialReferenceID
fk_ProfileResults_TUnits	ODM2Core.Units	ODM2Results.ProfileResults	UnitsID	IntendedTimeSpacingUnitsID
fk_ProfileResults_XUnits	ODM2Core.Units	ODM2Results.ProfileResults	UnitsID	XLocationUnitsID
fk_ProfileResults_YUnits	ODM2Core.Units	ODM2Results.ProfileResults	UnitsID	YLocationUnitsID
fk_ProfileResultValues_AIUnits	ODM2Core.Units	ODM2Results.ProfileResultValues	UnitsID	TimeAggregationIntervalUnitsID
fk_ProfileResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.ProfileResultValues	Name	CensorCodeCV
fk_ProfileResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.ProfileResultValues	Name	QualityCodeCV
fk_ProfileResultValues_DUnits	ODM2Core.Units	ODM2Results.ProfileResultValues	UnitsID	ZLocationUnitsID
fk_ProfileResultValues_ProfileResults	ODM2Results.ProfileResults	ODM2Results.ProfileResultValues	ResultID	ResultID
fk_SectionResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.SectionResults	Name	AggregationStatisticCV
fk_SectionResults_Results	ODM2Core.Results	ODM2Results.SectionResults	ResultID	ResultID
fk_SectionResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.SectionResults	SpatialReferenceID	SpatialReferenceID
fk_SectionResults_TMUnits	ODM2Core.Units	ODM2Results.SectionResults	UnitsID	IntendedTimeSpacingUnitsID
fk_SectionResults_Units	ODM2Core.Units	ODM2Results.SectionResults	UnitsID	YLocationUnitsID
fk_SectionResults_XUnits	ODM2Core.Units	ODM2Results.SectionResults	UnitsID	IntendedXSpacingUnitsID
fk_SectionResults_ZUnits	ODM2Core.Units	ODM2Results.SectionResults	UnitsID	IntendedZSpacingUnitsID
fk_SectionResultValues_AIUnits	ODM2Core.Units	ODM2Results.SectionResultValues	UnitsID	TimeAggregationIntervalUnitsID
fk_SectionResultValues_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.SectionResultValues	Name	AggregationStatisticCV
fk_SectionResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.SectionResultValues	Name	CensorCodeCV
fk_SectionResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.SectionResultValues	Name	QualityCodeCV
fk_SectionResultValues_SectionResults	ODM2Results.SectionResults	ODM2Results.SectionResultValues	ResultID	ResultID
fk_SectionResultValues_XUnits	ODM2Core.Units	ODM2Results.SectionResultValues	UnitsID	XLocationUnitsID
fk_SectionResultValues_ZUnits	ODM2Core.Units	ODM2Results.SectionResultValues	UnitsID	ZLocationUnitsID
fk_SpectraResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.SpectraResults	Name	AggregationStatisticCV
fk_SpectraResults_Results	ODM2Core.Results	ODM2Results.SpectraResults	ResultID	ResultID
fk_SpectraResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.SpectraResults	SpatialReferenceID	SpatialReferenceID
fk_SpectraResults_Units	ODM2Core.Units	ODM2Results.SpectraResults	UnitsID	IntendedWavelengthSpacingUnitsID
fk_SpectraResults_XUnits	ODM2Core.Units	ODM2Results.SpectraResults	UnitsID	XLocationUnitsID
fk_SpectraResults_YUnits	ODM2Core.Units	ODM2Results.SpectraResults	UnitsID	YLocationUnitsID
fk_SpectraResults_ZUnits	ODM2Core.Units	ODM2Results.SpectraResults	UnitsID	ZLocationUnitsID
fk_SpectraResultValues_AIUnits	ODM2Core.Units	ODM2Results.SpectraResultValues	UnitsID	TimeAggregationIntervalUnitsID
fk_SpectraResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.SpectraResultValues	Name	CensorCodeCV
fk_SpectraResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.SpectraResultValues	Name	QualityCodeCV
fk_SpectraResultValues_SpectraResults	ODM2Results.SpectraResults	ODM2Results.SpectraResultValues	ResultID	ResultID
fk_SpectraResultValues_WUnits	ODM2Core.Units	ODM2Results.SpectraResultValues	UnitsID	WavelengthUnitsID
fk_TimeSeriesResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.TimeSeriesResults	Name	AggregationStatisticCV
fk_TimeSeriesResults_Results	ODM2Core.Results	ODM2Results.TimeSeriesResults	ResultID	ResultID
fk_TimeSeriesResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.TimeSeriesResults	SpatialReferenceID	SpatialReferenceID
fk_TimeSeriesResults_TUnits	ODM2Core.Units	ODM2Results.TimeSeriesResults	UnitsID	IntendedTimeSpacingUnitsID
fk_TimeSeriesResults_XUnits	ODM2Core.Units	ODM2Results.TimeSeriesResults	UnitsID	XLocationUnitsID
fk_TimeSeriesResults_YUnits	ODM2Core.Units	ODM2Results.TimeSeriesResults	UnitsID	YLocationUnitsID
fk_TimeSeriesResults_ZUnits	ODM2Core.Units	ODM2Results.TimeSeriesResults	UnitsID	ZLocationUnitsID
fk_TimeSeriesResultValues_AIUnits	ODM2Core.Units	ODM2Results.TimeSeriesResultValues	UnitsID	TimeAggregationIntervalUnitsID
fk_TimeSeriesResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.TimeSeriesResultValues	Name	CensorCodeCV
fk_TimeSeriesResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TimeSeriesResultValues	Name	QualityCodeCV
fk_TimeSeriesResultValues_TimeSeriesResults	ODM2Results.TimeSeriesResults	ODM2Results.TimeSeriesResultValues	ResultID	ResultID
fk_TrajectoryResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.TrajectoryResults	Name	AggregationStatisticCV
fk_TrajectoryResults_Results	ODM2Core.Results	ODM2Results.TrajectoryResults	ResultID	ResultID
fk_TrajectoryResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.TrajectoryResults	SpatialReferenceID	SpatialReferenceID
fk_TrajectoryResults_TSUnits	ODM2Core.Units	ODM2Results.TrajectoryResults	UnitsID	IntendedTrajectorySpacingUnitsID
fk_TrajectoryResults_TUnits	ODM2Core.Units	ODM2Results.TrajectoryResults	UnitsID	IntendedTimeSpacingUnitsID
fk_TrajectoryResultValues_AIUnits	ODM2Core.Units	ODM2Results.TrajectoryResultValues	UnitsID	TimeAggregationIntervalUnitsID
fk_TrajectoryResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.TrajectoryResultValues	Name	CensorCodeCV
fk_TrajectoryResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TrajectoryResultValues	Name	QualityCodeCV
fk_TrajectoryResultValues_DistanceUnits	ODM2Core.Units	ODM2Results.TrajectoryResultValues	UnitsID	TrajectoryDistanceUnitsID
fk_TrajectoryResultValues_TrajectoryResults	ODM2Results.TrajectoryResults	ODM2Results.TrajectoryResultValues	ResultID	ResultID
fk_TrajectoryResultValues_XUnits	ODM2Core.Units	ODM2Results.TrajectoryResultValues	UnitsID	XLocationUnitsID
fk_TrajectoryResultValues_YUnits	ODM2Core.Units	ODM2Results.TrajectoryResultValues	UnitsID	YLocationUnitsID
fk_TrajectoryResultValues_ZUnits	ODM2Core.Units	ODM2Results.TrajectoryResultValues	UnitsID	ZLocationUnitsID
fk_TransectResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.TransectResults	Name	AggregationStatisticCV
fk_TransectResults_Results	ODM2Core.Results	ODM2Results.TransectResults	ResultID	ResultID
fk_TransectResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.TransectResults	SpatialReferenceID	SpatialReferenceID
fk_TransectResults_TMUnits	ODM2Core.Units	ODM2Results.TransectResults	UnitsID	IntendedTimeSpacingUnitsID
fk_TransectResults_TSUnits	ODM2Core.Units	ODM2Results.TransectResults	UnitsID	IntendedTransectSpacingUnitsID
fk_TransectResults_Units	ODM2Core.Units	ODM2Results.TransectResults	UnitsID	ZLocationUnitsID
fk_TransectResultValues_AIUnits	ODM2Core.Units	ODM2Results.TransectResultValues	UnitsID	TimeAggregationIntervalUnitsID
fk_TransectResultValues_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.TransectResultValues	Name	AggregationStatisticCV
fk_TransectResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.TransectResultValues	Name	CensorCodeCV
fk_TransectResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TransectResultValues	Name	QualityCodeCV
fk_TransectResultValues_DistanceUnits	ODM2Core.Units	ODM2Results.TransectResultValues	UnitsID	TransectDistanceUnitsID
fk_TransectResultValues_TransectResults	ODM2Results.TransectResults	ODM2Results.TransectResultValues	ResultID	ResultID
fk_TransectResultValues_XUnits	ODM2Core.Units	ODM2Results.TransectResultValues	UnitsID	XLocationUnitsID
fk_TransectResultValues_YUnits	ODM2Core.Units	ODM2Results.TransectResultValues	UnitsID	YLocationUnitsID
fk_FeatureParents_FeaturesParent	ODM2Core.SamplingFeatures	ODM2SamplingFeatures.RelatedFeatures	SamplingFeatureID	RelatedFeatureID
fk_FeatureParents_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2SamplingFeatures.RelatedFeatures	SamplingFeatureID	SamplingFeatureID
fk_FeatureParents_SpatialOffsets	ODM2SamplingFeatures.SpatialOffsets	ODM2SamplingFeatures.RelatedFeatures	SpatialOffsetID	SpatialOffsetID
fk_RelatedFeatures_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2SamplingFeatures.RelatedFeatures	Name	RelationshipTypeCV
fk_Sites_CV_SiteType	ODM2CV.CV_SiteType	ODM2SamplingFeatures.Sites	Name	SiteTypeCV
fk_Sites_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2SamplingFeatures.Sites	SamplingFeatureID	SamplingFeatureID
fk_Sites_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2SamplingFeatures.Sites	SpatialReferenceID	SpatialReferenceID
fk_SpatialOffsets_CV_SpatialOffsetType	ODM2CV.CV_SpatialOffsetType	ODM2SamplingFeatures.SpatialOffsets	Name	SpatialOffsetTypeCV
fk_SpatialOffsets_Offset1Units	ODM2Core.Units	ODM2SamplingFeatures.SpatialOffsets	UnitsID	Offset1UnitID
fk_SpatialOffsets_Offset2Units	ODM2Core.Units	ODM2SamplingFeatures.SpatialOffsets	UnitsID	Offset2UnitID
fk_SpatialOffsets_Offset3Units	ODM2Core.Units	ODM2SamplingFeatures.SpatialOffsets	UnitsID	Offset3UnitID
fk_Specimens_CV_Medium	ODM2CV.CV_Medium	ODM2SamplingFeatures.Specimens	Name	SpecimenMediumCV
fk_Specimens_CV_SpecimenType	ODM2CV.CV_SpecimenType	ODM2SamplingFeatures.Specimens	Name	SpecimenTypeCV
fk_Specimens_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2SamplingFeatures.Specimens	SamplingFeatureID	SamplingFeatureID
fk_SpecimenTaxonomicClassifiers_Citations	ODM2Provenance.Citations	ODM2SamplingFeatures.SpecimenTaxonomicClassifiers	CitationID	CitationID
fk_SpecimenTaxonomicClassifiers_Specimens	ODM2SamplingFeatures.Specimens	ODM2SamplingFeatures.SpecimenTaxonomicClassifiers	SamplingFeatureID	SamplingFeatureID
fk_SpecimenTaxonomicClassifiers_TaxonomicClassifiers	ODM2Core.TaxonomicClassifiers	ODM2SamplingFeatures.SpecimenTaxonomicClassifiers	TaxonomicClassifierID	TaxonomicClassifierID
fk_ModelAffiliations_Affiliations	ODM2Core.Affiliations	ODM2Simulation.ModelAffiliations	AffiliationID	AffiliationID
fk_ModelAffiliations_Models	ODM2Simulation.Models	ODM2Simulation.ModelAffiliations	ModelID	ModelID
fk_RelatedModels_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Simulation.RelatedModels	Name	RelationshipTypeCV
fk_RelatedModels_Models	ODM2Simulation.Models	ODM2Simulation.RelatedModels	ModelID	ModelID
fk_Simulations_Actions	ODM2Core.Actions	ODM2Simulation.Simulations	ActionID	ActionID
fk_Simulations_Models	ODM2Simulation.Models	ODM2Simulation.Simulations	ModelID	ModelID