SA026

Properties of Attributes in entity 1 table: Plant-pollinator interactions

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
COMPLEX	N	N	char(15)	enum	nominal
MEADOW	N	N	char(3)	place	nominal
PLOT_ID	Y	N	char(5)	place	nominal
YEAR	N	N	numeric(4,0)	range	interval	natural	2011.-2021.		number
SAMPLEDATE	Y	N	datetime	range	datetime		Jul 12 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.-10.		number
START_TIME	Y	Y	char(5)	freetext	nominal
END_TIME	N	Y	char(5)	freetext	nominal
MINUTE	Y	N	char(2)	enum	ordinal
CLOUDS	N	N	char(2)	enum	nominal
WIND	N	N	char(2)	enum	nominal
TEMP	N	Y	numeric(2,0)	range	ratio	real	0.-44.		degrees Celsius
PPI_STATUS	N	N	char(1)	enum	nominal
NO_INT	N	Y	numeric(3,0)	range	ratio	whole	0.-999.		number
PLTSP_CODE	Y	Y	char(8)	taxa	nominal
PLTSP_NAME	N	Y	varchar(50)	freetext	nominal
VISSP_CODE	Y	Y	char(8)	taxa	nominal
VISSP_NAME	N	Y	varchar(50)	freetext	nominal
VISSP_TYPE	N	Y	varchar(30)	freetext	nominal
REF_NO	N	Y	char(10)	freetext	nominal
VISSP_NO	Y	N	numeric(2,0)	range	ratio	whole	1.-35.		number
QC_NOTES	N	Y	char(254)	freetext	nominal