MISSION 17

Tables (8)

Artist

  • artist_id — INT — Primary key — NOT NULL
  • artist_name — VARCHAR(10) — NOT NULL
  • category — VARCHAR(10)

Credit

  • trans_id — INT — Primary key — NOT NULL
  • charge_credit — INT
  • user_id — INT — Foreign key → User.user_id — NOT NULL

Follow

  • user_id — INT — Primary key — NOT NULL
  • artist_id — INT — Primary key — NOT NULL
  • user_id (user_id2) — INT — Foreign key → User.user_id — NOT NULL
  • artist_id (artist_id2) — INT — Foreign key → Artist.artist_id — NOT NULL

Support

  • sup_id — INT — Primary key — NOT NULL
  • sup_credit — INT
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • tribute_id — INT — Foreign key → Tribute.tribute_id — NOT NULL

Tribute

  • tribute_id — INT — Primary key — NOT NULL
  • title — VARCHAR(20)
  • sub_title — VARCHAR(20)
  • limit_date — DATE
  • goal_credit — INT
  • now_credit — INT
  • start_date — DATE
  • end_date — DATE
  • status — VARCHAR(10)
  • artist_id — INT — Foreign key → Artist.artist_id — NOT NULL

User

  • user_id — INT — Primary key — NOT NULL
  • user_name — VARCHAR(10) — NOT NULL
  • email — VARCHAR(20)
  • pwd — VARCHAR(20)
  • credit (crdeit) — INT

Vote

  • vote_id — INT — Primary key — NOT NULL
  • vote_credit — INT
  • voted_at — DATE
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • artist_id — INT — Foreign key → Artist.artist_id — NOT NULL

VoteRanking

  • ranking_id — INT — Primary key — NOT NULL
  • total_votes — INT
  • rank — INT
  • vote_period_start — DATE
  • vote_period_end — DATE
  • artist_id — INT — Foreign key → Artist.artist_id — NOT NULL