Fandom_K 워크벤치

테이블 (10)

Artists

  • artist_id — INT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • debut_date — DATE — NOT NULL

Categories

  • category_id — INT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT

Credits

  • credit_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • credit_balance — DECIMAL(10, 2) — NOT NULL
  • charge_amount — DECIMAL(10, 2)
  • charging_date — DATE

Follows

  • user_id — INT — 기본 키 — NOT NULL
  • artist_id — INT — 기본 키 — NOT NULL
  • follow_date — DATETIME

Notifications

  • notification_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • message — TEXT
  • is_read — BOOLEAN
  • created_at — DATETIME
  • transaction_id — INT
  • support_id — INT
  • vote_id — INT
  • notification_type — ENUM('project', 'support', 'vote', 'transaction') — NOT NULL

Support

  • support_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • project_id — INT
  • amount — DECIMAL(10, 2)
  • support_date — DATETIME
  • description — TEXT

Transactions

  • transaction_id — INT — NOT NULL
  • project_id — INT
  • user_id — INT — NOT NULL
  • transaction_type — ENUM('method', 'charge', 'vote', 'support')
  • transaction_amount — DECIMAL(10, 2)
  • transaction_date — DATETIME
  • support_id — INT

Tribute

  • tribute_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • goal_amount — DECIMAL(10, 2) — NOT NULL
  • current_amount — DECIMAL(10, 2)
  • status — ENUM('active', 'completed', 'cancelled')
  • vote_id — INT

Users

  • user_id — INT — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • join_date — DATETIME — NOT NULL

Votes

  • vote_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • category_id — INT — NOT NULL
  • credit_spent — DECIMAL(10, 2)
  • voting_start_date_time — DATETIME
  • voting_end_date_time — DATETIME