Sprint_Mission_17_FandomK

Tables (7)

Artist

  • artist_id — INT — Primary key — NOT NULL
  • votes — INT

Donation

  • donation_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • project_id — INT — Foreign key → Project.project_id — NOT NULL
  • credit_amount — INT
  • date — DATETIME

Follow

  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • artist_id — INT — Foreign key → Artist.artist_id — NOT NULL
  • followed_date (date) — DATETIME

Project

  • project_id — INT — Primary key — NOT NULL
  • artist_id — INT — Foreign key → Artist.artist_id — NOT NULL
  • title — VARCHAR(50)
  • goal — INT
  • states (status) — INT
  • deadline — DATETIME

Untitled (Credits)

  • Key (transaction_id) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • Field (amount) — INT
  • Field (type) — ENUM('충전','사용')
  • Field (date) — DATETIME

Users

  • user_id — INT — Primary key — NOT NULL
  • credits — INT

Votes

  • idol_id (vote_id) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.user_id — NOT NULL
  • artist_id — INT — Foreign key → Artist.artist_id — NOT NULL
  • votes — INT
  • Field (category) — VARCHAR(50)
  • Field (vote_date) — DATETIME