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