Table configuration

Table configuration holds constants used throughout PhreeBooks. They are grouped by the field configuration_group_id with table configuration_group to separate the constants into user defined groupings. Some group id's are hidden to the user as they are used by add-on modules for shipping, payments, etc.

Table Type: MyISAM

Field Type Default Description
configuration_id int (11) NOT NULL PRIMARY KEY - Auto-increment number for record id.
configuration_titletextNOT NULLThe title used in the Company -> {category} listing as seen by the user.
configuration_keyvarchar (255)NOT NULLUNIQUE - 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_valuetextNOT NULLThe value assigned to the constant
configuration_descriptiontextNOT NULLThe description used to help the user set the value of the constant.
configuration_group_idint (11)0INDEX - Maps to the configuration_group table to help organize the configuration constants.
sort_orderint (5)Defines the order for which the configuration item appears in the listing by group.
last_modifieddatetimeNULLDate the record was last modified.
date_addeddatetime0000-00-00 00:00:00Date the configuration constant was added to the table.
use_functiontextDefines the function to use when displaying the configuration constant.
set_functiontextDefines 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.