Return Home  
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

Hot Links

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

Site Menu

»Affiliate Market«
     »Featured Product

     »GoldMine API
     »GoldMine Tables

»NETUpdate Suite«
     »Admin Part1
     »Admin Part2
»Visual Basic Stuff«

»Fun Stuff«

Old Projects
     »Known Bugs
     »Using Passport
     »Trouble Shoot
»Legend Of Mir2«
     »Server Config

»Work In Progress«



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
Organizational Tree ContSupp
Pending Appointments, Calls, To-Dos, Actions Cal
Personal Rolodex PerPhone
Referrals ContSupp
Reports Report32
Resources ResItems
Synchronization Settings GSServer
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)
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:

Experts Exchange
Questions Answered
Overall Points
Exchange Links
Do you want to
exchange links?
Click on my banner
for more information.

EnigmaWare Products - Home of IRCDominatorXT

I thought I wanted a career, turns out I just wanted paychecks.


Other great places to visit
Silver Sphere Designs
VPOP3 Mail Server Software  

  This site is copyright © 2005 EnigmaWare Software Inc - Darren Lawrence aka MrEnigma/AbsoluteGenius