Properties of Attributes in entity 2 table: Precipitation water nutrient inflow in kg/ha
| Name |
Keyfield |
Nullable |
Attribute Type |
Domain |
Scale |
NumType |
Range |
Precision |
Units |
| STCODE |
N |
N |
char(5) |
enum
|
nominal |
|
|
|
|
| ENTITY |
N |
N |
numeric(1,0) |
range
|
ratio |
natural |
2-2 |
1 |
number |
| SITECODE |
Y |
N |
char(6) |
place
|
nominal |
|
|
|
|
| WATERYEAR |
N |
Y |
numeric(4,0) |
range
|
datetime |
|
1969-2010 |
1 |
year (yyyy) |
| DATE_TIME |
Y |
N |
datetime |
range
|
datetime |
|
Oct 21 1968 10:45AM-Jan 4 2010 6:45PM |
|
date as datetime type |
| LABNO |
N |
Y |
char(4) |
freetext |
nominal |
|
|
|
|
| TYPE |
N |
N |
char(2) |
enum
|
nominal |
|
|
|
|
| PRECIP_CM |
N |
Y |
numeric(6,2) |
range
|
ratio |
real |
0-140.89 |
0.025 |
centimeters |
| PCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| ALK_INPUT |
N |
Y |
numeric(6,2) |
range
|
ratio |
real |
0-4.67 |
0.05 |
kilograms per hectare |
| ALKCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| SSED_INPUT |
N |
Y |
numeric(7,2) |
range
|
ratio |
real |
0-54.83 |
0.05 |
kilograms per hectare |
| SSEDCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| SI_INPUT |
N |
Y |
numeric(6,2) |
range
|
ratio |
real |
0-9.98 |
0.05 |
kilograms per hectare |
| SICODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| UTP_INPUT |
N |
Y |
numeric(5,3) |
range
|
ratio |
real |
0-0.472 |
0.005 |
kilograms per hectare |
| UTPCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| TDP_INPUT |
N |
Y |
numeric(5,3) |
range
|
ratio |
real |
0-0.427 |
0.005 |
kilograms per hectare |
| TDPCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| PARTP_INPUT |
N |
Y |
numeric(5,3) |
range
|
ratio |
real |
0-0.259 |
0.005 |
kilograms per hectare |
| PARTPCODE |
N |
Y |
char(2) |
enum
|
nominal |
|
|
|
|
| PO4P_INPUT |
N |
Y |
numeric(5,3) |
range
|
ratio |
real |
0-0.476 |
0.005 |
kilograms per hectare |
| PO4PCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| UTN_INPUT |
N |
Y |
numeric(5,2) |
range
|
ratio |
real |
0-1.37 |
0.01 |
kilograms per hectare |
| UTNCODE |
N |
Y |
char(2) |
enum
|
nominal |
|
|
|
|
| TDN_INPUT |
N |
Y |
numeric(5,2) |
range
|
interval |
whole |
0-5 |
0.01 |
kilograms per hectare |
| TDNCODE |
N |
Y |
char(2) |
enum
|
nominal |
|
|
|
|
| DON_INPUT |
N |
Y |
numeric(5,2) |
range
|
ratio |
real |
0-3.78 |
0.01 |
kilograms per hectare |
| DONCODE |
N |
Y |
char(2) |
enum
|
nominal |
|
|
|
|
| PARTN_INPUT |
N |
Y |
numeric(5,2) |
range
|
ratio |
real |
0-1.19 |
0.01 |
kilograms per hectare |
| PARTNCODE |
N |
Y |
char(2) |
enum
|
nominal |
|
|
|
|
| UTKN_INPUT |
N |
Y |
numeric(5,2) |
range
|
ratio |
real |
0-1.35 |
0.01 |
kilograms per hectare |
| UTKNCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| TKN_INPUT |
N |
Y |
numeric(5,2) |
range
|
ratio |
real |
0-4.98 |
0.01 |
kilograms per hectare |
| TKNCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| NH3N_INPUT |
N |
Y |
numeric(5,3) |
range
|
ratio |
real |
0-1.196 |
0.005 |
kilograms per hectare |
| NH3NCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| NO3N_INPUT |
N |
Y |
numeric(5,3) |
range
|
ratio |
real |
0-0.394 |
0.005 |
kilograms per hectare |
| NO3NCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| NA_INPUT |
N |
Y |
numeric(5,2) |
range
|
ratio |
real |
0-2.84 |
0.02 |
kilograms per hectare |
| NACODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| K_INPUT |
N |
Y |
numeric(5,2) |
range
|
ratio |
real |
0-1.41 |
0.02 |
kilograms per hectare |
| KCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| CA_INPUT |
N |
Y |
numeric(5,2) |
range
|
ratio |
real |
0-3.63 |
0.06 |
kilograms per hectare |
| CACODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| MG_INPUT |
N |
Y |
numeric(5,2) |
range
|
ratio |
real |
0-1.16 |
0.02 |
kilograms per hectare |
| MGCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| SO4S_INPUT |
N |
Y |
numeric(6,2) |
range
|
ratio |
real |
0-4.38 |
0.02 |
kilograms per hectare |
| SO4SCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| CL_INPUT |
N |
Y |
numeric(6,2) |
range
|
ratio |
real |
0-5.97 |
0.02 |
kilograms per hectare |
| CLCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
| DOC_INPUT |
N |
Y |
numeric(5,2) |
range
|
ratio |
real |
0-2.65 |
0.02 |
kilograms per hectare |
| DOCCODE |
N |
Y |
char(1) |
enum
|
nominal |
|
|
|
|
|