{ "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 29, "name": "WSketchData", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Employee", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "Employee", "type": "esriFieldTypeString", "alias": "Employee", "length": 5 }, { "name": "WOrder", "type": "esriFieldTypeString", "alias": "WOrder", "length": 16 }, { "name": "WSketchID", "type": "esriFieldTypeInteger", "alias": "WSketchID" }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 100 }, { "name": "EndDate", "type": "esriFieldTypeDate", "alias": "CompleteDate", "length": 8 }, { "name": "Completed", "type": "esriFieldTypeString", "alias": "Completed", "length": 3 }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50 }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250 }, { "name": "Billed", "type": "esriFieldTypeString", "alias": "Billable", "length": 3 }, { "name": "UGround", "type": "esriFieldTypeString", "alias": "UGround", "length": 3 }, { "name": "Remarks", "type": "esriFieldTypeString", "alias": "Remarks", "length": 200 }, { "name": "Hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 254 }, { "name": "Customer", "type": "esriFieldTypeString", "alias": "Customer", "length": 24 }, { "name": "UG_ft", "type": "esriFieldTypeString", "alias": "UG(ft)", "length": 50 }, { "name": "OH_ft", "type": "esriFieldTypeString", "alias": "OH(ft)", "length": 50 }, { "name": "JBox", "type": "esriFieldTypeString", "alias": "JBox", "length": 50 }, { "name": "XferOH", "type": "esriFieldTypeString", "alias": "XferOH", "length": 50 }, { "name": "XferUG", "type": "esriFieldTypeString", "alias": "XferUG", "length": 50 }, { "name": "Poles", "type": "esriFieldTypeString", "alias": "Poles", "length": 50 }, { "name": "Lights", "type": "esriFieldTypeString", "alias": "Lights", "length": 50 } ], "indexes": [ { "name": "R874_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2360WSketchID", "fields": "WSketchID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 37, "name": "WSketchLink", "relatedTableId": 27, "role": "esriRelRoleOrigin", "keyField": "WSketchID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 39, "name": "WSketchLink", "relatedTableId": 48, "role": "esriRelRoleOrigin", "keyField": "WSketchID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 40, "name": "WSketchLink", "relatedTableId": 38, "role": "esriRelRoleOrigin", "keyField": "WSketchID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 41, "name": "WSketchLink", "relatedTableId": 40, "role": "esriRelRoleOrigin", "keyField": "WSketchID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 42, "name": "WSketchLink", "relatedTableId": 42, "role": "esriRelRoleOrigin", "keyField": "WSketchID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 43, "name": "WSketchLink", "relatedTableId": 46, "role": "esriRelRoleOrigin", "keyField": "WSketchID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 44, "name": "WSketchLink", "relatedTableId": 44, "role": "esriRelRoleOrigin", "keyField": "WSketchID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 45, "name": "WSketchLink", "relatedTableId": 30, "role": "esriRelRoleOrigin", "keyField": "WSketchID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 46, "name": "WSketchLink", "relatedTableId": 54, "role": "esriRelRoleOrigin", "keyField": "WSketchID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 47, "name": "WSketchLink", "relatedTableId": 59, "role": "esriRelRoleOrigin", "keyField": "WSketchID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 48, "name": "WSketchLink", "relatedTableId": 56, "role": "esriRelRoleOrigin", "keyField": "WSketchID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 49, "name": "WSketchLink", "relatedTableId": 57, "role": "esriRelRoleOrigin", "keyField": "WSketchID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,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": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }