GoldMine Table Definitions

GoldMine web import forms and GoldMine API programming, Automatic Web Update software

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API

The home of IRCDominatorXT, NETUpdate automatic web update and GMGoldLINK the new GoldMine API

» Home Page
» My Forum
» Email Me
» My Shop

»Affiliate Market«
»Featured Product

»GoldMine«
     »GoldFORM
     »GoldMine API
     »GoldMine Tables
     »Services
     »Downloads

»NETUpdate Suite«
     »Client
     »Admin Part1
     »Admin Part2
     »ActiveX
     »Features
     »News
     »Downloads

»Visual Basic Stuff«
     »CodeSmartX
     »PikLink
     »Links

»Fun Stuff«

Old Projects

»IRCDominatorXT«
     »Latest
     »Known Bugs
     »Using Passport
     »Trouble Shoot
     »Downloads

»Legend Of Mir2«
     »Server Config
     »Converter
     »Browser
     »Other

»Work In Progress«

� Downloads

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

Your IP Address is: 172.70.230.81

Questions Answered

Articles Written

Overall Points

Do you want to
exchange links?
Click on my banner
for more information.

Some people fish in the sea of life with no bait.

Darren Lawrence aka MrEnigma/AbsoluteGenius

GoldMine Table Structures GoldMine 8.5x and Above

GoldMine Table Structures
GoldMine 8.5x and Above