GoldMine Table Structures.
USERS
DBase Directory Location: ROOT (Always in DBase Format)
Table Description: All usernames, groups, passwords and security settings.
| Table Indexes | |
| Name | DBase Index |
| USERGRUP | UPPER(USERGROUP) |
| USERS | USERNAME |
| USRRECID | RECID |
| Table Relationships | |
| Field | |
| None | |
| Table Fields Structure | |||
| Field Name | Field Type | Length | Description |
| USERNAME | String | 8 | User’s login name. This is referenced from many tables. |
| NAME | String | 26 | Full name/group description |
| USERGROUP | String | 8 | User group membership |
| INGROUPS | String | 20 | - |
| LASTIND | Date | 8 | Last login Date |
| LASTINT | String | 5 | Last login Time |
| LASTOUTD | Date | 8 | Last logout Date |
| LASTOUTT | String | 5 | Last logout Time |
| SOUNDEFFECT | String | 12 | Sound Effect |
| USECURITY | Memo | - | Encrypted security settings – passwords, rights, etc. |
| OPTIONS | String | 10 | Options |
| LASTUSER | String | 8 | Last Modified By |
| LASTDATE | Date | 8 | Last Modified Date |
| LASTTIME | String | 5 | Last Modified Time |
| RECID | String | 15 | Record ID |
LinkedIn