{ "currentVersion": 10.91, "id": 20, "name": "Sewer.GIS.ssMotor", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "EquipmentID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "EquipmentID", "type": "esriFieldTypeString", "alias": "EquipmentID", "length": 20, "domain": null }, { "name": "InstallYear", "type": "esriFieldTypeInteger", "alias": "InstallYear", "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 30, "domain": { "type": "codedValue", "name": "ssDomainManufacturer", "description": "", "codedValues": [ { "name": "John Smith", "code": "JS" }, { "name": "McManus", "code": "MC" }, { "name": "John Foundry", "code": "JF" }, { "name": "Unknown", "code": "Unk" }, { "name": "Other", "code": "Oth" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "Model", "type": "esriFieldTypeString", "alias": "Model", "length": 30, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "SerialNumber", "length": 25, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 20, "domain": { "type": "codedValue", "name": "ssDomainLifecycleStatus", "description": "", "codedValues": [ { "name": "Proposed", "code": "Proposed" }, { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Under Construction", "code": "UC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "NetworkOID", "type": "esriFieldTypeInteger", "alias": "NetworkOID", "domain": null }, { "name": "AveragePowerUsage", "type": "esriFieldTypeString", "alias": "AveragePowerUsage", "length": 20, "domain": null }, { "name": "PeakpowerUsage", "type": "esriFieldTypeString", "alias": "PeakpowerUsage", "length": 20, "domain": null }, { "name": "Phases", "type": "esriFieldTypeString", "alias": "Phases", "length": 20, "domain": null }, { "name": "RatedPower", "type": "esriFieldTypeString", "alias": "RatedPower", "length": 20, "domain": null }, { "name": "RPM", "type": "esriFieldTypeInteger", "alias": "RPM", "domain": null }, { "name": "VariableSpeed", "type": "esriFieldTypeString", "alias": "VariableSpeed", "length": 20, "domain": null }, { "name": "Voltage", "type": "esriFieldTypeInteger", "alias": "Voltage", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R101_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G53NetworkOID", "fields": "NetworkOID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_101", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_101", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "ssNeworkStructure", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "NetworkOID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 30000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }