ExplainAD Studio

Tables (7)

ad_copy

  • copy_id — BIGINT
  • project_id — BIGINT — Foreign key → ad_project.project_id
  • platform_type — VARCHAR(50)
  • tone — VARCHAR(50)
  • copy_text — TEXT
  • is_selected — BOOLEAN
  • created_at — DATETIME

ad_image

  • image_id — BIGINT
  • project_id — BIGINT — Foreign key → ad_project.project_id
  • image_url — VARCHAR(255)
  • style — VARCHAR(50)
  • is_selected — BOOLEAN
  • 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
  • is_selected — BOOLEAN

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)
  • status — VARCHAR(20)
  • created_at — DATETIME

ad_title

  • title_id — BIGINT
  • project_id — BIGINT — Foreign key → ad_project.project_id
  • title_text — VARCHAR(255)
  • is_selected — BOOLEAN
  • 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
  • created_at — DATETIME

users

  • user_id — BIGINT
  • email — VARCHAR(100)
  • nickname — VARCHAR(50)
  • created_at — DATETIME