{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 10, "name": "PROPERTYCARD", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 154, "name": "PROPERTYCARD_09_VALUEHISTORY", "relatedTableId": 26, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{77B5A84B-D67E-47E7-8F28-4141CBAED65B}" }, { "id": 157, "name": "PROPERTYCARD_01_PARCEL", "relatedTableId": 15, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{D95FAF54-5DA9-4A67-84E5-6AB200D14791}" }, { "id": 163, "name": "PROPERTYCARD_08_MARKETVALUE", "relatedTableId": 18, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{4B301D38-69AD-46DB-89C3-E731060F09B8}" }, { "id": 152, "name": "PROPERTYCARD_03_DWELLINGS", "relatedTableId": 21, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{9F87A76D-1D16-4D6A-AFA5-325A07FF44FA}" }, { "id": 161, "name": "PROPERTYCARD_05_IMPROVEMENTS", "relatedTableId": 23, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{98D8D7D1-342F-49F8-A1F7-CA9DBF98137C}" }, { "id": 153, "name": "PROPERTYCARDDSCOMMITSTATES", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": true, "catalogID": "{6905CF18-0556-4084-86AB-38E82A82FF74}" }, { "id": 164, "name": "PROPERTYCARD_11_NOTES", "relatedTableId": 16, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{B274ACAF-FD59-4FCC-B32D-FDCA166B5D02}" }, { "id": 159, "name": "PROPERTYCARD_07_LANDS", "relatedTableId": 24, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{A2C31B42-D857-4FDD-A48A-996F9A1F4790}" }, { "id": 155, "name": "PROPERTYCARD_06_CAUV", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{79249CF0-4979-4883-BA53-42BCE97DC8F4}" }, { "id": 158, "name": "PROPERTYCARD_10_SALESHISTORY", "relatedTableId": 19, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{B160F727-571C-4AE0-A311-7EC24C811735}" }, { "id": 165, "name": "PROPERTYCARDDSBRANCHTAGS", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": true, "catalogID": "{2289BD22-A76C-4EB7-BEE1-FE1EEBFE87D3}" }, { "id": 162, "name": "PROPERTYCARD_04_FEATURES", "relatedTableId": 22, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{4A7A014E-E388-4E82-BA69-E4A69FA09EBD}" }, { "id": 156, "name": "PROPERTYCARD_02_OCCUPANCY", "relatedTableId": 20, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{06125BE4-D3A1-4D1D-ABCE-4E46D47C2565}" }, { "id": 160, "name": "PROPERTYCARD_NOTES2", "relatedTableId": 17, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "OBJECTID", "composite": false, "catalogID": "{D3DF0B99-F20A-40E7-9224-B4114860359D}" }, { "id": 4, "name": "WORKFLOWS", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 23, "name": "WORKFLOWS", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 42, "name": "WORKFLOWS", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 61, "name": "WORKFLOWS", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 80, "name": "WORKFLOWS", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 99, "name": "WORKFLOWS", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 118, "name": "WORKFLOWS", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" }, { "id": 137, "name": "WORKFLOWS", "relatedTableId": 7, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "FK_WorkflowID", "composite": true, "catalogID": "{13CF7673-022E-403C-8161-437B5682671A}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "PARCEL", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PARCEL", "type": "esriFieldTypeString", "alias": "PARCEL", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PARCEL" }, { "name": "FK_WorkflowID", "type": "esriFieldTypeInteger", "alias": "FK_WorkflowID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FK_WorkflowID" }, { "name": "FK_OriginCommit", "type": "esriFieldTypeInteger", "alias": "FK_OriginCommit", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FK_OriginCommit" }, { "name": "FK_HeadCommit", "type": "esriFieldTypeInteger", "alias": "FK_HeadCommit", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FK_HeadCommit" }, { "name": "FK_HeadBranch", "type": "esriFieldTypeInteger", "alias": "FK_HeadBranch", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FK_HeadBranch" }, { "name": "ClientUser", "type": "esriFieldTypeString", "alias": "ClientUser", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ClientUser" }, { "name": "ClientDate", "type": "esriFieldTypeDate", "alias": "ClientDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ClientDate" } ], "indexes": [ { "name": "R12_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "I19PARCEL", "isAscending": true, "isUnique": false, "description": "", "fields": "PARCEL" }, { "name": "G19FK_WorkflowID", "isAscending": true, "isUnique": false, "description": "", "fields": "FK_WorkflowID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PROPERTYCARD", "description": "", "prototype": { "attributes": { "ClientUser": null, "ClientDate": null, "PARCEL": null, "FK_WorkflowID": null, "FK_OriginCommit": null, "FK_HeadCommit": null, "FK_HeadBranch": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }