Properties of Attributes in entity 1 table: Air and stream temperature data from the H.J.A. 1997-2001.

    NameKeyfieldNullableTypeDomainScaleNumTypeRangePrecisionUnitsMissing Value Code
    DBCODE NNchar(5) enumnominal     
    ENTITY NNnumeric(1,0) range interval natural 1.-1. number
    STREAM NNchar(20) placenominal     
    ELEVATION NNnumeric(4,0) range ratio real 425.-1250.1.meters
    MEDIA YNchar(5) enumnominal     
    SENSORID YNchar(8) placenominal     
    DATE_TIME YNdatetime range datetime  May 21 1997 12:00AM-Oct 10 2001 12:00AM date as datetime type
    TEMP_C NNnumeric(4,2) range interval real -15.10-38.330.10degrees Celsius
    SERIAL_NUMBER NNchar(6) freetextnominal