WE008

Properties of Attributes in entity 1 table: Small vertebrate captures

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DATACODE	N	N	char(5)	enum	nominal
FORMAT	N	N	numeric(2,0)	range	interval	natural	1.-1.	1.	number
SAMPLEDATE	N	Y	datetime	range	datetime		Oct 16 1991 12:00AM-Nov 21 2008 12:00AM		date as datetime type
YEAR	N	N	numeric(4,0)	range	interval	natural	1991.-2008.	1.	number
JULIAN	N	N	numeric(3,0)	range	ratio	natural	264.-326.	1.	number
TAC	N	N	char(2)	enum	nominal
BLOCK	N	N	char(1)	enum	nominal
TREATMENT	N	N	char(1)	enum	nominal
TRANSECT	N	Y	numeric(2,0)	range	interval	whole	1.-11.	1.	number
STATION	N	Y	numeric(2,0)	range	interval	natural	1.-37.	1.	number
TRST	N	Y	char(3)	freetext	nominal
TRAPTYPE	N	N	char(2)	enum	nominal
TCHECK	N	Y	char(2)	enum	nominal
SPECIES	N	N	char(4)	taxa	nominal
CAPSTAT	N	Y	char(2)	enum	nominal
TAG1	N	Y	numeric(4,0)	range	interval	whole	1.-8000.	1.	number
EAR1	N	Y	char(2)	enum	nominal
TAG2	N	Y	numeric(4,0)	range	interval	whole	1.-7000.	1.	number
EAR2	N	Y	char(2)	enum	nominal
TOENUM1	N	Y	numeric(4,0)	range	ratio	whole	1.-99.	1.	number
TOENUM2	N	Y	numeric(4,0)	range	ratio	whole	1.-927.	1.	number
BODYL	N	Y	numeric(5,1)	range	ratio	real	1.0-30.0	0.1	centimeters
TAILL	N	Y	numeric(5,1)	range	ratio	real	1.0-20.0	0.1	centimeters
WEIGHT	N	Y	numeric(5,1)	range	ratio	real	0.7-900.0	0.1	grams
SEX	N	Y	char(2)	enum	nominal
REPROSTAT	N	Y	char(3)	enum	nominal
LIVE	N	Y	char(1)	enum	nominal
DEADNUM	N	Y	numeric(4,0)	range	ratio	whole	1.-1616.		number
NOTES	N	Y	varchar(45)	freetext	nominal