Adentra X
Tables (11)
ad_analysis
- analysis_id — BIGINT
- project_id — BIGINT — Foreign key → ad_project.project_id
- predicted_ctr — DECIMAL(5, 2)
- explanation_text — TEXT
- heatmap_url — VARCHAR(255)
- strategy_tag — VARCHAR(50)
- created_at — DATETIME
ad_copy
- copy_id — BIGINT
- project_id — BIGINT — Foreign key → ad_project.project_id
- platform_type — VARCHAR(50)
- tone — VARCHAR(50)
- copy_text — TEXT
- ai_rationale — TEXT
- is_selected — TINYINT(1)
- created_at — DATETIME
ad_image
- image_id — BIGINT
- project_id — BIGINT — Foreign key → ad_project.project_id
- image_url — VARCHAR(255)
- style — VARCHAR(50)
- optimization_guide — TEXT
- is_selected — TINYINT(1)
- created_at — DATETIME
ad_mascot
- mascot_id — BIGINT
- project_id — BIGINT — Foreign key → ad_project.project_id
- mascot_name — VARCHAR(50)
- personality — VARCHAR(100)
- description — TEXT
- role_description — TEXT
- is_selected — TINYINT(1)
ad_project
- project_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id
- project_name — VARCHAR(100)
- ad_goal — VARCHAR(50)
- industry — VARCHAR(50)
- brand_name — VARCHAR(50)
- target_age — VARCHAR(50)
- target_gender — VARCHAR(10)
- platform_env — VARCHAR(50)
- status — VARCHAR(20)
- current_step — INT
- created_at — DATETIME
ad_simulation
- simulation_id — BIGINT
- project_id — BIGINT — Foreign key → ad_project.project_id
- current_strategy — VARCHAR(50)
- alternative_strategy — VARCHAR(50)
- expected_ctr_lift — DECIMAL(5, 2)
- simulation_report — TEXT
- created_at — DATETIME
ad_title
- title_id — BIGINT
- project_id — BIGINT — Foreign key → ad_project.project_id
- title_text — VARCHAR(255)
- ai_rationale — TEXT
- is_selected — TINYINT(1)
- created_at — DATETIME
admin
- admin_id — BIGINT
- email — VARCHAR(100)
- password — VARCHAR(255)
- role — VARCHAR(50)
- created_at — DATETIME
final_ad
- final_ad_id — BIGINT
- project_id — BIGINT — Foreign key → ad_project.project_id
- title_id — BIGINT — Foreign key → ad_title.title_id
- mascot_id — BIGINT — Foreign key → ad_mascot.mascot_id
- copy_id — BIGINT — Foreign key → ad_copy.copy_id
- image_id — BIGINT — Foreign key → ad_image.image_id
- shortform_id — BIGINT — Foreign key → shortform_builder.shortform_id
- created_at — DATETIME
shortform_builder
- shortform_id — BIGINT
- project_id — BIGINT — Foreign key → ad_project.project_id
- platform_target — VARCHAR(50)
- video_ratio — VARCHAR(20)
- storyboard_json — JSON
- bgm_recommendation — VARCHAR(100)
- total_duration — INT
- created_at — DATETIME
users
- user_id — BIGINT
- email — VARCHAR(100)
- nickname — VARCHAR(50)
- created_at — DATETIME