GoldMine Table Structures.
DATADICT
DBase Directory Location: ROOT (Always in DBase Format)
Table Description: Contains field names, types and sizes for all GoldMine tables. Do not edit this file!
| Table Indexes | |||
| Name | DBase Index | SQL Index | ID |
| DATADICT | DBFNAME+FIELD_NAME | - | |
| Table Relationships |
| Field |
| None |
| Table Fields Structure | |||
| Field Name | Field Type | Length | Description |
| DBFNAME | String | 8 | Table name (from any directory/database) |
| FIELD_NAME | String | 10 | Field name in table |
| FIELD_TYPE | String | 1 | Type of field ((C)haracter, (D)ate, (N)umber, (M)emo) |
| FIELD_LEN | Double | 8 | Fields Storage Length |
| FIELD_DEC | Double | 8 | Number of decimals (relevant to numbers only) |
| FIELD_FLAG | String | 3 | - |
| FIELDDESC | String | 25 | Description of field |
| RECID | String | 90 | Character set information |
LinkedIn