ODM2 [ODM2_DBWrench_Schema.xml] |
Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
Variables | Stores information about measured properties. |
Columns | |||||||
PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
| VariableID | Integer |
| Primary key identifier | |||
VariableTypeCV | VarChar(255) | Controlled vocabulary for the type of variable |
|
||||
VariableCode | VarChar(50) | Unique text code for the variable | |||||
VariableNameCV | VarChar(255) | Controlled vocabulary for the name of the variable |
|
||||
VariableDefinition | VarChar(5000) |
| Text definition of the variable | ||||
SpeciationCV | VarChar(255) |
| Speciation for the variable (e.g., expressed as P or as PO4) |
|
|||
NoDataValue | Double | A numeric value indicating no data. |
Indexes (none) |
Foreign Keys | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_Variables_CV_Speciation | ODM2CV.CV_Speciation | ODM2Core.Variables | Name | SpeciationCV |
fk_Variables_CV_VariableName | ODM2CV.CV_VariableName | ODM2Core.Variables | Name | VariableNameCV |
fk_Variables_CV_VariableType | ODM2CV.CV_VariableType | ODM2Core.Variables | Name | VariableTypeCV |
Parent Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_Results_Variables | ODM2Core.Variables | ODM2Core.Results | VariableID | VariableID |
fk_ReferenceMaterialValues_Variables | ODM2Core.Variables | ODM2DataQuality.ReferenceMaterialValues | VariableID | VariableID |
fk_InstrumentOutputVariables_Variables | ODM2Core.Variables | ODM2Equipment.InstrumentOutputVariables | VariableID | VariableID |
fk_VariableExtensionPropertyValues_Variables | ODM2Core.Variables | ODM2ExtensionProperties.VariableExtensionPropertyValues | VariableID | VariableID |
fk_VariableExternalIdentifiers_Variables | ODM2Core.Variables | ODM2ExternalIdentifiers.VariableExternalIdentifiers | VariableID | VariableID |
Used in Diagrams |
Diagram Name |
ODM2Core |
ODM2Equipment |
ODM2ExtensionProperties |
ODM2ExternalIdentifers |
ODM2OverviewSimplified |
ODM2Simulation |