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
- user_id (Field) — int
- artist_id (Field2) — int
monthly_artist (Untitled9)
- monthly_artist_id (Key) — int — Primary key — 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
- 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 (Field) — int
- artist_id (Field2) — int
- used_credit (Field3) — int
- vote_date (Field4) — datetime