TD027

Properties of Attributes in entity 2 table: Structural Component Data From Literature

Name	Keyfield	Nullable	Type	Domain	Scale	NumType	Range	Precision	Units
STCODE	N	N	char(10)	enum	nominal
FORMAT	N	N	numeric(1,0)	range	interval	natural	2.-2.	1.	number
REFERNUM	N	N	numeric(3,0)	range	interval	natural	1.-999.	1.	number
SUBSTRATE	Y	N	char(2)	enum	nominal
SPECIES	Y	N	char(6)	taxa	nominal
TYPES	Y	N	char(4)	enum	nominal
REC_ID	Y	Y	numeric(3,0)	range	interval	whole	1.-114.		number
DIAMETER	N	N	numeric(6,2)	range	ratio	real	0.00-265.00	0.01	centimeters
LAYERTH	N	Y	numeric(6,2)	range	ratio	real	0.00-250.00	0.01	centimeters
FIRLAYTH	N	Y	numeric(6,2)	range	ratio	real	0.00-25.00	0.01	centimeters
SECLAYTH	N	Y	numeric(6,2)	range	ratio	real	0.00-40.00	0.01	centimeters
LAYERTP	N	Y	numeric(6,2)	range	ratio	real	0.00-100.00	0.01	percent
FIRLAYTP	N	Y	numeric(6,2)	range	ratio	real	0.00-50.00	0.01	percent
SECLAYTP	N	Y	numeric(6,2)	range	ratio	real	0.00-100.00	0.01	percent
LAYERVP	N	Y	numeric(6,2)	range	ratio	real	0.00-100.00	0.01	percent
FIRLAYVP	N	N	numeric(6,2)	range	ratio	real	0.00-100.00	0.01	percent
SECLAYVP	N	Y	numeric(6,2)	range	ratio	real	0.00-100.00	0.01	percent
REMARKS	N	Y	varchar(120)	freetext	nominal