{ "currentVersion": 10.91, "id": 7, "name": "KilgoreGIS.SDE.FO_Buffer_Tube", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ASSETID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "ASSETID", "length": 20, "domain": null }, { "name": "COLOR", "type": "esriFieldTypeString", "alias": "COLOR", "length": 50, "domain": { "type": "codedValue", "name": "FO_Color", "description": "Fiber Buffer/Glass Color", "codedValues": [ { "name": "BLUE", "code": "BLUE" }, { "name": "ORANGE", "code": "ORANGE" }, { "name": "GREEN", "code": "GREEN" }, { "name": "BROWN", "code": "BROWN" }, { "name": "SLATE", "code": "SLATE" }, { "name": "WHITE", "code": "WHITE" }, { "name": "RED", "code": "RED" }, { "name": "BLACK", "code": "BLACK" }, { "name": "YELLOW", "code": "YELLOW" }, { "name": "VIOLET", "code": "VIOLET" }, { "name": "ROSE", "code": "ROSE" }, { "name": "AQUA", "code": "AQUA" }, { "name": "BLUE STRIPED", "code": "BLUE STRIPED" }, { "name": "ORANGE STRIPED", "code": "ORANGE STRIPED" }, { "name": "GREEN STRIPED", "code": "GREEN STRIPED" }, { "name": "BROWN STRIPED", "code": "BROWN STRIPED" }, { "name": "SLATE STRIPED", "code": "SLATE STRIPED" }, { "name": "WHITE STRIPED", "code": "WHITE STRIPED" }, { "name": "RED STRIPED", "code": "RED STRIPED" }, { "name": "BLACK STRIPED", "code": "BLACK STRIPED" }, { "name": "YELLOW STRIPED", "code": "YELLOW STRIPED" }, { "name": "VIOLET STRIPED", "code": "VIOLET STRIPED" }, { "name": "ROSE STRIPED", "code": "ROSE STRIPED" }, { "name": "AQUA STRIPED", "code": "AQUA STRIPED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STRAND_COUNT", "type": "esriFieldTypeInteger", "alias": "STRAND COUNT", "domain": null }, { "name": "FIBER_OPTIC_ASSETID", "type": "esriFieldTypeString", "alias": "FIBER OPTIC ASSETID", "length": 20, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R11936_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_11936", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G41165ASSETID", "fields": "ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G41165FIBER_OPTI", "fields": "FIBER_OPTIC_ASSETID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_11936", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Fibers", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 0, "name": "Fiber Optic Line", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "FIBER_OPTIC_ASSETID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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 }