AS006

Properties of Attributes in entity 1 table: Vertebrate numbers and size

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(1,0)	range	ratio	natural	1.-1.		number
YEAR	Y	N	numeric(4,0)	range	interval	whole	1987.-2022.		number
SITECODE	Y	N	char(8)	place	nominal
SECTION	Y	N	char(2)	enum	nominal
REACH	Y	N	char(1)	enum	nominal
PASS	Y	N	numeric(1,0)	range	interval	natural	1.-2.		number
UNITNUM	Y	N	numeric(4,1)	range	ratio	real	1.0-20.0		number
UNITTYPE	Y	N	char(3)	enum	nominal
VERT_INDEX	Y	N	numeric(5,0)	range	ratio	natural	1.-28301.		number
PITNUMBER	N	Y	numeric(10,0)	range	interval	natural	62048.-28180046.		number
SPECIES	N	Y	char(4)	taxa	nominal
LENGTH1	N	Y	numeric(3,0)	range	ratio	real	10.-253.		millimeters
LENGTH2	N	Y	numeric(3,0)	range	ratio	real	20.-284.		millimeters
WEIGHT	N	Y	numeric(7,2)	range	ratio	real	0.09-134.59		grams
CLIP	N	N	char(6)	enum	nominal
SAMPLEDATE	N	N	datetime	range	datetime		Oct 6 1987-Sep 8 2022		date as date type
NOTES	N	Y	varchar(150)	freetext	nominal