{ "currentVersion": 10.91, "id": 17, "name": "EasyProjects.dbo.TT_Users", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "AccountId", "type": "esriFieldTypeInteger", "alias": "AccountId", "domain": null }, { "name": "UserID", "type": "esriFieldTypeInteger", "alias": "UserID", "domain": null }, { "name": "RoleID", "type": "esriFieldTypeInteger", "alias": "RoleID", "domain": null }, { "name": "Login", "type": "esriFieldTypeString", "alias": "Login", "length": 255, "domain": null }, { "name": "Password", "type": "esriFieldTypeString", "alias": "Password", "length": 50, "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "CustomerID", "type": "esriFieldTypeInteger", "alias": "CustomerID", "domain": null }, { "name": "EMail", "type": "esriFieldTypeString", "alias": "EMail", "length": 255, "domain": null }, { "name": "Enabled", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": null }, { "name": "HourlyRate", "type": "esriFieldTypeDouble", "alias": "HourlyRate", "domain": null }, { "name": "ShowCompletedTasks", "type": "esriFieldTypeSmallInteger", "alias": "ShowCompletedTasks", "domain": null }, { "name": "ShowCompletedProjects", "type": "esriFieldTypeSmallInteger", "alias": "ShowCompletedProjects", "domain": null }, { "name": "RecoverConfirmCode", "type": "esriFieldTypeString", "alias": "RecoverConfirmCode", "length": 1073741822, "domain": null }, { "name": "CanLogin", "type": "esriFieldTypeSmallInteger", "alias": "CanLogin", "domain": null }, { "name": "ShowAvatars", "type": "esriFieldTypeSmallInteger", "alias": "ShowAvatars", "domain": null }, { "name": "Avatar", "type": "esriFieldTypeBlob", "alias": "Avatar", "domain": null }, { "name": "ShowCompletedPortfolios", "type": "esriFieldTypeSmallInteger", "alias": "ShowCompletedPortfolios", "domain": null }, { "name": "IsAvatarEmpty", "type": "esriFieldTypeSmallInteger", "alias": "IsAvatarEmpty", "domain": null }, { "name": "AvatarHash", "type": "esriFieldTypeString", "alias": "AvatarHash", "length": 32, "domain": null }, { "name": "DefaultPage", "type": "esriFieldTypeString", "alias": "DefaultPage", "length": 50, "domain": null }, { "name": "LastActivityDate", "type": "esriFieldTypeDate", "alias": "LastActivityDate", "length": 8, "domain": null }, { "name": "PasswordModifyDate", "type": "esriFieldTypeDate", "alias": "PasswordModifyDate", "length": 8, "domain": null }, { "name": "InvalidPasswordAttemptsCount", "type": "esriFieldTypeInteger", "alias": "InvalidPasswordAttemptsCount", "domain": null }, { "name": "LastLockoutDate", "type": "esriFieldTypeDate", "alias": "LastLockoutDate", "length": 8, "domain": null }, { "name": "PresetID", "type": "esriFieldTypeInteger", "alias": "PresetID", "domain": null }, { "name": "IsWelcomeMailWasSent", "type": "esriFieldTypeSmallInteger", "alias": "IsWelcomeMailWasSent", "domain": null }, { "name": "HourlyRateInternal", "type": "esriFieldTypeDouble", "alias": "HourlyRateInternal", "domain": null }, { "name": "TimeZoneOffset", "type": "esriFieldTypeInteger", "alias": "TimeZoneOffset", "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "IsDistributeHours", "type": "esriFieldTypeSmallInteger", "alias": "IsDistributeHours", "domain": null }, { "name": "IsExpandAssigneeWindow", "type": "esriFieldTypeSmallInteger", "alias": "IsExpandAssigneeWindow", "domain": null }, { "name": "IsAutoFollowEnabled", "type": "esriFieldTypeSmallInteger", "alias": "IsAutoFollowEnabled", "domain": null }, { "name": "LoginEnabledDate", "type": "esriFieldTypeDate", "alias": "LoginEnabledDate", "length": 8, "domain": null }, { "name": "LastModificationDate", "type": "esriFieldTypeDate", "alias": "LastModificationDate", "length": 8, "domain": null }, { "name": "AuthVersion", "type": "esriFieldTypeDate", "alias": "AuthVersion", "length": 8, "domain": null }, { "name": "PasswordSalt", "type": "esriFieldTypeString", "alias": "PasswordSalt", "length": 255, "domain": null }, { "name": "IsPasswordGenerated", "type": "esriFieldTypeSmallInteger", "alias": "IsPasswordGenerated", "domain": null }, { "name": "IsOnboardingPassed", "type": "esriFieldTypeSmallInteger", "alias": "IsOnboardingPassed", "domain": null }, { "name": "IsThumbnailAvatar", "type": "esriFieldTypeSmallInteger", "alias": "IsThumbnailAvatar", "domain": null }, { "name": "CustomFields", "type": "esriFieldTypeString", "alias": "CustomFields", "length": 1073741822, "domain": null }, { "name": "AutoFollowTaskCreation", "type": "esriFieldTypeSmallInteger", "alias": "AutoFollowTaskCreation", "domain": null }, { "name": "AutoFollowAssignments", "type": "esriFieldTypeSmallInteger", "alias": "AutoFollowAssignments", "domain": null }, { "name": "AutoFollowMessageCreation", "type": "esriFieldTypeSmallInteger", "alias": "AutoFollowMessageCreation", "domain": null }, { "name": "AutoFollowMentions", "type": "esriFieldTypeSmallInteger", "alias": "AutoFollowMentions", "domain": null }, { "name": "DefaultWorkflowId", "type": "esriFieldTypeInteger", "alias": "DefaultWorkflowId", "domain": null }, { "name": "JobRoleId", "type": "esriFieldTypeInteger", "alias": "JobRoleId", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R75_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_75", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "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 }