id | int(11) |
|
|
|
table_id | int(11) |
|
|
|
orig_header | varchar(255) |
|
|
|
display_header | varchar(255) |
|
|
|
filter_type | enum | -- |
|
|
column_type | enum | -- |
|
|
input_type | enum | -- |
|
text
|
input_mandatory | tinyint(1) |
|
|
0
|
id_column | tinyint(1) |
|
|
0
|
group_column | tinyint(1) |
|
|
0
|
sort_column | tinyint(1) |
|
|
0
|
hide_on_phones | tinyint(1) |
|
|
0
|
hide_on_tablets | tinyint(1) |
|
|
0
|
visible | tinyint(1) |
|
|
1
|
sum_column | tinyint(1) |
|
|
0
|
skip_thousands_separator | tinyint(1) |
|
|
0
|
width | varchar(4) |
|
|
|
possible_values | text |
|
|
|
default_value | varchar(100) |
|
|
|
css_class | varchar(255) |
|
|
|
text_before | varchar(255) |
|
|
|
text_after | varchar(255) |
|
|
|
formatting_rules | text |
|
|
|
calc_formula | text |
|
|
|
color | varchar(255) |
|
|
|
advanced_settings | text |
|
|
|
pos | int(11) |
|
|
0
|