ExplainAD Studio2
Tables (8)
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 — 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)
- 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
- 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)
- 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 — 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
- created_at — DATETIME
users
- user_id — BIGINT
- email — VARCHAR(100)
- nickname — VARCHAR(50)
- created_at — DATETIME