TD017

Properties of Attributes in entity 3 table: Sample Dimensions, Weights, Density, and Moisture Contents

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	freetext	nominal
ENTITY	N	N	numeric(1,0)	range	interval	natural	3.-3.	1.	number
STUDYID	N	N	char(3)	place	nominal
YEAR	Y	N	numeric(4,0)	range	interval	integer	1985.-2015.	1.	number
NUMBER	Y	N	numeric(3,0)	range	ratio	integer	0.-280.	1.	number
POS	Y	N	char(1)	enum	nominal
SUBSTR	Y	N	char(2)	enum	nominal
VOLFORM	N	N	char(1)	enum	nominal
D1	N	N	numeric(5,1)	range	ratio	real	1.0-810.0	1.0	millimeters
D2	N	N	numeric(5,1)	range	ratio	real	1.0-435.0	1.0	millimeters
D3	N	Y	numeric(5,1)	range	ratio	real	0.4-417.0	1.0	millimeters
D4	N	Y	numeric(3,0)	range	ratio	real	43.-161.	1.	millimeters
WETWTD	N	Y	numeric(6,0)	range	ratio	real	37.-226450.	0.	grams
DRYWTD	N	Y	numeric(6,0)	range	ratio	real	4.-121229.	0.	grams
WETWTM	N	Y	numeric(5,0)	range	ratio	real	504.-26300.		grams
DRYWTM	N	Y	numeric(5,0)	range	ratio	real	288.-9890.		grams
WVOL	N	Y	numeric(3,0)	range	ratio	real	20.-600.	1.	milliliters
CVOL	N	Y	numeric(6,0)	range	ratio	real	480.-925037.	1.	number
DEN	N	Y	numeric(5,0)	range	ratio	real	1.-1462.	1.	milliliters
MC	N	Y	numeric(3,0)	range	ratio	real	11.-825.	1.	percent
SAMPLEDATE	N	N	datetime	range	datetime		Jun 19 1985-Jun 16 2015		date as date type