WE035

Properties of Attributes in entity 1 table: Prey information for each scat

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
SCAT_ID	N	N	char(7)	place	ordinal
GRID_NUMBER	Y	N	char(2)	place	nominal
SCAT_NUMBER	Y	N	numeric(3,0)	range	ratio	natural	1.-927.		number
COLLECTION_TYPE	Y	N	char(2)	enum	nominal
COLLECTION_DATETIME	Y	N	datetime	range	datetime		Aug 3 2017 12:00AM-Jan 25 2019 12:00AM		date as datetime type
LOCUS	N	N	char(6)	enum	nominal
PREY_SUPERKINGDOM	Y	N	char(15)	taxa	ordinal
PREY_KINGDOM	Y	Y	varchar(20)	taxa	ordinal
PREY_PHYLUM	Y	Y	varchar(20)	taxa	ordinal
PREY_SUBPHYLUM	Y	Y	varchar(20)	taxa	ordinal
PREY_CLASS	Y	Y	varchar(30)	taxa	ordinal
PREY_ORDER	Y	Y	varchar(30)	taxa	ordinal
PREY_FAMILY	Y	Y	varchar(30)	taxa	ordinal
PREY_GENUS	Y	Y	varchar(30)	taxa	ordinal
PREY_SPECIES	Y	Y	varchar(50)	taxa	ordinal
CARNIVORE	N	N	varchar(50)	taxa	ordinal
SEQ	N	Y	varchar(254)	freetext	nominal
NUMREPS	N	Y	numeric(1,0)	range	ratio	natural	2.-9.		number
NUMREADS	N	Y	numeric(8,1)	range	ratio	real	7.0-455460.3		number
TOTALREADS	N	Y	numeric(8,1)	range	ratio	real	34.7-551050.0		number
RRA	N	Y	numeric(6,4)	range	ratio	real	0.0088-1.0000		number
PIDMATCH	N	Y	numeric(6,2)	range	ratio	real	82.33-99.54		percent
QCOVER	N	Y	numeric(6,2)	range	ratio	real	18.00-100.00		percent
BITSCORE	N	Y	numeric(6,2)	range	ratio	real	56.28-330.25		number