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 |
LinkedIn