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

MAILBOX

DBase Directory Location: GMBASE
Table Description: Lookup file – contains a record for each defined look-up entry

Table Indexes
Name	DBase Index	SQL Index	ID
MBOXLINK	LINKRECID	LINKRECID	77
MBOXUSER	USERID+FOLDER+FOLDER2+DTOS(MAILDATE)	USERID+FOLDER+FOLDER2+MAILDATE	78
MBOXACCT	ACCOUNTNO	ACCOUNTNO	79
MBXRECID	RECID	RECID	80

Table Relationships
Field	Related Table to Field	Type	Notes
RecID	Cal->LinkRecID	1-1	E-mails still in inbox or waiting to be sent
LinkRecID	Cal->RecID	1-1	E-mails still in inbox or waiting to be sent
LinkRecID	ContHist->RecID	1-1	Filed, sent or otherwise completed e-mails
LopRecID	OpMgr->RecID	M-1	Records related to opportunities/projects
AccountNo	Contact1->AccountNo	M-1	Linked e-mails, does not include folder records in Mailbox.

Table Fields Structure

LINKRECID

String

Linked Record ID (from Cal or ContHist RecID)

FLAGS

String

The Flags field is a String type, but actually stores a number. When the number is converted to binary, the following rules apply:

Bit	On	Off
1	Read	Not Read
2	In History	Not In History
3	OutBound	InBound
4	Attachment	No Attachments
5	Redirect
6	As Links
7	ICAL Marker
8	Signed	Not Signed
9	Encrypted	Not Encrypted

USERID

String

User Name

FOLDER

String

The Folder field contains the name of the folder in which mail is stored.
GoldMine uses the following predefined folders
    X-GM-INBOX -Inbox
    X-GM-OUTBOX -Outbox
    X-GM-TEMPLATES -Templates

FOLDER2

String

Subfolder

ACCOUNTNO

String

Account Number of linked contact. If '--' and the record is an Email then the email was linked but then subsequently unlinked

CREATEON

Date

Creation Date

MAILSIZE

String

Mail size in bytes