Menu

AS006

Properties of Attributes in entity 2 table: Habitat dimensions

    NameKeyfieldNullableTypeDomainScaleNumTypeRangePrecisionUnits
    DBCODE NNchar(5) enumnominal     
    ENTITY NNnumeric(1,0) range ratio natural 2.-2. number
    YEAR YYnumeric(4,0) range interval whole 1987.-2019. number
    SITECODE YYchar(8) placenominal     
    SECTION YNchar(2) enumnominal     
    REACH YNchar(1) enumnominal     
    UNITNUM YYnumeric(4,1) range ratio real 1.0-20.0 number
    UNITTYPE YYchar(3) enumnominal     
    LENGTH NYnumeric(4,1) range ratio real 1.0-57.1 meters
    WIDTH1 NYnumeric(4,1) range ratio real 0.3-9.4 meters
    WIDTH2 NYnumeric(4,1) range ratio real 0.2-10.9 meters
    WIDTH3 NYnumeric(4,1) range ratio real 0.1-12.5 meters
    WIDTH4 NYnumeric(4,1) range ratio real 0.2-11.3 meters
    WIDTH5 NYnumeric(3,1) range ratio real 0.2-11.0 meters
    DEPTH1 NYnumeric(4,2) range ratio real 0.01-0.70 meters
    DEPTH2 NYnumeric(4,2) range ratio real 0.01-0.92 meters
    DEPTH3 NYnumeric(4,2) range ratio real 0.01-0.68 meters
    DEPTH4 NYnumeric(4,2) range ratio real 0.01-0.86 meters
    DEPTH5 NYnumeric(4,2) range ratio real 0.01-0.74 meters
    DEPTH6 NYnumeric(4,2) range ratio real 0.01-0.88 meters
    DEPTH7 NYnumeric(4,2) range ratio real 0.01-0.76 meters
    DEPTH8 NYnumeric(4,2) range ratio real 0.03-0.88 meters
    DEPTH9 NYnumeric(4,2) range ratio real 0.01-1.02 meters
    DEPTH10 NYnumeric(4,2) range ratio real 0.01-0.96 meters
    DEPTH11 NYnumeric(4,2) range ratio real 0.01-0.79 meters
    DEPTH12 NYnumeric(4,2) range ratio real 0.02-1.02 meters
    DEPTH13 NYnumeric(4,2) range ratio real 0.01-0.52 meters
    DEPTH14 NYnumeric(4,2) range ratio real 0.02-0.53 meters
    DEPTH15 NYnumeric(4,2) range ratio real 0.01-0.59 meters
    DEPTH16 NYnumeric(4,2) range ratio real 0.03-0.95 meters
    DEPTH17 NYnumeric(4,2) range ratio real 0.01-0.61 meters
    DEPTH18 NYnumeric(4,2) range ratio real 0.01-0.60 meters
    DEPTH19 NYnumeric(4,2) range ratio real 0.01-0.90 meters
    DEPTH20 NYnumeric(4,2) range ratio real 0.02-1.00 meters
    MAXDEPTH NYnumeric(4,2) range ratio real 0.10-1.10 meters
    SAMPLEDATE NNdatetime range datetime  Oct 6 1987-Sep 5 2019 date as date type
    NOTES NYvarchar(150) freetextnominal