TP109

Properties of Attributes in entity 1 table: DEMO Mushroom collections

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DATACODE	N	N	char(5)	enum	nominal
FORMAT	N	N	numeric(1,0)	range	ratio	integer	1.-1.	1.	number
BLOCK	N	N	char(1)	enum	nominal
TRT	N	Y	char(1)	enum	nominal
YEAR	N	N	numeric(4,0)	range	ratio	integer	1993.-1998.	1.	year (yyyy)
MONTH	N	Y	numeric(2,0)	range	ratio	integer	5.-11.	1.	month of year
DAY	N	Y	numeric(2,0)	range	ratio	integer	1.-31.	1.	day of month
SEASON	N	Y	char(1)	enum	nominal
TRANS	N	Y	char(3)	freetext	nominal
MMETER	N	Y	numeric(3,0)	range	ratio	integer	1.-54.	1.	meters
SRL	N	Y	char(1)	enum	nominal
PLOT	N	Y	numeric(3,0)	range	ratio	integer	1.-172.	1.	number
COLLNO	N	Y	numeric(6,0)	range	ratio	integer	3278.-13488.	1.	number
MUSHSPEC	N	Y	char(7)	enum	nominal
WEIGHT	N	Y	numeric(6,2)	range	ratio	real	0.01-243.80	0.01	grams
DUG	N	Y	char(1)	enum	nominal
LOCATION	N	Y	char(1)	enum	nominal
GENUS	N	Y	char(12)	enum	nominal