GoldMine Table Structures.
INFOMINE
DBase Directory Location: GMBASE
Table Description: InfoCenter file—stores all data for the InfoCenter
Table Indexes | |||
Name | DBase Index | SQL Index | ID |
INFOMINE | UPPER(RECTYPE+LEFT(TSECTION,80)+LEFT(TOPIC,10) | RECTYPE+U_TSECTION+U_TOPIC | 57 |
INFOSORT | SORTKEY | SORTKEY | 58 |
INFOTRAN | RECTYPE+RECID | RECTYPE+RECID | 59 |
INFRECID | RECID | RECID | 60 |
Table Relationships | |
Field | |
None |
Table Fields Structure | |||
Field Name | Field Type | Length | Description |
ACCOUNTNO | String | 20 | Account Number of contact if linked |
CREATEBY | String | 8 | Creation User |
RECTYPE | String | 10 | Record Type (‘IO1’=Global, ‘P0’Username=Private to specified user) |
SORTKEY | String | 20 | Unique Sort Key. Formatted as date and time the record was created |
TSECTION | String | 100 | Section |
TOPIC | String | 80 | Topic |
KEYWORDS | String | 80 | Keywords |
OPTIONS | String | 10 | Options |
OPTIONS1 | String | 20 | Options1 |
OPTIONS2 | String | 20 | Options2 |
LINKEDDOC | Memo | - | Several parameters, each separated by two tildes (~~) before and a line feed (ASCII 10) after. Parameters include: SYNC={0/1 –
No/Yes}, CREATETIME=YYYYMMDDHHMMSS, FILENAME={Full path of directory and linked file name}. |
NOTES | Memo | - | Notes (formatted as RTF) |
USERREAD | String | 8 | User/Group with read access (Blank=Public) |
USERWRITE | String | 8 | User/Group with write access (Blank=Public) |
LASTUSER | String | 8 | Last Modified By |
LASTDATE | Date | - | Last Modified Date |
LASTTIME | String | 5 | Last Modified Time |
U_TSECTION | String | 100 | Upper-case shadow of Section (SQL Only) |
U_TOPIC | String | 80 | Upper-case shadow of Topic (SQL Only) |
RECID | String | 15 | Record ID |