{ "currentVersion": 10.91, "id": 3, "name": "Mobile_CAMA.DBO.v_gis_cama_mobile_sections", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "last_chg_login", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "last_chg_login", "type": "esriFieldTypeString", "alias": "last_chg_login", "length": 28, "domain": null }, { "name": "last_chg_datetime", "type": "esriFieldTypeDate", "alias": "last_chg_datetime", "length": 8, "domain": null }, { "name": "parcel_number", "type": "esriFieldTypeString", "alias": "parcel_number", "length": 20, "domain": null }, { "name": "parcel_year", "type": "esriFieldTypeInteger", "alias": "parcel_year", "domain": null }, { "name": "structure_id", "type": "esriFieldTypeInteger", "alias": "structure_id", "domain": null }, { "name": "section_id", "type": "esriFieldTypeInteger", "alias": "section_id", "domain": null }, { "name": "improvement_number", "type": "esriFieldTypeInteger", "alias": "improvement_number", "domain": null }, { "name": "construction_type", "type": "esriFieldTypeString", "alias": "construction_type", "length": 10, "domain": null }, { "name": "section_desc", "type": "esriFieldTypeString", "alias": "section_desc", "length": 100, "domain": null }, { "name": "sq_ft_per_floor", "type": "esriFieldTypeInteger", "alias": "sq_ft_per_floor", "domain": null }, { "name": "number_of_levels_section", "type": "esriFieldTypeDouble", "alias": "number_of_levels_section", "domain": null }, { "name": "number_of_levels_building", "type": "esriFieldTypeDouble", "alias": "number_of_levels_building", "domain": null }, { "name": "perimeter", "type": "esriFieldTypeInteger", "alias": "perimeter", "domain": null }, { "name": "shape", "type": "esriFieldTypeString", "alias": "shape", "length": 10, "domain": null }, { "name": "effective_age", "type": "esriFieldTypeInteger", "alias": "effective_age", "domain": null }, { "name": "base_date", "type": "esriFieldTypeDate", "alias": "base_date", "length": 8, "domain": null }, { "name": "depreciation_id", "type": "esriFieldTypeInteger", "alias": "depreciation_id", "domain": null }, { "name": "lower_level_height", "type": "esriFieldTypeDouble", "alias": "lower_level_height", "domain": null }, { "name": "main_level_height", "type": "esriFieldTypeDouble", "alias": "main_level_height", "domain": null }, { "name": "upper_level_height", "type": "esriFieldTypeDouble", "alias": "upper_level_height", "domain": null }, { "name": "market_adjustment", "type": "esriFieldTypeDouble", "alias": "market_adjustment", "domain": null }, { "name": "identical_buildings", "type": "esriFieldTypeDouble", "alias": "identical_buildings", "domain": null }, { "name": "orig_section_id", "type": "esriFieldTypeInteger", "alias": "orig_section_id", "domain": null }, { "name": "orig_structure_id", "type": "esriFieldTypeInteger", "alias": "orig_structure_id", "domain": null }, { "name": "transfer_id", "type": "esriFieldTypeInteger", "alias": "transfer_id", "domain": null }, { "name": "transfer_structure_id", "type": "esriFieldTypeInteger", "alias": "transfer_structure_id", "domain": null }, { "name": "transfer_section_id", "type": "esriFieldTypeInteger", "alias": "transfer_section_id", "domain": null }, { "name": "section_id_for_roll", "type": "esriFieldTypeInteger", "alias": "section_id_for_roll", "domain": null }, { "name": "assignment_id", "type": "esriFieldTypeInteger", "alias": "assignment_id", "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 }, { "name": "delete_flag", "type": "esriFieldTypeInteger", "alias": "delete_flag", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_23", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G14structure_id", "fields": "structure_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G14section_id", "fields": "section_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_23", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "v_gis_cama_mobile_section_attributes", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "section_id", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "v_gis_cama_mobile_structures", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "structure_id", "cardinality": "esriRelCardinalityOneToMany", "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 }