{ "currentVersion": 10.71, "id": 22, "name": "UnLocatedMedia", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MediaAName", "typeIdField": "MediaType", "subtypeFieldName": "MediaType", "subtypeField": "MediaType", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Pictures_ID", "type": "esriFieldTypeInteger", "alias": "Pictures_ID", "domain": null }, { "name": "MediaAName", "type": "esriFieldTypeString", "alias": "MediaAName", "length": 100, "domain": null }, { "name": "MediaEName", "type": "esriFieldTypeString", "alias": "MediaEName", "length": 100, "domain": null }, { "name": "CapNumber", "type": "esriFieldTypeString", "alias": "CapNumber", "length": 50, "domain": null }, { "name": "CapDate", "type": "esriFieldTypeDate", "alias": "CapDate", "length": 8, "domain": null }, { "name": "L1", "type": "esriFieldTypeString", "alias": "L1", "length": 300, "domain": null }, { "name": "L2", "type": "esriFieldTypeString", "alias": "L2", "length": 300, "domain": null }, { "name": "L3", "type": "esriFieldTypeString", "alias": "L3", "length": 300, "domain": null }, { "name": "L4", "type": "esriFieldTypeString", "alias": "L4", "length": 300, "domain": null }, { "name": "L5", "type": "esriFieldTypeString", "alias": "L5", "length": 300, "domain": null }, { "name": "L6", "type": "esriFieldTypeString", "alias": "L6", "length": 300, "domain": null }, { "name": "MediaParentID", "type": "esriFieldTypeInteger", "alias": "MediaParentID", "domain": null }, { "name": "MediaADescriptions", "type": "esriFieldTypeString", "alias": "MediaADescriptions", "length": 1000, "domain": null }, { "name": "MediaEDescriptions", "type": "esriFieldTypeString", "alias": "MediaEDescriptions", "length": 1000, "domain": null }, { "name": "MediaType", "type": "esriFieldTypeSmallInteger", "alias": "MediaType", "domain": null }, { "name": "Crdt", "type": "esriFieldTypeDate", "alias": "Crdt", "length": 8, "domain": null }, { "name": "Crid", "type": "esriFieldTypeString", "alias": "Crid", "length": 128, "domain": null }, { "name": "Updt", "type": "esriFieldTypeDate", "alias": "Updt", "length": 8, "domain": null }, { "name": "Upid", "type": "esriFieldTypeString", "alias": "Upid", "length": 128, "domain": null }, { "name": "PKID", "type": "esriFieldTypeInteger", "alias": "PKID", "domain": null }, { "name": "test", "type": "esriFieldTypeSmallInteger", "alias": "test", "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G57Pictures_ID", "fields": "Pictures_ID", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": {}, "id": 1, "name": "Picture" }, { "domains": {}, "id": 2, "name": "Panorama" }, { "domains": {}, "id": 3, "name": "Video" }, { "domains": {}, "id": 4, "name": "Floor Plan" }, { "domains": {}, "id": 5, "name": "Brochure" }, { "domains": {}, "id": 6, "name": "Thumb" }, { "domains": {}, "id": 7, "name": "Logo" } ], "subtypes": [ { "domains": {}, "defaultValues": { "Pictures_ID": null, "MediaAName": null, "MediaEName": null, "CapNumber": null, "CapDate": null, "L1": null, "L2": null, "L3": null, "L4": null, "L5": null, "L6": null, "MediaParentID": null, "MediaADescriptions": null, "MediaEDescriptions": null, "MediaType": null, "Crdt": null, "Crid": null, "Updt": null, "Upid": null, "PKID": null, "test": null }, "code": 1, "name": "Picture" }, { "domains": {}, "defaultValues": { "Pictures_ID": null, "MediaAName": null, "MediaEName": null, "CapNumber": null, "CapDate": null, "L1": null, "L2": null, "L3": null, "L4": null, "L5": null, "L6": null, "MediaParentID": null, "MediaADescriptions": null, "MediaEDescriptions": null, "MediaType": null, "Crdt": null, "Crid": null, "Updt": null, "Upid": null, "PKID": null, "test": null }, "code": 2, "name": "Panorama" }, { "domains": {}, "defaultValues": { "Pictures_ID": null, "MediaAName": null, "MediaEName": null, "CapNumber": null, "CapDate": null, "L1": null, "L2": null, "L3": null, "L4": null, "L5": null, "L6": null, "MediaParentID": null, "MediaADescriptions": null, "MediaEDescriptions": null, "MediaType": null, "Crdt": null, "Crid": null, "Updt": null, "Upid": null, "PKID": null, "test": null }, "code": 3, "name": "Video" }, { "domains": {}, "defaultValues": { "Pictures_ID": null, "MediaAName": null, "MediaEName": null, "CapNumber": null, "CapDate": null, "L1": null, "L2": null, "L3": null, "L4": null, "L5": null, "L6": null, "MediaParentID": null, "MediaADescriptions": null, "MediaEDescriptions": null, "MediaType": null, "Crdt": null, "Crid": null, "Updt": null, "Upid": null, "PKID": null, "test": null }, "code": 4, "name": "Floor Plan" }, { "domains": {}, "defaultValues": { "Pictures_ID": null, "MediaAName": null, "MediaEName": null, "CapNumber": null, "CapDate": null, "L1": null, "L2": null, "L3": null, "L4": null, "L5": null, "L6": null, "MediaParentID": null, "MediaADescriptions": null, "MediaEDescriptions": null, "MediaType": null, "Crdt": null, "Crid": null, "Updt": null, "Upid": null, "PKID": null, "test": null }, "code": 5, "name": "Brochure" }, { "domains": {}, "defaultValues": { "Pictures_ID": null, "MediaAName": null, "MediaEName": null, "CapNumber": null, "CapDate": null, "L1": null, "L2": null, "L3": null, "L4": null, "L5": null, "L6": null, "MediaParentID": null, "MediaADescriptions": null, "MediaEDescriptions": null, "MediaType": null, "Crdt": null, "Crid": null, "Updt": null, "Upid": null, "PKID": null, "test": null }, "code": 6, "name": "Thumb" }, { "domains": {}, "defaultValues": { "Pictures_ID": null, "MediaAName": null, "MediaEName": null, "CapNumber": null, "CapDate": null, "L1": null, "L2": null, "L3": null, "L4": null, "L5": null, "L6": null, "MediaParentID": null, "MediaADescriptions": null, "MediaEDescriptions": null, "MediaType": null, "Crdt": null, "Crid": null, "Updt": null, "Upid": null, "PKID": null, "test": null }, "code": 7, "name": "Logo" } ], "relationships": [ { "id": 1, "name": "Building", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "FKBuilding_ID", "cardinality": "esriRelCardinalityManyToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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 }