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 |