| id |
int(11)
|
|
|
|
| brand_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| brand_subtitle |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| logo_text |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| light_body_bg |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| light_surface |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| light_surface_alt |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| light_sidebar |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| light_sidebar_text |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| light_header |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| light_text |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| light_muted |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| light_accent |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| light_accent_soft |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| light_border |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| dark_body_bg |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| dark_surface |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| dark_surface_alt |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| dark_sidebar |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| dark_sidebar_text |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| dark_header |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| dark_text |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| dark_muted |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| dark_accent |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| dark_accent_soft |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| dark_border |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| font_heading |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| font_body |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| base_font_size |
tinyint(3)
|
|
|
|
| heading_scale |
decimal(3,2)
|
|
|
|
| radius |
tinyint(3)
|
|
|
|
| layout_gap |
tinyint(3)
|
|
|
|
| card_shadow |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| site_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| site_tagline |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| hero_title |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| hero_subtitle |
text
|
utf8mb4_general_ci
|
|
|
| accent_color |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| accent_color_2 |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| surface_tint |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| default_theme |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| site_logo_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| show_dashboard |
tinyint(1)
|
|
|
|
| show_vehicles |
tinyint(1)
|
|
|
|
| show_parts |
tinyint(1)
|
|
|
|
| show_quotes |
tinyint(1)
|
|
|
|
| show_purchases |
tinyint(1)
|
|
|
|
| show_reports |
tinyint(1)
|
|
|
|
| show_invoice_studio |
tinyint(1)
|
|
|
|
| show_custom_fields |
tinyint(1)
|
|
|
|
| show_site_settings |
tinyint(1)
|
|
|
|
| hero_card_1 |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| hero_card_2 |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| hero_card_3 |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| short_name |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| tagline |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| logo_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| primary_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| secondary_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| footer_text |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| show_dashboard_stats |
tinyint(1)
|
|
|
|
| show_quick_actions |
tinyint(1)
|
|
|
|
| show_stock_alerts |
tinyint(1)
|
|
|
|
| show_recent_quotes |
tinyint(1)
|
|
|
|
| show_recent_purchases |
tinyint(1)
|
|
|
|
| show_recent_sales |
tinyint(1)
|
|
|
|
| sidebar_collapsed |
tinyint(1)
|
|
|
|
| sidebar_text_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| sidebar_muted_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| page_text_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| page_soft_text_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| layout_json |
longtext
|
utf8mb4_general_ci
|
|
|
| home_sections |
longtext
|
utf8mb4_general_ci
|
|
|
| page_bg_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| panel_bg_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| card_bg_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| card_border_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| header_bg_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| header_text_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| sidebar_bg_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| sidebar_active_bg_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| sidebar_icon_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| heading_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| icon_bg_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| icon_text_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| footer_bg_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| footer_text_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| font_family_heading |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| font_family_body |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| font_size_base |
int(11)
|
|
|
|
| font_size_small |
int(11)
|
|
|
|
| font_size_title |
int(11)
|
|
|
|
| page_surface_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| panel_border_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| topbar_bg_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| heading_text_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| logo_bg_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| logo_text_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| button_text_color |
char(7)
|
utf8mb4_general_ci
|
|
|
| font_heading_site |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| font_body_site |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| font_ui_site |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| font_size_h1 |
smallint(6)
|
|
|
|
| font_size_h2 |
smallint(6)
|
|
|
|
| font_size_h3 |
smallint(6)
|
|
|
|
| radius_scale |
smallint(6)
|
|
|
|
| site_description |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| color_background |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| color_surface |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| color_card |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| color_button |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| color_button_text |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| color_text |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| color_heading |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| color_icon |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| color_border |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| font_family |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| radius_md |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| theme_default |
varchar(10)
|
utf8mb4_general_ci
|
|
|
| show_dashboard_summary |
tinyint(1)
|
|
|
|
| show_low_stock |
tinyint(1)
|
|
|
|
