Database Schema (3 Tables)

admin

May 31, 2026

0 views

`ewb_ai_email_templates`

Column	Type	Nullable
`template_id`	false
`name`	false
`identifier`	false
`email_type`	false
`magento_template_code`	true
`prompt`	false
`html_content`	false
`original_html`	true
`plain_text_content`	true
`styles`	true
`subject`	true
`variant_group`	true
`variant_label`	true
`is_active_variant`	false
`variant_sends`	false
`variant_opens`	false
`variant_clicks`	false
`variant_open_rate`	false
`variant_click_rate`	false
`brand_primary_color`	true
`brand_secondary_color`	true
`brand_accent_color`	true
`brand_font`	true
`brand_logo_url`	true
`social_links`	true
`ai_provider`	true
`ai_model`	true
`ai_tokens_used`	true
`ai_generation_time`	true
`is_responsive`	false
`is_active`	false
`is_assigned`	false
`store_id`	false
`test_results`	true
`screenshot_source`	true
`editor_state`	true
`tags`	true
`version`	false
`created_at`	false
`updated_at`	false

`ewb_ai_email_template_versions`

Column	Type	Nullable
`version_id`	false
`template_id`	false
`version`	false
`html_content`	false
`prompt`	true
`change_description`	true
`created_by`	true
`created_at`	false

`ewb_ai_email_prompt_presets`

Column	Type	Nullable
`preset_id`	false
`name`	false
`email_type`	false
`prompt_template`	false
`category`	true
`style`	true
`preview_image`	true
`is_system`	false
`is_active`	false
`sort_order`	false
`created_at`	false