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