Menu

AN008

Properties of Attributes in entity 5 table: Stream habitat measurements (depth and substrate size)

    NameKeyfieldNullableTypeDomainScaleNumTypeRangePrecisionUnitsMissing Value Code
    DBCODE NNchar(5) enumnominal     
    ENTITY NNnumeric(2,0) range ratio natural 5.-5. number
    YEAR NNnumeric(4,0) range interval natural 2014.-2016. year (yyyy)
    SITE_NUMBER YNchar(8) placeordinal     
    REACH_TREATMENT YNchar(1) enumnominal     
    SAMPLING_DATE YNdatetime range datetime  Sep 3 2014-Jul 22 2016 date as date type
    TRANSECT_M YNchar(2) enumordinal     
    SAMPLE_PT YNnumeric(2,0) range ratio natural 1.-56. number  
    SUBSTRATE_MM NYnumeric(7,1) range ratio real 0.1-2000.0 millimeters
    DEPTH_CM NYnumeric(7,1) range ratio real 0.0-1000.0 centimeters
    NOTES NYvarchar(200) freetextnominal