TD014

Properties of Attributes in entity 10 table: Insect Galleries

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	interval	natural	10.-10.	1.	number
SITECODE	N	Y	char(10)	place	nominal
LOGNUM	Y	N	numeric(3,0)	range	interval	natural	11.-523.	1.	number
LOG_SPECIES	N	N	char(4)	taxa	nominal
TIME	Y	N	numeric(3,0)	range	ratio	whole	1.-4.	1.	number of years
YEAR	N	N	numeric(4,0)	range	interval	integer	1986.-1989.	1.	year (yyyy)
TREATMNT	Y	Y	char(1)	enum	nominal
SEGMENT	Y	Y	char(2)	freetext	nominal
POSITION	Y	N	char(1)	enum	nominal
ABG	N	N	numeric(4,0)	range	ratio	whole	0.-49.	1.	number
ABA	N	N	numeric(7,3)	range	ratio	real	0.063-0.063	0.001	square meters
BBG	N	N	numeric(4,0)	range	ratio	whole	0.-21.	1.	number
BBA	N	N	numeric(7,3)	range	ratio	real	0.000-5.696	0.001	square meters
WBG	N	N	numeric(4,0)	range	ratio	whole	0.-22.	1.	number
WBA	N	N	numeric(7,3)	range	ratio	real	0.000-5.696	0.001	square meters
SAMPLEDATE	N	N	datetime	range	datetime		Sep 9 1986-Oct 5 1989		date as date type