Fandom-KKK

Tables (9)

Artists

  • artist_id — INT
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • description — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

Credits

  • credit_id — INT
  • user_id — INT — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

DonationGoals

  • goal_id — INT
  • artist_id — INT — NOT NULL
  • target_amount — DECIMAL(10, 2) — NOT NULL
  • current_credit — DECIMAL(10, 2)
  • deadline — DATE — NOT NULL
  • situation — ENUM('진행 중', '달성 완료') — NOT NULL

Donations

  • donation_id — INT
  • user_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

Events

  • event_id — INT
  • event_name — VARCHAR(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • location — VARCHAR(255)

Follows

  • follow_id — INT
  • user_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • UNIQUE(user_id, — artist_id)

Users

  • user_id — INT
  • username — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

Votes

  • vote_id — INT
  • user_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • category — ENUM('솔로', '그룹', '기타') — NOT NULL
  • vote_count — DECIMAL(10, 2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

favorite_artists

  • favorite_id — INT
  • user_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • category — ENUM('최애', '차애', '기타') — NOT NULL