Start typing to search...
Home Magento 2 Ai Email Template Designer Database Schema (3 Tables)

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
Documentation Assistant
Hi! I'm your documentation assistant. Ask me anything and I'll search our docs for you.