SA026

Properties of Attributes in entity 2 table: Flowering plant surveys

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
COMPLEX	N	N	char(15)	enum	nominal
MEADOW	N	Y	char(3)	place	nominal
PLOT_ID	Y	Y	char(5)	place	nominal
YEAR	N	N	numeric(4,0)	range	interval	natural	2011.-2021.		number
SAMPLEDATE	Y	N	datetime	range	datetime		Jul 13 2011-Jul 21 2021		date as date type
WATCH	Y	N	char(4)	enum	ordinal
OBSERVER	N	Y	char(15)	freetext	nominal
PLOT	N	N	numeric(2,0)	range	interval	natural	1.-12.		number
FLW_STATUS	N	Y	char(3)	enum	ordinal
PLTSP_CODE	Y	Y	char(8)	taxa	nominal
PLTSP_NAME	N	Y	varchar(50)	freetext	nominal
NO_STALK	N	Y	numeric(4,0)	range	ratio	natural	1.-5000.		number
NO_FLWS	N	Y	numeric(5,1)	range	ratio	real	0.5-2000.0		number
QC_NOTES	N	Y	char(254)	freetext	nominal