TruGOLDCRM Consulting

Finding Gold with your CRM

Google


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

Your IP Address is: 54.158.253.134