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	Name	QualityCodeCV
fk_MeasurementResults_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.MeasurementResults	Name	QualityCodeCV
fk_PointCoverageResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.PointCoverageResultValues	Name	QualityCodeCV
fk_ProfileResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.ProfileResultValues	Name	QualityCodeCV
fk_SectionResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.SectionResultValues	Name	QualityCodeCV
fk_SpectraResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.SpectraResultValues	Name	QualityCodeCV
fk_TimeSeriesResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TimeSeriesResultValues	Name	QualityCodeCV
fk_TrajectoryResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TrajectoryResultValues	Name	QualityCodeCV
fk_TransectResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TransectResultValues	Name	QualityCodeCV

Triggers (none)

Used in Diagrams

Diagram Name

ODM2CV