ODM2 [ODM2_DBWrench_Schema.xml] |
Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
TrajectoryResultValues | (Table) |
Columns | |||||||
PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
| ValueID | BigInt |
| ||||
ResultID | BigInt |
|
|||||
DataValue | Float | ||||||
ValueDateTime | DateTime | ||||||
ValueDateTimeUTCOffset | Integer | ||||||
XLocation | Float | ||||||
XLocationUnitsID | Integer |
|
|||||
YLocation | Float | ||||||
YLocationUnitsID | Integer |
|
|||||
ZLocation | Float | ||||||
ZLocationUnitsID | Integer |
|
|||||
TrajectoryDistance | Float | ||||||
TrajectoryDistanceAggregationInterval | Float | ||||||
TrajectoryDistanceUnitsID | Integer |
|
|||||
CensorCodeCV | VarChar(255) |
|
|||||
QualityCodeCV | VarChar(255) |
|
|||||
TimeAggregationInterval | Float | ||||||
TimeAggregationIntervalUnitsID | Integer |
|
Indexes (none) |
Foreign Keys | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_TrajectoryResultValues_AIUnits | ODM2Core.Units | ODM2Results.TrajectoryResultValues | UnitsID | TimeAggregationIntervalUnitsID |
fk_TrajectoryResultValues_CV_CensorCode | ODM2CV.CV_CensorCode | ODM2Results.TrajectoryResultValues | Name | CensorCodeCV |
fk_TrajectoryResultValues_CV_QualityCode | ODM2CV.CV_QualityCode | ODM2Results.TrajectoryResultValues | Name | QualityCodeCV |
fk_TrajectoryResultValues_DistanceUnits | ODM2Core.Units | ODM2Results.TrajectoryResultValues | UnitsID | TrajectoryDistanceUnitsID |
fk_TrajectoryResultValues_TrajectoryResults | ODM2Results.TrajectoryResults | ODM2Results.TrajectoryResultValues | ResultID | ResultID |
fk_TrajectoryResultValues_XUnits | ODM2Core.Units | ODM2Results.TrajectoryResultValues | UnitsID | XLocationUnitsID |
fk_TrajectoryResultValues_YUnits | ODM2Core.Units | ODM2Results.TrajectoryResultValues | UnitsID | YLocationUnitsID |
fk_TrajectoryResultValues_ZUnits | ODM2Core.Units | ODM2Results.TrajectoryResultValues | UnitsID | ZLocationUnitsID |
Parent Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_TrajectoryResultValueAnnotations_TrajectoryResultValues | ODM2Results.TrajectoryResultValues | ODM2Annotations.TrajectoryResultValueAnnotations | ValueID | ValueID |
Used in Diagrams |
Diagram Name |
ODM2Annotations |
ODM2Results |