mission8

Tables (8)

Users (Untitled)

  • user_id (Field) — INT — Primary key
  • email (Field2) — VARCHAR(255)
  • password_hash (Field3) — VARCHAR(255)
  • nickname (Field4) — VARCHAR(255)
  • created_at (Field6) — DATETIME

artists (Untitled2)

  • artist_id (Field) — INT — Primary key
  • name (Field2) — VARCHAR
  • group_name (Field3) — VARCHAR
  • debut_date (Field4) — DATE
  • created_at (Field5) — DATETIME

credit_transactions (Untitled3)

  • transaction_id (Field) — INT — Primary key
  • amount (Field3) — INT
  • fee_amount (Field4) — INT
  • created_at (Field5) — DATETIME
  • type (Field6) — VARCHAR(20)
  • user_id (Field7) — INT — Foreign key → Users.user_id

support_contributions (Untitled5)

  • contribution_id (Field) — INT — Primary key
  • amount (Field4) — INT
  • created_at (Field5) — DATETIME
  • user_id (Field6) — INT — Foreign key → Users.user_id
  • project_id (Field7) — INT — Foreign key → support_projects.project_id

support_projects (Untitled4)

  • project_id (Field) — INT — Primary key
  • artist_id (Field2) — INT
  • title (Field3) — VARCHAR
  • description (Field4) — TEXT
  • target_credits (Field5) — INT
  • start_date (Field6) — DATE
  • end_date (Field7) — DATE
  • status (Field8) — VARCHAR
  • created_at (Field9) — DATETIME
  • artist_id (Field10) — INT — Foreign key → artists.artist_id

user_artist_follows (Untitled8)

  • follow_id (Field) — INT — Primary key
  • followed_at (Field4) — DATETIME
  • user_id (Field5) — INT — Foreign key → Users.user_id
  • artist_id (Field6) — INT — Foreign key → artists.artist_id

vote_categories (Untitled6)

  • category_id (Field) — INT — Primary key
  • description (Field2) — TEXT
  • name (Field3) — VARCHAR
  • credit_cost (Field4) — INT
  • start_date (Field5) — DATE
  • end_date (Field6) — DATE
  • created_at (Field7) — DATETIME

votes (Untitled7)

  • vote_id (Field) — INT — Primary key
  • credit_used (Field5) — INT
  • voted_at (Field6) — DATETIME
  • user_id (Field7) — INT — Foreign key → Users.user_id
  • artist_id (Field8) — INT — Foreign key → artists.artist_id
  • category_id (Field9) — INT — Foreign key → vote_categories.category_id