AS011

Properties of Attributes in entity 1 table: Raw data on vertebrate length, weight, and abundance

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units	Missing Value Code
DBCODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	natural	1.-1.		number
YEAR	N	N	numeric(4,0)	range	interval	natural	2013.-2019.		year (yyyy)
DATE	Y	N	datetime	range	datetime		Aug 6 2013-Aug 15 2019		date as date type
STREAM	Y	N	char(10)	place	ordinal
SITE	Y	N	varchar(30)	enum	nominal
SITE_CODE	Y	N	char(10)	place	ordinal
VISIT_NO	Y	N	char(1)	enum	ordinal
SAMPLING_TEAM	N	N	char(15)	enum	nominal
SAMPLING_METHOD	Y	N	char(3)	enum	nominal
MARK_RECAP	N	N	char(5)	enum	nominal
PASS_NUMBER	N	N	numeric(1,0)	range	ratio	natural	1.-4.		number
PASS_DIRECTION	N	N	char(1)	enum	nominal
SPECIES	Y	N	char(3)	taxa	ordinal
VENT_FORK_LENGTH	N	Y	numeric(3,0)	range	ratio	real	1.-250.		millimeters
TOTAL_LENGTH	N	Y	numeric(3,0)	range	ratio	real	1.-350.		millimeters
TF_LENGTH_LEGS_EXTENDED	N	Y	numeric(3,0)	range	ratio	real	1.-150.		millimeters
WEIGHT	N	Y	numeric(5,1)	range	ratio	real	0.1-300.0		grams
LIFESTAGE_DEVELOPMENT	N	N	char(3)	enum	nominal
MARKED	N	N	char(2)	enum	nominal
RECAPTURED	N	N	char(2)	enum	nominal
COMMENTS	N	Y	varchar(254)	freetext	nominal
QA_NOTES	N	Y	varchar(254)	freetext	nominal
VERT_INDEX	Y	N	numeric(4,0)	range	ratio	natural	1.-1000.		number