ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

CV_Medium

Table containing terms used in the Medium controlled vocabulary.

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	Term	VarChar(255)				Controlled vocabulary term
	Name	VarChar(255)				The human readable version of the vocabulary term. May be the same as the term.
	Definition	VarChar(5000)				Definition of vocabulary term.
	Category	VarChar(255)				A category within which the term falls.
	SourceVocabularyURI	VarChar(255)				A link to the source vocabulary from which the term was derived.

Indexes (none)

Foreign Keys (none)

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Results_CV_Medium	ODM2CV.CV_Medium	ODM2Core.Results	Name	SampledMediumCV
fk_ReferenceMaterials_CV_Medium	ODM2CV.CV_Medium	ODM2DataQuality.ReferenceMaterials	Name	ReferenceMaterialMediumCV
fk_Specimens_CV_Medium	ODM2CV.CV_Medium	ODM2SamplingFeatures.Specimens	Name	SpecimenMediumCV

Triggers (none)

Used in Diagrams

Diagram Name

ODM2CV