Misstion 17

Tables (7)

Artist

  • Artist ID (artist_id) — BIGINT — Primary key — NOT NULL
  • Name (name) — VARCHAR(100)
  • Category (category) — VARCHAR(50)
  • Created At (created_at) — TIMESTAMP

Charge (charge)

  • Charge ID (charge_id) — BIGINT — Primary key — NOT NULL
  • User ID (user_id) — BIGINT — Foreign key → User.User ID — NOT NULL
  • Amount (amount) — INT
  • Created At (created_at) — TIMESTAMP

Credit

  • Credit ID (credit_id) — BIGINT — Primary key — NOT NULL
  • User ID (user_id) — BIGINT — Foreign key → User.User ID — NOT NULL
  • Amount (amount) — INT
  • Type (type) — ENUM
  • Created At (created_at) — TIMESTAMP

Donation

  • Donation ID (donation_id) — BIGINT — Primary key — NOT NULL
  • Artist ID (artist_id) — BIGINT — Foreign key → Artist.Artist ID — NOT NULL
  • User ID (user_id) — BIGINT — Foreign key → User.User ID — NOT NULL
  • Amount (amount) — INT
  • Created At (created_at) — TIMESTAMP

Follow

  • User ID (user_id) — BIGINT — Primary key — NOT NULL
  • Artist ID (artist_id) — BIGINT
  • Created At (created_at) — TIMESTAMP

User

  • User ID (user_id) — BIGINT — Primary key — NOT NULL
  • Username (username) — VARCHAR(50)
  • Email (email) — VARCHAR(100)
  • Password (password) — VARCHAR(255)
  • Created At (created_at) — TIMESTAMP
  • Updated At (updated_at) — TIMESTAMP

Vote

  • Vote ID (vote_id) — BIGINT — Primary key — NOT NULL
  • Artist ID (artist_id) — BIGINT — Foreign key → Artist.Artist ID — NOT NULL
  • User ID (user_id) — BIGINT — Foreign key → User.User ID — NOT NULL
  • Category (category) — VARCHAR(50)
  • Used Credit (used_credit) — INT
  • Created At (created_at) — TIMESTAMP