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