test

Tables (8)

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • prompt_id — BIGINT — Foreign key → prompt.prompt_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • status — ENUM('ACTIVE','DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — idx_comment_status

follow

  • follow_id — BIGINT — Primary key — NOT NULL
  • follower_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • following_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL

likes

  • likes_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • prompt_id — BIGINT — Foreign key → prompt.prompt_id — NOT NULL
  • created_at — DATETIME — NOT NULL

prompt

  • prompt_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • preview — TEXT — NOT NULL
  • thumbnail_url — VARCHAR(500)
  • price — INT — NOT NULL
  • category — ENUM('FRONTEND','BACKEND','AI','DB','ETC') — NOT NULL
  • ai_type — ENUM('GPT4','CLAUDE','GEMINI','ETC') — NOT NULL
  • rating — FLOAT — NOT NULL
  • view_count — INT — NOT NULL
  • status — ENUM('ACTIVE','HIDDEN','DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — idx_prompt_category
  • INDEX — idx_prompt_ai_type
  • INDEX — idx_prompt_status
  • INDEX — idx_prompt_price
  • INDEX — idx_prompt_rating

purchase

  • purchase_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • prompt_id — BIGINT — Foreign key → prompt.prompt_id — NOT NULL
  • paid_price — INT — NOT NULL
  • status — ENUM('PENDING','COMPLETE','CANCEL') — NOT NULL
  • purchased_at — DATETIME — NOT NULL
  • INDEX — idx_purchase_purchased_at
  • INDEX — idx_purchase_status

rating

  • rating_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • prompt_id — BIGINT — Foreign key → prompt.prompt_id — NOT NULL
  • score — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

report

  • report_id — BIGINT — Primary key — NOT NULL
  • reporter_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • target_type — ENUM('PROMPT','COMMENT','USER') — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason — ENUM('SPAM','ABUSE','COPYRIGHT','ETC') — NOT NULL
  • detail — VARCHAR(500)
  • status — ENUM('PENDING','RESOLVED','REJECTED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — idx_report_status

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • role — ENUM('USER','ADMIN') — NOT NULL
  • status — ENUM('ACTIVE','SUSPENDED','DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • INDEX — idx_user_status