SA024

Properties of Attributes in entity 2 table: Individual bird observations

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	2.-2.		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_DATE	Y	N	datetime	range	datetime		May 9 2009-Jun 30 2023		date as date type
RECORD	Y	N	numeric(2,0)	range	ratio	natural	1.-67.		number
PERIOD	N	N	char(2)	enum	ordinal
MINUTE	N	N	char(2)	enum	ordinal
SPECIES	N	N	char(4)	taxa	nominal
SEX	N	N	char(1)	enum	nominal
DET_METH1	N	N	char(2)	enum	nominal
DET_METH2	N	N	char(2)	enum	nominal
DISTANCE	N	N	char(2)	enum	ordinal
NEW_RECORD	N	N	char(2)	enum	nominal
COUNTER_SING	N	N	char(2)	enum	nominal
ALT_SONG	N	N	char(2)	enum	nominal
FLOCK_COUNT	N	Y	numeric(2,0)	range	ratio	natural	2.-30.		number
COMMENTS	N	Y	varchar(250)	freetext	nominal