Menu
Home
About the Forest
Research
Data
Publications
Outreach
About Us
Home
About the Forest
Research
Data
Publications
Outreach
About Us
AN008
Properties of Attributes in entity
5
table:
Stream habitat measurements (depth and substrate size)
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
5.-5.
number
YEAR
N
N
numeric(4,0)
range
interval
natural
2014.-2016.
year (yyyy)
SITE_NUMBER
Y
N
char(8)
place
ordinal
REACH_TREATMENT
Y
N
char(1)
enum
nominal
SAMPLING_DATE
Y
N
datetime
range
datetime
Sep 3 2014-Jul 22 2016
date as date type
TRANSECT_M
Y
N
char(2)
enum
ordinal
SAMPLE_PT
Y
N
numeric(2,0)
range
ratio
natural
1.-56.
number
SUBSTRATE_MM
N
Y
numeric(7,1)
range
ratio
real
0.1-2000.0
millimeters
DEPTH_CM
N
Y
numeric(7,1)
range
ratio
real
0.0-1000.0
centimeters
NOTES
N
Y
varchar(200)
freetext
nominal