미션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