ODM2 [ODM2_DBWrench_Schema.xml] |
Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
DataQuality | (Table) |
Columns | |||||||
PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
| DataQualityID | Integer | Primary Key for DataQuality entity | ||||
DataQualityTypeCV | VarChar(255) | i.e. Precision_2sigma, MethodDetectionLimit, ReportingLevel, 95%ConfidenceNoFalsePositives. |
|
||||
DataQualityCode | VarChar(255) | Code for DataQualityType | |||||
DataQualityValue | Float |
| Numeric value of the DataQuality | ||||
DataQualityValueUnitsID | Integer |
| Units for the DataQualityValue |
|
|||
DataQualityDescription | VarChar(5000) |
| Text description of the DataQuality metadata | ||||
DataQualityLink | VarChar(255) |
| URL or path to a file or other resource supporting the DataQuality metadata |
Indexes (none) |
Foreign Keys | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_DataQuality_CV_DataQualityType | ODM2CV.CV_DataQualityType | ODM2DataQuality.DataQuality | Name | DataQualityTypeCV |
fk_DataQuality_Units | ODM2Core.Units | ODM2DataQuality.DataQuality | UnitsID | DataQualityValueUnitsID |
Parent Relations | ||||
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_ResultsDataQuality_DataQuality | ODM2DataQuality.DataQuality | ODM2DataQuality.ResultsDataQuality | DataQualityID | DataQualityID |
Used in Diagrams |
Diagram Name |
ODM2DataQuality |