mission 8

Tables (8)

artists

  • artist_id — INT
  • name — VARCHAR(100) — NOT NULL
  • debut_date — DATE
  • profile_image_url — VARCHAR(255)
  • created_at — TIMESTAMP

credit_charges

  • charge_id — INT
  • user_id — INT — NOT NULL
  • amount — DECIMAL(15, 2) — NOT NULL
  • payment_method — VARCHAR(50)
  • transaction_id — VARCHAR(255)
  • charged_at — TIMESTAMP

follows

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

projects

  • project_id — INT
  • creator_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • target_amount — DECIMAL(15, 2

supports

  • support_id — INT
  • user_id — INT — NOT NULL
  • project_id — INT — NOT NULL
  • amount — DECIMAL(15, 2) — NOT NULL
  • supported_at — TIMESTAMP

users

  • user_id — INT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • credit_balance — DECIMAL(15, 2) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

vote_topics

  • topic_id — INT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • created_at — TIMESTAMP

votes

  • vote_id — INT
  • user_id — INT — NOT NULL
  • artist_id — INT — NOT NULL
  • topic_id — INT — NOT NULL
  • credits_spent — INT — NOT NULL
  • voted_at — TIMESTAMP