CV_Units - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: CV_Units

A unit refers to the dimension of data values of a quantitative attribute, help users unambiguously interpret the meaning of data values. Qualitative attributes like a “dam owner name” have no unit. The Units table applies to the Attributes table in WaM-DaM Core and enforces the same unit for all attributes across the instances of an Object to meet the consistency of units in particular Data Structure as used in modeling.

Columns

PKNameData TypeNULLAutoDefaultCommentFK

NameVarChar(255) Primary key identifier
TermVarChar(255) Text name for the unit
DefinitionVarChar(5000)

Text notes describing the unit
CategoryVarChar(255) a text that defines the unit type e.g., length or volume/time
UnitSystemVarChar(255)

International System of Units (SI) or Imperial units (English)
UnitAbbreviationChar(50) Text abbreviation for the unit
SourceVocabularyURIVarChar(5000)

A link to a description of or a formal specification of the spatial reference system.
LinearFactorFloat

See HydraPlatform http://umwrg.github.io/HydraPlatform/devdocs/techdocs/units_and_dimensions.html?highlight=unit
ConstantFactorFloat

See HydraPlatform http://umwrg.github.io/HydraPlatform/devdocs/techdocs/units_and_dimensions.html?highlight=unit

Indexes

(none)


Foreign Keys

(none)


Triggers

(none)


Used in Diagrams

Diagram Name
02_WaMDaM_WCVs
03_CVs