TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

Please go here for GoldMine Premium Specific Tables

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

Your IP Address is: 54.145.16.43