HJA newt logoHJ Andrews
Login Donate
 
 

CP002

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.00-140.89 0.02 centimeters
    PCODE N Y char(1) enum nominal
    ALK_INPUT N Y numeric(6,2) range ratio real 0.00-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.00-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.00-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.000-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.000-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.000-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.000-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.00-1.37 0.01 kilograms per hectare
    UTNCODE N Y char(2) enum nominal
    TDN_INPUT N Y numeric(5,2) range interval real 0.00-5.00 0.01 kilograms per hectare
    TDNCODE N Y char(2) enum nominal
    DON_INPUT N Y numeric(5,2) range ratio real 0.00-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.00-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.00-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.00-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.000-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.000-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.00-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.00-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.00-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.00-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.00-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.00-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.00-2.65 0.02 kilograms per hectare
    DOCCODE N Y char(1) enum nominal