{ "currentVersion": 10.91, "id": 28, "name": "STRUCTURE PURPOSE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "strucode", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "strucode", "type": "esriFieldTypeString", "alias": "STRUCODE", "length": 80, "domain": null }, { "name": "purp", "type": "esriFieldTypeString", "alias": "PURP", "length": 120, "domain": { "type": "codedValue", "name": "PURPDO_2", "description": "Purpose", "codedValues": [ { "name": "Irrigation", "code": "IR" }, { "name": "Flood Control", "code": "FC" }, { "name": "Recreation", "code": "RE" }, { "name": "Navigation", "code": "NA" }, { "name": "Pisciculture", "code": "PS" }, { "name": "Water Supply/DrinkingWater", "code": "DW" }, { "name": "Multipurpose", "code": "MP" }, { "name": "Water Storage", "code": "WS" }, { "name": "Hydro Power", "code": "HE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "i7598strucode", "fields": "strucode", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r1992_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Barrage/Weir/Anicut", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "STRUCODE", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "Dam", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "STRUCODE", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 10000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "e47874a63a5844d0a790f29fadd91ac7" }