| Field | Type | Default | Description |
|---|---|---|---|
| id | int (11) | NOT NULL | PRIMARY KEY - Auto increment field to hold unique ID |
| group_id | char (3) | NOT NULL | Hold the group the the import_export definition is a part of. Current defined groups are: |
| custom | enum (0,1) | 1 | Flag to indicate is this is a standard import/export definition or has been saved and customized for a particular purpose. |
| security | varchar (10) | NOT NULL | Not used at this time |
| title | varchar (32) | NOT NULL | Textual title of the import/export definition. Appears in the description tabs at the Import/Export main page. |
| description | varchar (255) | NOT NULL | Textual descriptio to help identify what the purpose of the import/export definition is. |
| table_name | varchar (32) | NOT NULL | Specifies the default table name without prefix to bas the import/export definition from. |
| primary_key | varchar (32) | NOT NULL | Specifies the primary key from the table_name (above) to use as an index to retrieve data. |
| params | text | Encoded field holds user specific parameters. NOTE: This field should not be edited in the database table. | |
| criteria | text | Encoded field holds user specific criteria. Fields include user defined criteria of which there may be more than one. NOTE: This field should not be edited in the database table. | |
| options | text | Encoded field holds user specific options. Fields such as export format, fielnames, etc. NOTE: This field should not be edited in the database table. |