ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

CV_QualityCode

Table containing terms used in the QualityCode 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_CategoricalResults_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.CategoricalResults	Term	QualityCodeCV
fk_MeasurementResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.MeasurementResultValues	Term	QualityCodeCV
fk_PointCoverageResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.PointCoverageResultValues	Term	QualityCodeCV
fk_ProfileResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.ProfileResultValues	Term	QualityCodeCV
fk_SectionResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.SectionResultValues	Term	QualityCodeCV
fk_SpectraResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.SpectraResultValues	Term	QualityCodeCV
fk_TimeSeriesResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TimeSeriesResultValues	Term	QualityCodeCV
fk_TrajectoryResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TrajectoryResultValues	Term	QualityCodeCV
fk_TransectResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TransectResultValues	Term	QualityCodeCV

Triggers (none)

Used in Diagrams

Diagram Name

ODM2CV