TD021

Properties of Attributes in entity 1 table: Field sample and mass loss data

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	integer	1.-1.	1.	number
SITE	Y	N	char(3)	place	nominal
TIMEOUT	Y	Y	numeric(5,2)	range	ratio	real	0.47-30.04	0.01	number of years
SPECIES	Y	N	char(4)	taxa	nominal
SIZE	Y	N	char(2)	enum	nominal
SOURCE	Y	N	char(2)	enum	nominal
POSITION	Y	N	char(2)	enum	nominal
REP	Y	N	char(1)	enum	nominal
SAMPLE_NO	Y	N	numeric(1,0)	range	ratio	integer	1.-2.	1.	number
NIR_NUM	Y	N	numeric(5,0)	range	ratio	integer	20.-70500.	1.	number
DATEOUT	N	N	datetime	range	datetime		Oct 15 1985-Sep 24 1998		date as date type
DIAM	N	Y	numeric(5,1)	range	ratio	real	1.8-183.0	1.0	centimeters
ILENGTH	N	N	numeric(5,1)	range	ratio	real	7.7-100.0	1.0	centimeters
IWW	N	Y	numeric(7,2)	range	ratio	real	0.00-7584.00	0.01	grams
MCF	N	Y	numeric(5,3)	range	ratio	real	0.000-2.000	0.001	number
IODW	N	Y	numeric(7,2)	range	ratio	real	0.00-5000.00	0.01	grams
IDENS	N	Y	numeric(7,3)	range	ratio	real	0.000-2.500	0.001	grams per cubic centimeter
DATEIN	N	Y	datetime	range	datetime		Sep 15 1986-Oct 29 2015		date as date type
FWW	N	Y	numeric(7,2)	range	ratio	real	0.00-6550.00	0.01	grams
FOW	N	Y	numeric(7,2)	range	ratio	real	0.00-3625.00	0.01	grams
PRM	N	Y	numeric(7,3)	range	ratio	real	0.000-170.000	0.001	percent
IDENTITY_NR	N	N	numeric(5,0)	range	ratio	integer	1.-70490.	1.	number
LOCATION	N	N	char(20)	freetext	nominal
STAND_COND	N	Y	char(1)	enum	nominal
COMMENT	N	Y	char(5)	enum	nominal
OSU_NO	N	Y	numeric(4,0)	range	ratio	integer	901.-4352.	1.	number
OUTLIER	N	Y	char(1)	enum	nominal