| DB | Areas | X-idx | Tables | Sequences | <- _TxeLock | _UserIndexStat -> | HtmlDict 11 |
| Area | Schema Area |
|---|---|
| Dumpname | ? |
| Label | ? |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 18 | _Account_expires | X | Account_expires | datetime-tz | 99/99/9999 HH:MM:SS.SSS+HH:MM | ? | ||
| 17 | _Create_date | X | Create_date | datetime-tz | 99/99/9999 HH:MM:SS.SSS+HH:MM | ? | ||
| 15 | _Description | X | Description | character | x(64) | ? | ||
| 16 | _Disabled | X | Disabled | logical | yes/no | ? | ||
| 31 | _Domain-Name | X | Domain-Name | character | X(64) | |||
| 14 | _Email | X | character | x(50) | ? | |||
| 10 | _Given_name | X | Given_name | character | x(25) | ? | ||
| 9 | _Group_number | X | Group_number | integer | >>>>>>9 | ? | ||
| 21 | _Last_login | X | Last_login | datetime-tz | 99/99/9999 HH:MM:SS.SSS+HH:MM | ? | ||
| 22 | _Logins | X | Logins | integer | >>>>>>9 | ? | ||
| 25 | _Login_failures | X | Login_failures | integer | >>>>>>9 | ? | ||
| 23 | _Max_logins | X | Max_logins | integer | >>>>>>9 | ? | ||
| 24 | _Max_tries | X | Max_tries | integer | >>>>>>9 | ? | ||
| 11 | _Middle_initial | X | Middle_initial | character | x(1) | ? | ||
| 3 | _Password | X | Password | character | x(16) | ? | ||
| 20 | _Pwd_duration | X | Pwd_duration | integer | >>>>>>9 | ? | ||
| 19 | _Pwd_expires | X | Pwd_expires | datetime-tz | 99/99/9999 HH:MM:SS.SSS+HH:MM | ? | ||
| 26 | _Spare1 | X | Spare1 | integer | >>>>>>9 | ? | ||
| 27 | _Spare2 | X | Spare2 | integer | >>>>>>9 | ? | ||
| 28 | _Spare3 | X | Spare3 | character | x(1) | ? | ||
| 29 | _Spare4 | X | Spare4 | character | x(1) | ? | ||
| 32 | _sql-only-user | X | sql-only-user | logical | yes/no | no | ||
| 12 | _Surname | X | Surname | character | x(25) | ? | ||
| 13 | _Telephone | X | Telephone | character | x(20) | ? | ||
| 30 | _TenantId | X | TenantId | integer | ->>>>9 | 0 | ||
| 5 | _U-misc1 | X | ? | integer [8] | >>>>9 | ? | ||
| 6 | _U-misc2 | X | ? | character [8] | x(8) | ? | ||
| 7 | _User-Misc | X | User-Misc | character | x(10) | ? | ||
| 4 | _User-Name | X | User-Name | character | x(40) | |||
| 2 | _Userid | X | Userid | character | x(12) | ? | ||
| 8 | _User_number | X | User_number | integer | >>>>>>9 | ? |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| _Userid | P U | _Userid (+) | character |
| _Domain-Name (+) | character | ||
| _User-domain-name | _Domain-Name (+) | character | |
| _sql-only-user (+) | logical | ||
| _Userid (+) | character | ||
| _User-sql-only-user | _sql-only-user (+) | logical |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| generated 3-3-2025 10:55 |