{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 10, "name": "PROPERTYCARD", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PARCEL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PARCEL", "type": "esriFieldTypeString", "alias": "PARCEL", "length": 20, "domain": null }, { "name": "FK_WorkflowID", "type": "esriFieldTypeInteger", "alias": "FK_WorkflowID", "domain": null }, { "name": "FK_OriginCommit", "type": "esriFieldTypeInteger", "alias": "FK_OriginCommit", "domain": null }, { "name": "FK_HeadCommit", "type": "esriFieldTypeInteger", "alias": "FK_HeadCommit", "domain": null }, { "name": "FK_HeadBranch", "type": "esriFieldTypeInteger", "alias": "FK_HeadBranch", "domain": null }, { "name": "ClientUser", "type": "esriFieldTypeString", "alias": "ClientUser", "length": 255, "domain": null }, { "name": "ClientDate", "type": "esriFieldTypeDate", "alias": "ClientDate", "length": 8, "domain": null } ], "indexes": [ { "name": "R12_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I19PARCEL", "fields": "PARCEL", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G19FK_WorkflowID", "fields": "FK_WorkflowID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 154, "name": "PROPERTYCARD_09_VALUEHISTORY", "relatedTableId": 26, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{77B5A84B-D67E-47E7-8F28-4141CBAED65B}" }, { "id": 157, "name": "PROPERTYCARD_01_PARCEL", "relatedTableId": 15, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D95FAF54-5DA9-4A67-84E5-6AB200D14791}" }, { "id": 163, "name": "PROPERTYCARD_08_MARKETVALUE", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4B301D38-69AD-46DB-89C3-E731060F09B8}" }, { "id": 152, "name": "PROPERTYCARD_03_DWELLINGS", "relatedTableId": 21, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9F87A76D-1D16-4D6A-AFA5-325A07FF44FA}" }, { "id": 161, "name": "PROPERTYCARD_05_IMPROVEMENTS", "relatedTableId": 23, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{98D8D7D1-342F-49F8-A1F7-CA9DBF98137C}" }, { "id": 153, "name": "PROPERTYCARDDSCOMMITSTATES", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{6905CF18-0556-4084-86AB-38E82A82FF74}" }, { "id": 164, "name": "PROPERTYCARD_11_NOTES", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B274ACAF-FD59-4FCC-B32D-FDCA166B5D02}" }, { "id": 159, "name": "PROPERTYCARD_07_LANDS", "relatedTableId": 24, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{A2C31B42-D857-4FDD-A48A-996F9A1F4790}" }, { "id": 155, "name": "PROPERTYCARD_06_CAUV", "relatedTableId": 25, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{79249CF0-4979-4883-BA53-42BCE97DC8F4}" }, { "id": 158, "name": "PROPERTYCARD_10_SALESHISTORY", "relatedTableId": 19, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B160F727-571C-4AE0-A311-7EC24C811735}" }, { "id": 165, "name": "PROPERTYCARDDSBRANCHTAGS", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{2289BD22-A76C-4EB7-BEE1-FE1EEBFE87D3}" }, { "id": 162, "name": "PROPERTYCARD_04_FEATURES", "relatedTableId": 22, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4A7A014E-E388-4E82-BA69-E4A69FA09EBD}" }, { "id": 156, "name": "PROPERTYCARD_02_OCCUPANCY", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{06125BE4-D3A1-4D1D-ABCE-4E46D47C2565}" }, { "id": 160, "name": "PROPERTYCARD_NOTES2", "relatedTableId": 17, "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D3DF0B99-F20A-40E7-9224-B4114860359D}" }, { "id": 4, "name": "WORKFLOWS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 23, "name": "WORKFLOWS", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 42, "name": "WORKFLOWS", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 61, "name": "WORKFLOWS", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 80, "name": "WORKFLOWS", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 99, "name": "WORKFLOWS", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 118, "name": "WORKFLOWS", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 137, "name": "WORKFLOWS", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "cardinality": "esriRelCardinalityOneToOne", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }