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	Term	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	Term	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	Term	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_RelatedFeatures	ODM2SamplingFeatures.RelatedFeatures	ODM2Core.FeatureActions	RelationID	RelatedFeaturesRelationID
fk_FeatureActions_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2Core.FeatureActions	SamplingFeatureID	SamplingFeatureID
fk_Methods_CV_MethodType	ODM2CV.CV_MethodType	ODM2Core.Methods	Term	MethodTypeCV
fk_Methods_Organizations	ODM2Core.Organizations	ODM2Core.Methods	OrganizationID	OrganizationID
fk_Organizations_CV_OrganizationType	ODM2CV.CV_OrganizationType	ODM2Core.Organizations	Term	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	Term	RelationshipTypeCV
fk_Results_CV_ResultType	ODM2CV.CV_ResultType	ODM2Core.Results	Term	ResultTypeCV
fk_Results_CV_Status	ODM2CV.CV_Status	ODM2Core.Results	Term	StatusCV
fk_Results_FeatureActions	ODM2Core.FeatureActions	ODM2Core.Results	FeatureActionID	FeatureActionID
fk_Results_ProcessingLevels	ODM2Core.ProcessingLevels	ODM2Core.Results	ProcessingLevelID	ProcessingLevelID
fk_Results_Units	ODM2CV.CV_Units	ODM2Core.Results	UnitsID	UnitsID
fk_Results_Variables	ODM2Core.Variables	ODM2Core.Results	VariableID	VariableID
fk_SamplingFeatures_CV_ElevationDatum	ODM2CV.CV_ElevationDatum	ODM2Core.SamplingFeatures	Term	ElevationDatumCV
fk_SamplingFeatures_CV_SamplingFeatureGeoType	ODM2CV.CV_SamplingFeatureGeoType	ODM2Core.SamplingFeatures	Term	SamplingFeatureGeotypeCV
fk_SamplingFeatures_CV_SamplingFeatureType	ODM2CV.CV_SamplingFeatureType	ODM2Core.SamplingFeatures	Term	SamplingFeatureTypeCV
fk_TaxonomicClassifiers_CV_TaxonomicClassifierDomain	ODM2CV.CV_TaxonomicClassifierDomain	ODM2Core.TaxonomicClassifiers	Term	TaxonomicClassifierDomainCV
fk_Variables_CV_Medium	ODM2CV.CV_Medium	ODM2Core.Variables	Term	SampledMediumCV
fk_Variables_CV_QuantityKind	ODM2CV.CV_QuantityKind	ODM2Core.Variables	Term	QuantityKindCV
fk_Variables_CV_VariableDomain	ODM2CV.CV_VariableDomain	ODM2Core.Variables	Term	VariableDomainCV
fk_Variables_speciationid_TaxonomicClassifiers	ODM2Core.TaxonomicClassifiers	ODM2Core.Variables	TaxonomicClassifierID	SpeciationID
fk_Variables_TaxonomicClassifiers	ODM2Core.TaxonomicClassifiers	ODM2Core.Variables	TaxonomicClassifierID	TaxonomicClassifierID
fk_Units_CV_QuantityKind	ODM2CV.CV_QuantityKind	ODM2CV.CV_Units	Term	QuantityKindCV
fk_DataQuality_CV_DataQualityType	ODM2CV.CV_DataQualityType	ODM2DataQuality.DataQuality	Term	DataQualityTypeCV
fk_ReferenceMaterials_CV_Medium	ODM2CV.CV_Medium	ODM2DataQuality.ReferenceMaterials	Term	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_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.InstrumentOutputQuantityKind	ODM2Equipment.CalibrationActions	InstrumentOutputQuantityKindID	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	Term	AggregationStatisticCV
fk_DataloggerFileColumns_DataLoggerFiles	ODM2Equipment.DataLoggerFiles	ODM2Equipment.DataloggerFileColumns	DataLoggerFileID	DataLoggerFileID
fk_DataloggerFileColumns_InstrumentOutputQuantityKind	ODM2Equipment.InstrumentOutputQuantityKind	ODM2Equipment.DataloggerFileColumns	InstrumentOutputQuantityKindID	InstrumentOutputQuantityKindID
fk_DataloggerFileColumns_Results	ODM2Core.Results	ODM2Equipment.DataloggerFileColumns	ResultID	ResultID
fk_DataLoggerFiles_DataloggerProgramFiles	ODM2Equipment.DataloggerProgramFiles	ODM2Equipment.DataLoggerFiles	ProgramID	ProgramID
fk_DataloggerProgramFiles_Affiliations	ODM2Core.Affiliations	ODM2Equipment.DataloggerProgramFiles	AffiliationID	AffiliationID
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_CV_EquipmentType	ODM2CV.CV_EquipmentType	ODM2Equipment.EquipmentModels	Term	EquipmentTypeCV
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_InstrumentOutputQuantityKind_Methods	ODM2Core.Methods	ODM2Equipment.InstrumentOutputQuantityKind	MethodID	InstrumentMethodID
fk_InstrumentOutputQuantityKind_Variables	ODM2Core.Variables	ODM2Equipment.InstrumentOutputQuantityKind	VariableID	InstrumentStandardOutputVariable
fk_InstrumentOutputVariables_CV_QuantityKind	ODM2CV.CV_QuantityKind	ODM2Equipment.InstrumentOutputQuantityKind	Term	QuantityKind
fk_InstrumentOutputVariables_CV_Units	ODM2CV.CV_Units	ODM2Equipment.InstrumentOutputQuantityKind	UnitsID	InstrumentRawOutputUnitsID
fk_InstrumentOutputVariables_EquipmentModels	ODM2Equipment.EquipmentModels	ODM2Equipment.InstrumentOutputQuantityKind	EquipmentModelID	EquipmentModelID
fk_MaintenanceActions_Actions	ODM2Core.Actions	ODM2Equipment.MaintenanceActions	ActionID	ActionID
fk_RelatedEquipment_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Equipment.RelatedEquipment	Term	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	Term	PropertyDataTypeCV
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	Term	DirectiveTypeCV
fk_SpecimenBatchPostions_FeatureActions	ODM2Core.FeatureActions	ODM2LabAnalyses.SpecimenBatchPositions	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	Term	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	Term	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	Term	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	Term	RelationshipTypeCV
fk_RelatedDatasets_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2Provenance.RelatedDatasets	Term	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	Term	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	Term	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_Results	ODM2Core.Results	ODM2Results.MeasurementResults	ResultID	ResultID
fk_MeasurementResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.MeasurementResults	SpatialReferenceID	SpatialReferenceID
fk_MeasurementResultValues_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.MeasurementResultValues	Term	AggregationStatisticCV
fk_MeasurementResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.MeasurementResultValues	Term	CensorCodeCV
fk_MeasurementResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.MeasurementResultValues	Term	QualityCodeCV
fk_MeasurementResultValues_MeasurementResults	ODM2Results.MeasurementResults	ODM2Results.MeasurementResultValues	ResultID	ResultID
fk_PointCoverageResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.PointCoverageResults	Term	AggregationStatisticCV
fk_PointCoverageResults_Results	ODM2Core.Results	ODM2Results.PointCoverageResults	ResultID	ResultID
fk_PointCoverageResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.PointCoverageResults	SpatialReferenceID	SpatialReferenceID
fk_PointCoverageResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.PointCoverageResultValues	Term	CensorCodeCV
fk_PointCoverageResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.PointCoverageResultValues	Term	QualityCodeCV
fk_PointCoverageResultValues_PointCoverageResults	ODM2Results.PointCoverageResults	ODM2Results.PointCoverageResultValues	ResultID	ResultID
fk_ProfileResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.ProfileResults	Term	AggregationStatisticCV
fk_ProfileResults_Results	ODM2Core.Results	ODM2Results.ProfileResults	ResultID	ResultID
fk_ProfileResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.ProfileResults	SpatialReferenceID	SpatialReferenceID
fk_ProfileResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.ProfileResultValues	Term	CensorCodeCV
fk_ProfileResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.ProfileResultValues	Term	QualityCodeCV
fk_ProfileResultValues_ProfileResults	ODM2Results.ProfileResults	ODM2Results.ProfileResultValues	ResultID	ResultID
fk_SectionResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.SectionResults	Term	AggregationStatisticCV
fk_SectionResults_Results	ODM2Core.Results	ODM2Results.SectionResults	ResultID	ResultID
fk_SectionResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.SectionResults	SpatialReferenceID	SpatialReferenceID
fk_SectionResultValues_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.SectionResultValues	Term	AggregationStatisticCV
fk_SectionResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.SectionResultValues	Term	CensorCodeCV
fk_SectionResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.SectionResultValues	Term	QualityCodeCV
fk_SectionResultValues_SectionResults	ODM2Results.SectionResults	ODM2Results.SectionResultValues	ResultID	ResultID
fk_SpectraResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.SpectraResults	Term	AggregationStatisticCV
fk_SpectraResults_Results	ODM2Core.Results	ODM2Results.SpectraResults	ResultID	ResultID
fk_SpectraResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.SpectraResults	SpatialReferenceID	SpatialReferenceID
fk_SpectraResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.SpectraResultValues	Term	CensorCodeCV
fk_SpectraResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.SpectraResultValues	Term	QualityCodeCV
fk_SpectraResultValues_SpectraResults	ODM2Results.SpectraResults	ODM2Results.SpectraResultValues	ResultID	ResultID
fk_TimeSeriesResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.TimeSeriesResults	Term	AggregationStatisticCV
fk_TimeSeriesResults_Results	ODM2Core.Results	ODM2Results.TimeSeriesResults	ResultID	ResultID
fk_TimeSeriesResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.TimeSeriesResults	SpatialReferenceID	SpatialReferenceID
fk_TimeSeriesResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.TimeSeriesResultValues	Term	CensorCodeCV
fk_TimeSeriesResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TimeSeriesResultValues	Term	QualityCodeCV
fk_TimeSeriesResultValues_TimeSeriesResults	ODM2Results.TimeSeriesResults	ODM2Results.TimeSeriesResultValues	ResultID	ResultID
fk_TrajectoryResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.TrajectoryResults	Term	AggregationStatisticCV
fk_TrajectoryResults_Results	ODM2Core.Results	ODM2Results.TrajectoryResults	ResultID	ResultID
fk_TrajectoryResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.TrajectoryResults	SpatialReferenceID	SpatialReferenceID
fk_TrajectoryResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.TrajectoryResultValues	Term	CensorCodeCV
fk_TrajectoryResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TrajectoryResultValues	Term	QualityCodeCV
fk_TrajectoryResultValues_TrajectoryResults	ODM2Results.TrajectoryResults	ODM2Results.TrajectoryResultValues	ResultID	ResultID
fk_TransectResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.TransectResults	Term	AggregationStatisticCV
fk_TransectResults_Results	ODM2Core.Results	ODM2Results.TransectResults	ResultID	ResultID
fk_TransectResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.TransectResults	SpatialReferenceID	SpatialReferenceID
fk_TransectResultValues_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.TransectResultValues	Term	AggregationStatisticCV
fk_TransectResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.TransectResultValues	Term	CensorCodeCV
fk_TransectResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TransectResultValues	Term	QualityCodeCV
fk_TransectResultValues_TransectResults	ODM2Results.TransectResults	ODM2Results.TransectResultValues	ResultID	ResultID
fk_featuresofinterest_cv_featureofinteresttype	ODM2CV.CV_FeaturesOfInterestType	ODM2SamplingFeatures.FeaturesOfInterest	Term	FeaturesOfInterestTypeCV
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	Term	RelationshipTypeCV
fk_SampledFeatures_CV_RelationshipType	ODM2CV.CV_RelationshipType	ODM2SamplingFeatures.SampledFeatures	Term	RelationshipTypeCV
fk_SampledFeatures_FeatureOfInterest	ODM2SamplingFeatures.FeaturesOfInterest	ODM2SamplingFeatures.SampledFeatures	FeaturesOfInterestID	FeatureOfInterestID
fk_SampledFeatures_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2SamplingFeatures.SampledFeatures	SamplingFeatureID	SamplingFeatureID
fk_SpatialOffsets_CV_SpatialOffsetType	ODM2CV.CV_SpatialOffsetType	ODM2SamplingFeatures.SpatialOffsets	Term	SpatialOffsetTypeCV
fk_SpecimenCollection_SpecimenCollection	ODM2SamplingFeatures.SpecimenCollection	ODM2SamplingFeatures.SpecimenCollection	SpecimenCollectionID	ParentSpecimenCollectionID
fk_Specimens_CV_Medium	ODM2CV.CV_Medium	ODM2SamplingFeatures.Specimens	Term	SpecimenMediumCV
fk_Specimens_CV_SpecimenType	ODM2CV.CV_SpecimenType	ODM2SamplingFeatures.Specimens	Term	SpecimenTypeCV
fk_Specimens_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2SamplingFeatures.Specimens	SamplingFeatureID	SamplingFeatureID
fk_Specimens_SpecimenCollection	ODM2SamplingFeatures.SpecimenCollection	ODM2SamplingFeatures.Specimens	SpecimenCollectionID	SpecimenCollectionID
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	Term	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