미션8

테이블 (10)

USER (user)

  • user_id — int — 기본 키 — NOT NULL
  • user_name — varchar(20)
  • gender — char(1)
  • birth — date
  • total_credit — int
  • user_date — datetime
  • phone_number — varchar(20)
  • email — varchar(260)

artist

  • artist_id — int — 기본 키 — NOT NULL
  • artist_name — varchar(50)
  • artist_category — char(1) — m/f

credit_record

  • credit_id — int — 기본 키 — NOT NULL
  • credit_user_id — int — 외래 키 → USER.user_id — NOT NULL
  • credit_type — enum('charge', 'vote', 'support')
  • credit_amount — int
  • credit_date — datetime

follow

  • follow_id — 기본 키 — NOT NULL
  • follow_user_id — int — 외래 키 → USER.user_id — NOT NULL
  • follow_artist_id — int — 외래 키 → artist.artist_id — NOT NULL
  • follow_date — datetime

group

  • group_id — int — 기본 키 — NOT NULL
  • group_name — varchar(50)

support_artist

  • support_artist_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → USER.user_id — NOT NULL
  • tribute_artist_id — int — 외래 키 → tribute_artist.tribute_artist_id — NOT NULL
  • support_artist_date — date

support_group

  • support_group_id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → USER.user_id — NOT NULL
  • tribute_group_id — int — 외래 키 → tribute_group.tribute_group_id — NOT NULL
  • support_group_date — datetime

tribute_artist

  • tribute_artist_id — int — 기본 키 — NOT NULL
  • artist_id — int — 외래 키 → artist.artist_id — NOT NULL
  • tribute_artist_type — enum('gift', 'promo', 'chart', ‘etc’)
  • tribute_artist_name — varchar
  • credit_artist_goal — int
  • start_date — datetime
  • end_date — datetime

tribute_group

  • tribute_group_id — int — 기본 키 — NOT NULL
  • group_id — int — 외래 키 → group.group_id — NOT NULL
  • tribute_group_type — enum('gift', 'promo', 'chart', ‘etc’)
  • tribute_group_name — varchar(50)
  • credit_group_goal — int
  • start_date — datetime
  • end_date — datetime

vote

  • vote_id — int — 기본 키 — NOT NULL
  • vote_user_id — int — 외래 키 → USER.user_id — NOT NULL
  • vote_artist_id — int — 외래 키 → artist.artist_id — NOT NULL
  • vote_date — datetime