ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

Methods

Describes methods used to perform actions recorded in ODM (e.g., obser...

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	MethodID	Integer				Primary key identifier
	MethodTypeCV	VarChar(255)				CV term describing the type of method (e.g., sample collection, laboratory analytical, field, sample prepratation, etc.)
	MethodCode	VarChar(50)				A text code identifiying the method (e.g., EPA 650.2)
	MethodName	VarChar(255)				Full text name of the method
	MethodDescription	VarChar(5000)				Full text description of the method
	MethodLink	VarChar(255)				A URL to a full description of the method
	OrganizationID	Integer				Foreign key identifier for the Organization with which the method is affiliated

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Methods_CV_MethodType	ODM2CV.CV_MethodType	ODM2Core.Methods	Name	MethodTypeCV
fk_Methods_Organizations	ODM2Core.Organizations	ODM2Core.Methods	OrganizationID	OrganizationID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_MethodAnnotations_Methods	ODM2Core.Methods	ODM2Annotations.MethodAnnotations	MethodID	MethodID
fk_Actions_Methods	ODM2Core.Methods	ODM2Core.Actions	MethodID	MethodID
fk_InstrumentOutputVariables_Methods	ODM2Core.Methods	ODM2Equipment.InstrumentOutputVariables	MethodID	InstrumentMethodID
fk_MethodExtensionPropertyValues_Methods	ODM2Core.Methods	ODM2ExtensionProperties.MethodExtensionPropertyValues	MethodID	MethodID
fk_MethodExternalIdentifiers_Methods	ODM2Core.Methods	ODM2ExternalIdentifiers.MethodExternalIdentifiers	MethodID	MethodID
fk_MethodCitations_Methods	ODM2Core.Methods	ODM2Provenance.MethodCitations	MethodID	MethodID

Used in Diagrams

Diagram Name

ODM2Annotations

ODM2Core

ODM2Equipment

ODM2ExtensionProperties

ODM2ExternalIdentifers

ODM2LabAnalyses

ODM2OverviewSimplified

ODM2Provenance

ODM2Simulation