|
id
|
int(11)
|
|
|
|
|
table_id
|
int(11)
|
|
|
|
|
orig_header
|
varchar(255)
|
utf8_general_ci
|
|
|
|
display_header
|
varchar(255)
|
utf8_general_ci
|
|
|
|
filter_type
|
enum('none', 'null_str', 'text', 'number', 'number-range', 'date-range', 'datetime-range', 'time-range', 'select', 'checkbox')
|
utf8_general_ci
|
|
|
|
column_type
|
enum('autodetect', 'string', 'int', 'float', 'date', 'link', 'email', 'image', 'formula', 'datetime', 'time')
|
utf8_general_ci
|
|
|
|
input_type
|
enum('none', 'text', 'textarea', 'mce-editor', 'date', 'datetime', 'time', 'link', 'email', 'selectbox', 'multi-selectbox', 'attachment')
|
utf8_general_ci
|
|
|
|
input_mandatory
|
tinyint(1)
|
|
|
|
|
id_column
|
tinyint(1)
|
|
|
|
|
group_column
|
tinyint(1)
|
|
|
|
|
sort_column
|
tinyint(1)
|
|
|
|
|
hide_on_phones
|
tinyint(1)
|
|
|
|
|
hide_on_tablets
|
tinyint(1)
|
|
|
|
|
visible
|
tinyint(1)
|
|
|
|
|
sum_column
|
tinyint(1)
|
|
|
|
|
skip_thousands_separator
|
tinyint(1)
|
|
|
|
|
width
|
varchar(4)
|
utf8_general_ci
|
|
|
|
possible_values
|
text
|
utf8_general_ci
|
|
|
|
default_value
|
varchar(100)
|
utf8_general_ci
|
|
|
|
css_class
|
varchar(255)
|
utf8_general_ci
|
|
|
|
text_before
|
varchar(255)
|
utf8_general_ci
|
|
|
|
text_after
|
varchar(255)
|
utf8_general_ci
|
|
|
|
formatting_rules
|
text
|
utf8_general_ci
|
|
|
|
calc_formula
|
text
|
utf8_general_ci
|
|
|
|
color
|
varchar(255)
|
utf8_general_ci
|
|
|
|
advanced_settings
|
text
|
utf8_general_ci
|
|
|
|
pos
|
int(11)
|
|
|
|
