Fandom K

Tables (9)

artist_categories

  • category_id — INT — Primary key — NOT NULL
  • name — VARCHAR(20)
  • description — VARCHAR(100)
  • created_at — DATETIME — NOT NULL

artists

  • artist_id — INT — Primary key — NOT NULL
  • category_id — INT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • bio — TEXT

credit_log

  • log_id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • credit_change — INT — NOT NULL
  • logged_at — DATETIME — NOT NULL
  • description — VARCHAR(200)

donation_types

  • donation_type_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(100)
  • created_at — DATETIME — NOT NULL

donations

  • donation_id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • donation_type_id — INT — NOT NULL
  • amount — INT — NOT NULL
  • donated_at — DATETIME — NOT NULL

favorites

  • fav_id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • category_id — INT — NOT NULL
  • added_at — DATETIME — NOT NULL

monthly_artists

  • monthly_artist_id — INT — Primary key — NOT NULL
  • artist_id — INT — NOT NULL
  • year — INT — NOT NULL
  • month — INT — NOT NULL
  • rank — INT
  • vote_count — INT
  • created_at — DATETIME — NOT NULL

users

  • user_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • credit_balance — INT — NOT NULL

votes

  • vote_id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • credit_used — INT — NOT NULL
  • voted_at — DATETIME — NOT NULL