{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 6,
 "name": "SampleAttachments",
 "type": "Table",
 "description": "The Sample Attachments table in the MMIS geodatabase contains BOEM-local file paths or weblinks to photos and datasheets associated with collection and analysis of sediment samples listed in the related Samples table. These attachments generally include sample photos (core and grabs), field logs, core logs, grain-size analyses, penetrometer logs, location maps, or data sheets from other analyses (e.g. benthic community biomass) conducted on individual samples. This table is linked to the Samples table, which is subsequently linked to both the Grab Samples feature class and the Core Samples feature class.",
 "copyrightText": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "SampleID",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "StudyID",
   "type": "esriFieldTypeString",
   "alias": "Study ID",
   "length": 250,
   "domain": null
  },
  {
   "name": "SampleID",
   "type": "esriFieldTypeString",
   "alias": "Sample ID",
   "length": 50,
   "domain": null
  },
  {
   "name": "AttachmentType",
   "type": "esriFieldTypeString",
   "alias": "Attachment Type",
   "length": 50,
   "domain": null
  },
  {
   "name": "GlobalAttachID",
   "type": "esriFieldTypeGUID",
   "alias": "Global Attach ID",
   "length": 38,
   "domain": null
  },
  {
   "name": "Public_AttachLink",
   "type": "esriFieldTypeString",
   "alias": "Public Attachment Link",
   "length": 500,
   "domain": null
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R22_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G43GlobalAttachI",
   "fields": "GlobalAttachID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 4,
   "name": "GrabSamples",
   "relatedTableId": 1,
   "role": "esriRelRoleDestination",
   "keyField": "GlobalAttachID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{0176CDF2-8645-477F-947F-6C658D77046C}"
  },
  {
   "id": 2,
   "name": "CoreSamples",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "GlobalAttachID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{3093D214-3D80-47BF-AF00-B589FA21297F}"
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "0629188a35044eb780eb59f53dc8d8be"
}