{ "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 87, "name": "Yardlight Customer", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CustomerName", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "CustomerID", "type": "esriFieldTypeInteger", "alias": "CustomerID" }, { "name": "HTELocationID", "type": "esriFieldTypeInteger", "alias": "HTELocationID" }, { "name": "CustomerName", "type": "esriFieldTypeString", "alias": "CustomerName", "length": 1073741822 }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 1073741822 }, { "name": "Service", "type": "esriFieldTypeString", "alias": "Service", "length": 1073741822 }, { "name": "Size_", "type": "esriFieldTypeString", "alias": "Size_", "length": 1073741822 }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 1073741822 }, { "name": "Quantity", "type": "esriFieldTypeInteger", "alias": "Quantity" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8 }, { "name": "Phone", "type": "esriFieldTypeString", "alias": "Phone", "length": 1073741822 } ], "indexes": [ { "name": "R1237_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3789_HTELoca", "fields": "HTELocationID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 25, "name": "ElecLights", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "HTELocationID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }