GoldMine Table Structures
GoldMine 8.5x and Above

NOTE: I am currently in the process of updating these, I have made some changes but I have basically copied the original details for the time being and will update each table where required and highlight the differences in RED

Detailed here are the GoldMine tables and Indexes and field definitions for GoldMine 8.5x and Above. This information has been obtained from a number of places and from my own use of GoldMine

It is important to note that writing directly to any of these tables is not supported by FrontRange Solutions (GoldMine). You risk data corruption and at best you will lose all synchronization information for these changes you make. To safely update GoldMine’s database, you should use the API specifications that GoldMine provides to update their tables.

GoldMine Data Table Name
Additional Contacts and Other Records ContSupp
Alert Definitions InfoMine
Assigned Alerts ContSupp
Automated Processes (Assigned) ContSupp
Automated Processes (Definitions) Tracks
Completed Appointments, Calls, To-Dos, Actions ContHist
Contact Groups ContGrps
Primary Contact Information Contact1
Secondary Contact Information Contact2
Custom Data Fields Contact2
Custom Field Definitions ContUDef
Custom Field Layouts Fields5
Details Records / Profiles ContSupp
Details/Profiles Header Definitions ContSupp
E-Mail Addresses ContSupp
E-Mails (sent, received / Filed) MailBox
Filters and Queries Filters
InfoCenter InfoMine
Lead analysis files LeadDbfs
Linked Documents ContSupp
F2 Lookups LookUp
Merge Documents Forms
Information about fields in merge forms. Formsfld
Queue of mail-merged documents waiting to be sent. FormsQue
Opportunities/Projects OpMgr
OpMgrFld
Organizational Tree ContSupp
Pending Appointments, Calls, To-Dos, Actions Cal
Personal Rolodex PerPhone
Referrals ContSupp
Reports Report32
Resources ResItems
Synchronization Settings GSServer
GSSites
Web Addresses ContSupp
   
GoldMine Premium 8.x Table Name
Contacts Notes Notes
Service Centre Cases
   
GoldMine Premium 9.x Table Name
   
   
GoldMine Misc Tables and Logs Table Name
Database Locations SPFiles
Script definitions. Scriptsw
Saved Import/Export profiles for all databases. ImpExp
System log Syslog
Log file of user logins Userlog
Synchronization Records
(changes, deletes)
ContTLog
GMTLog
GSLogs
Character set Information for installation CharSet
Field names dictionary Datadict
Logged In users flags Flags
Licensing Information License
Locking table used in synchronizations. Synclock
network synchronization. Synctask
Usernames and Settings Users
   
GoldMine Table Relationships