Field |
Type |
Default |
Description |
configuration_id |
int (11) |
NOT NULL |
PRIMARY KEY - Auto-increment number for record id. |
configuration_title | text | NOT NULL | The title used in the Company -> {category} listing as seen by the user. |
configuration_key | varchar (255) | NOT NULL | UNIQUE
- This field defines a constant load with every page and used through
most of the scripts. The syntax is all uppercase with underscores to
separate words. |
configuration_value | text | NOT NULL | The value assigned to the constant |
configuration_description | text | NOT NULL | The description used to help the user set the value of the constant. |
configuration_group_id | int (11) | 0 | INDEX - Maps to the configuration_group table to help organize the configuration constants. |
sort_order | int (5) | | Defines the order for which the configuration item appears in the listing by group. |
last_modified | datetime | NULL | Date the record was last modified. |
date_added | datetime | 0000-00-00 00:00:00 | Date the configuration constant was added to the table. |
use_function | text | | Defines the function to use when displaying the configuration constant. |
set_function | text | | Defines
the function to use to format the input field of the configuration
value. This can be to restrict the choices (pull-down menu) or map
textual descriptions to sytem values. |