| ODM2 [ODM2_DBWrench_Schema.xml] |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| CV_QuantityKind | Table containing terms used in the QuantityKind 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. | ||||
| Provenance | VarChar(255) |
| The organization or source which defines this term | ||||
| ProvenanceURI | VarChar(1000) |
| A link to the source vocabulary from which the term was derived or which provides further information | ||||
| Note | VarChar(1000) |
| An optional note about this quantitykind unit | ||||
| DefaultUnit | VarChar(255) |
| The default unit | ||||
| DefaultUnitAbbreviation | VarChar(255) |
| Abbreviation for the default unit | ||||
| DimensionSymbol | VarChar(255) |
| The dimension symbol. This should align with the other units (dimension_length and so on) | ||||
| DimensionUnitless | Integer | an integer (between -10 and 10, indicating the unitless dimensionality) | |||||
| DimensionLength | Integer | an integer (between -10 and 10, indicating the length dimensionality) | |||||
| DimensionMass | Integer | an integer (between -10 and 10, indicating the mass dimensionality) | |||||
| DimensionTime | Integer | an integer (between -10 and 10, indicating the time dimensionality) | |||||
| DimensionCurrent | Integer | an integer (between -10 and 10, indicating the current dimensionality) | |||||
| DimensionTemperature | Integer | an integer (between -10 and 10, indicating the temperature dimensionality) | |||||
| DimensionAmount | Integer | an integer (between -10 and 10, indicating the amount dimensionality) | |||||
| DimensionLight | Integer | an integer (between -10 and 10, indicating the light dimensionality) | |||||
| Indexes (none) |
| Foreign Keys (none) |
| Parent Relations | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Variables_CV_QuantityKind | ODM2CV.CV_QuantityKind | ODM2Core.Variables | Term | QuantityKindCV |
| fk_Units_CV_QuantityKind | ODM2CV.CV_QuantityKind | ODM2CV.CV_Units | Term | QuantityKindCV |
| fk_InstrumentOutputVariables_CV_QuantityKind | ODM2CV.CV_QuantityKind | ODM2Equipment.InstrumentOutputQuantityKind | Term | QuantityKind |
| Triggers (none) |
| Used in Diagrams |
| Diagram Name |
| ODM2CV |