Fandom-K

Tables (6)

Artists

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

Credits

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

Donations

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

Follows

  • follow_id — INT
  • user_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • created_at — TIMESTAMP

Users

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

Votes

  • vote_id — INT
  • user_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP