TP108

Properties of Attributes in entity 14 table: Snags (O-B, O-F, and O-F2)

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
DATACODE	N	N	char(5)	enum	nominal
ENTITY	N	N	numeric(2,0)	range	ratio	integer	14.-14.	1.	number
YEAR	Y	N	numeric(4,0)	range	interval	integer	1998.-2016.	1.	year (yyyy)
DISTRICT	N	N	char(4)	place	nominal
BLOCK	N	N	char(1)	enum	nominal
TRT	N	N	char(1)	enum	nominal
PLOT	N	N	char(6)	place	nominal
QTR	N	Y	numeric(1,0)	range	ratio	integer	1.-4.	1.	number
TAG	N	Y	numeric(5,0)	range	ratio	integer	1.-99999.		number
OLDTAG	N	Y	numeric(4,0)	range	ratio	integer	2.-7916.	1.	number
TREESPP	N	Y	char(6)	taxa	nominal
STOPHT	N	Y	numeric(5,1)	range	interval	real	0.0-75.0		meters
SDBH	N	Y	numeric(3,0)	range	ratio	integer	24.-200.	1.	centimeters
SHTCLASS	N	Y	char(1)	enum	nominal
SDECAY	N	Y	char(1)	enum	nominal
LEAN	N	Y	numeric(3,0)	range	ratio	integer	0.-90.	1.	degrees angle
ORIGIN	N	Y	char(1)	enum	nominal
SNAGSTATUS	N	Y	char(1)	enum	nominal
PTYPE	N	Y	char(1)	enum	nominal
COMMENTS	N	Y	varchar(254)	freetext	nominal
PERSONNEL	N	N	varchar(30)	freetext	nominal
SAMPLEDATE	N	Y	datetime	range	datetime		Jun 4 1998-Aug 31 2016		date as date type
SNAGID	Y	Y	varchar(13)	freetext	nominal