Mission 17

Tables (8)

artists (Untitled)

  • artist_id (Key) — int — Primary key — NOT NULL
  • artist_name (Field) — varchar
  • artist_image (Field3) — varchar
  • artist_gender (Field2) — varchar

credit_charge (Untitled4)

  • credit_charge_id (Key) — int — Primary key — NOT NULL
  • user_id (Field) — int
  • charge_amount (Field2) — int
  • charge_date (Field3) — datetime

favorite_artist (Untitled8)

  • favorite_artist_id (Key) — int — Primary key — NOT NULL
  • artist_id (Key2) — int — Foreign key → artists.artist_id — NOT NULL
  • user_id (Field) — int
  • artist_id (Field2) — int

monthly_artist (Untitled9)

  • monthly_artist_id (Key) — int — Primary key — NOT NULL
  • artist_id (Key2) — int — Foreign key → artists.artist_id — NOT NULL
  • artist_id (Field) — int
  • vote_count (Field4) — int
  • date (Field5) — datetime

support_history (Untitled6)

  • support_history_id (Key) — int — Primary key — NOT NULL
  • support_id (Key2) — int — Foreign key → supports.support_id — NOT NULL
  • user_id (Field) — int
  • support_id (Field2) — int
  • support_amount (Field3) — int
  • support_date (Field4) — datetime

supports (Untitled5)

  • support_id (Key) — int — Primary key — NOT NULL
  • artist_id (Field) — int
  • goal_amount (Field2) — int
  • status (Field4) — varchar
  • start_date (Field5) — datetime
  • end_date (Field6) — datetime

users (Untitled2)

  • user_id (Key) — int — Primary key — NOT NULL
  • username (Field) — varchar
  • email (Field2) — varchar
  • credit (Field3) — int

vote_history (Untitled7)

  • vote_history_id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → users.user_id — NOT NULL
  • user_id (Field) — int
  • artist_id (Field2) — int
  • used_credit (Field3) — int
  • vote_date (Field4) — datetime