SA024

Properties of Attributes in entity 1 table: Bird point count survey information

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	Y	N	numeric(4,0)	range	ratio	natural	2009.-2023.		number
PLOT	Y	N	char(5)	place	nominal
REPLICATE	N	N	numeric(2,0)	range	ratio	natural	1.-6.		number
SURVEY_DATETIME	Y	N	datetime	range	datetime		May 13 2009 5:30AM-Jun 30 2023 9:11AM		date as datetime type
START_TIME	N	N	char(4)	freetext	nominal
ROUTE	N	Y	numeric(2,0)	range	ratio	natural	1.-18.		number
OBSERVER	N	Y	char(3)	freetext	nominal
SKY	N	N	char(2)	enum	ordinal
WIND	N	N	char(2)	enum	ordinal
PHENO_VEG	N	N	char(3)	enum	ordinal
PHENO_REP	N	N	char(2)	enum	ordinal
RHMA_FLWR	N	N	char(2)	enum	ordinal
STREAM	N	N	char(2)	enum	ordinal
SNOW	N	N	char(2)	enum	ordinal
SMREC	N	N	char(2)	enum	ordinal
COMMENTS	N	Y	varchar(250)	freetext	nominal