{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 2,
 "name": "Fish",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "CATCH_ID",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "FISH_ID",
   "type": "esriFieldTypeGUID",
   "alias": "Fish ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "EVENT_ID",
   "type": "esriFieldTypeGUID",
   "alias": "Event ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "CATCH_ID",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Catch ID",
   "domain": null
  },
  {
   "name": "PASS_NUM",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Pass Number",
   "domain": null
  },
  {
   "name": "SPECIES_CODE",
   "type": "esriFieldTypeString",
   "alias": "Fish Species Code",
   "length": 4,
   "domain": {
    "type": "codedValue",
    "name": "species_codes",
    "description": "Fish Species Codes",
    "codedValues": [
     {
      "name": "ALTR",
      "code": "ALTR"
     },
     {
      "name": "ANY",
      "code": "ANY"
     },
     {
      "name": "BG",
      "code": "BG"
     },
     {
      "name": "BH",
      "code": "BH"
     },
     {
      "name": "BHBK",
      "code": "BHBK"
     },
     {
      "name": "BHCH",
      "code": "BHCH"
     },
     {
      "name": "BHYL",
      "code": "BHYL"
     },
     {
      "name": "BK",
      "code": "BK"
     },
     {
      "name": "BKMX",
      "code": "BKMX"
     },
     {
      "name": "BKOW",
      "code": "BKOW"
     },
     {
      "name": "BN",
      "code": "BN"
     },
     {
      "name": "BNMX",
      "code": "BNMX"
     },
     {
      "name": "BNSC",
      "code": "BNSC"
     },
     {
      "name": "BRJS",
      "code": "BRJS"
     },
     {
      "name": "BRSJ",
      "code": "BRSJ"
     },
     {
      "name": "BS",
      "code": "BS"
     },
     {
      "name": "BSLM",
      "code": "BSLM"
     },
     {
      "name": "BSSM",
      "code": "BSSM"
     },
     {
      "name": "BSST",
      "code": "BSST"
     },
     {
      "name": "BSWH",
      "code": "BSWH"
     },
     {
      "name": "CB",
      "code": "CB"
     },
     {
      "name": "CBBT",
      "code": "CBBT"
     },
     {
      "name": "CBCK",
      "code": "CBCK"
     },
     {
      "name": "CBHB",
      "code": "CBHB"
     },
     {
      "name": "CBLS",
      "code": "CBLS"
     },
     {
      "name": "CBLSNO",
      "code": "CBLSNO"
     },
     {
      "name": "CBLSSO",
      "code": "CBLSSO"
     },
     {
      "name": "CBLT",
      "code": "CBLT"
     },
     {
      "name": "CBNL",
      "code": "CBNL"
     },
     {
      "name": "CBRT",
      "code": "CBRT"
     },
     {
      "name": "CBSL",
      "code": "CBSL"
     },
     {
      "name": "CBUT",
      "code": "CBUT"
     },
     {
      "name": "CBVR",
      "code": "CBVR"
     },
     {
      "name": "CPCO",
      "code": "CPCO"
     },
     {
      "name": "CPGS",
      "code": "CPGS"
     },
     {
      "name": "CRBL",
      "code": "CRBL"
     },
     {
      "name": "CRWH",
      "code": "CRWH"
     },
     {
      "name": "CSVB",
      "code": "CSVB"
     },
     {
      "name": "CT",
      "code": "CT"
     },
     {
      "name": "CTBL",
      "code": "CTBL"
     },
     {
      "name": "CTBV",
      "code": "CTBV"
     },
     {
      "name": "CTCR",
      "code": "CTCR"
     },
     {
      "name": "CTLH",
      "code": "CTLH"
     },
     {
      "name": "CTSB",
      "code": "CTSB"
     },
     {
      "name": "CTSN",
      "code": "CTSN"
     },
     {
      "name": "CTYL",
      "code": "CTYL"
     },
     {
      "name": "CY",
      "code": "CY"
     },
     {
      "name": "DC",
      "code": "DC"
     },
     {
      "name": "DCLN",
      "code": "DCLN"
     },
     {
      "name": "DCSP",
      "code": "DCSP"
     },
     {
      "name": "DI",
      "code": "DI"
     },
     {
      "name": "DJ",
      "code": "DJ"
     },
     {
      "name": "GF",
      "code": "GF"
     },
     {
      "name": "GP",
      "code": "GP"
     },
     {
      "name": "GRAC",
      "code": "GRAC"
     },
     {
      "name": "GT",
      "code": "GT"
     },
     {
      "name": "KIPL",
      "code": "KIPL"
     },
     {
      "name": "KIRN",
      "code": "KIRN"
     },
     {
      "name": "KS",
      "code": "KS"
     },
     {
      "name": "KSFG",
      "code": "KSFG"
     },
     {
      "name": "KSGL",
      "code": "KSGL"
     },
     {
      "name": "KSMX",
      "code": "KSMX"
     },
     {
      "name": "KSPP",
      "code": "KSPP"
     },
     {
      "name": "KSRJ",
      "code": "KSRJ"
     },
     {
      "name": "KSSC",
      "code": "KSSC"
     },
     {
      "name": "LK",
      "code": "LK"
     },
     {
      "name": "LKBL",
      "code": "LKBL"
     },
     {
      "name": "LKJL",
      "code": "LKJL"
     },
     {
      "name": "MKTG",
      "code": "MKTG"
     },
     {
      "name": "MN",
      "code": "MN"
     },
     {
      "name": "MNBR",
      "code": "MNBR"
     },
     {
      "name": "MNFH",
      "code": "MNFH"
     },
     {
      "name": "MNPL",
      "code": "MNPL"
     },
     {
      "name": "MS",
      "code": "MS"
     },
     {
      "name": "MSWS",
      "code": "MSWS"
     },
     {
      "name": "NP",
      "code": "NP"
     },
     {
      "name": "PCSM",
      "code": "PCSM"
     },
     {
      "name": "PCYL",
      "code": "PCYL"
     },
     {
      "name": "RT",
      "code": "RT"
     },
     {
      "name": "RTAB",
      "code": "RTAB"
     },
     {
      "name": "RTAL",
      "code": "RTAL"
     },
     {
      "name": "RTCC",
      "code": "RTCC"
     },
     {
      "name": "RTEL",
      "code": "RTEL"
     },
     {
      "name": "RTER",
      "code": "RTER"
     },
     {
      "name": "RTFD",
      "code": "RTFD"
     },
     {
      "name": "RTGK",
      "code": "RTGK"
     },
     {
      "name": "RTHY",
      "code": "RTHY"
     },
     {
      "name": "RTMC",
      "code": "RTMC"
     },
     {
      "name": "RTMX",
      "code": "RTMX"
     },
     {
      "name": "RTRB",
      "code": "RTRB"
     },
     {
      "name": "RTSC",
      "code": "RTSC"
     },
     {
      "name": "RTSH",
      "code": "RTSH"
     },
     {
      "name": "RTSK",
      "code": "RTSK"
     },
     {
      "name": "RTSS",
      "code": "RTSS"
     },
     {
      "name": "RTTS",
      "code": "RTTS"
     },
     {
      "name": "SC",
      "code": "SC"
     },
     {
      "name": "SCBL",
      "code": "SCBL"
     },
     {
      "name": "SCMT",
      "code": "SCMT"
     },
     {
      "name": "SCPU",
      "code": "SCPU"
     },
     {
      "name": "SCUL",
      "code": "SCUL"
     },
     {
      "name": "SDVR",
      "code": "SDVR"
     },
     {
      "name": "SFBL",
      "code": "SFBL"
     },
     {
      "name": "SFGR",
      "code": "SFGR"
     },
     {
      "name": "SHGZ",
      "code": "SHGZ"
     },
     {
      "name": "SHTF",
      "code": "SHTF"
     },
     {
      "name": "SK",
      "code": "SK"
     },
     {
      "name": "SKBL",
      "code": "SKBL"
     },
     {
      "name": "SKDS",
      "code": "SKDS"
     },
     {
      "name": "SKFM",
      "code": "SKFM"
     },
     {
      "name": "SKGR",
      "code": "SKGR"
     },
     {
      "name": "SKJN",
      "code": "SKJN"
     },
     {
      "name": "SKLN",
      "code": "SKLN"
     },
     {
      "name": "SKMT",
      "code": "SKMT"
     },
     {
      "name": "SKRZ",
      "code": "SKRZ"
     },
     {
      "name": "SKUT",
      "code": "SKUT"
     },
     {
      "name": "SKWH",
      "code": "SKWH"
     },
     {
      "name": "SMDT",
      "code": "SMDT"
     },
     {
      "name": "SMRB",
      "code": "SMRB"
     },
     {
      "name": "SN",
      "code": "SN"
     },
     {
      "name": "SP",
      "code": "SP"
     },
     {
      "name": "SPJO",
      "code": "SPJO"
     },
     {
      "name": "SQCR",
      "code": "SQCR"
     },
     {
      "name": "SRGD",
      "code": "SRGD"
     },
     {
      "name": "SRRD",
      "code": "SRRD"
     },
     {
      "name": "SRRS",
      "code": "SRRS"
     },
     {
      "name": "SRSD",
      "code": "SRSD"
     },
     {
      "name": "SRST",
      "code": "SRST"
     },
     {
      "name": "TG",
      "code": "TG"
     },
     {
      "name": "TMPL",
      "code": "TMPL"
     },
     {
      "name": "TRTG",
      "code": "TRTG"
     },
     {
      "name": "UK",
      "code": "UK"
     },
     {
      "name": "WD",
      "code": "WD"
     },
     {
      "name": "WE",
      "code": "WE"
     },
     {
      "name": "WF",
      "code": "WF"
     },
     {
      "name": "WFBL",
      "code": "WFBL"
     },
     {
      "name": "WFBV",
      "code": "WFBV"
     },
     {
      "name": "WFMT",
      "code": "WFMT"
     },
     {
      "name": "WP",
      "code": "WP"
     },
     {
      "name": "WPSW",
      "code": "WPSW"
     },
     {
      "name": "WPWS",
      "code": "WPWS"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "LENGTH",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Length",
   "domain": null
  },
  {
   "name": "LENGTH_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Length Type",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "length_types",
    "description": "Fish Length Types",
    "codedValues": [
     {
      "name": "FRK",
      "code": "FRK"
     },
     {
      "name": "STD",
      "code": "STD"
     },
     {
      "name": "TOT",
      "code": "TOT"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "WEIGHT",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Weight",
   "domain": null
  },
  {
   "name": "NOTES",
   "type": "esriFieldTypeString",
   "alias": "NOTES",
   "length": 250,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R20_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G50FISH_ID",
   "fields": "FISH_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G50EVENT_ID",
   "fields": "EVENT_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 5,
   "name": "Health",
   "relatedTableId": 4,
   "role": "esriRelRoleOrigin",
   "keyField": "FISH_ID",
   "cardinality": "esriRelCardinalityOneToOne",
   "composite": true
  },
  {
   "id": 6,
   "name": "Tags",
   "relatedTableId": 5,
   "role": "esriRelRoleOrigin",
   "keyField": "FISH_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true
  },
  {
   "id": 7,
   "name": "Diet",
   "relatedTableId": 3,
   "role": "esriRelRoleOrigin",
   "keyField": "FISH_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true
  },
  {
   "id": 1,
   "name": "SamplingEvent",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "EVENT_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true
  }
 ],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": false,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsSqlFormat": true,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}