SarahPark

Tables (8)

Artists

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

Categories

  • category_id — INT
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(200)

Credits

  • user_id — INT
  • balance — DECIMAL(10, 2) — NOT NULL
  • last_updated — TIMESTAMP

Donations

  • donation_id — INT
  • user_id — INT — NOT NULL
  • tribute_id — INT — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • donated_at — TIMESTAMP

Follows

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

Tributes

  • tribute_id — INT
  • artist_id — INT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • goal_amount — DECIMAL(10, 2) — NOT NULL
  • current_amount — DECIMAL(10, 2)
  • status — ENUM('active', 'achieved', 'expired')
  • start_date — DATE
  • end_date — DATE
  • created_at — TIMESTAMP

Users

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

Votes

  • vote_id — INT
  • user_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • category_id — INT — NOT NULL
  • voted_at — TIMESTAMP