The mapitem table in the onpload database
The mapitem table defines the relationship between the columns of a database table and the record fields of a data file. The table stores pairs of column/record entries. The map options modify this table.
| Column | Type | Description |
|---|---|---|
| formid | INTEGER | Specifies the map to which this record belongs (foreign key to the maps table) |
| seq | INTEGER | Unique identifier for the database-column/data file-record pair |
| colname | VARCHAR(128,0) | Name of database column |
| fname | CHAR(128) | Name of field in a data-file record |