ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

CV_Units

Table containing terms used in the VariableName controlled vocabulary.

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	UnitsID	Integer				Primary key identifier
	Term	VarChar(255)				Controlled vocabulary term
	UnitsName	VarChar(255)				The human readable version of the vocabulary term. May be the same as the term.t
	QuantityKindCV	VarChar(255)				Foreign key on Unitstype
	UnitsAbbreviation	VarChar(255)				Abbreviation of unit
	UnitsLink	VarChar(1000)				A link to the source vocabulary from which the term was derived.
	ConversionMultiplier	Float
	ConversionOffset	Float
	Definition	VarChar(5000)

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Units_CV_QuantityKind	ODM2CV.CV_QuantityKind	ODM2CV.CV_Units	Term	QuantityKindCV

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Results_Units	ODM2CV.CV_Units	ODM2Core.Results	UnitsID	UnitsID
fk_InstrumentOutputVariables_CV_Units	ODM2CV.CV_Units	ODM2Equipment.InstrumentOutputQuantityKind	UnitsID	InstrumentRawOutputUnitsID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2CV