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