Sprint_Mission_17_FandomK
Tables (7)
Artist
- artist_id — INT — Primary key — NOT NULL
- votes — INT
Donation
- donation_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- project_id — INT — Foreign key → Project.project_id — NOT NULL
- credit_amount — INT
- date — DATETIME
Follow
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- artist_id — INT — Foreign key → Artist.artist_id — NOT NULL
- followed_date (date) — DATETIME
Project
- project_id — INT — Primary key — NOT NULL
- artist_id — INT — Foreign key → Artist.artist_id — NOT NULL
- title — VARCHAR(50)
- goal — INT
- states (status) — INT
- deadline — DATETIME
Untitled (Credits)
- Key (transaction_id) — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- Field (amount) — INT
- Field (type) — ENUM('충전','사용')
- Field (date) — DATETIME
Users
- user_id — INT — Primary key — NOT NULL
- credits — INT
Votes
- idol_id (vote_id) — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- artist_id — INT — Foreign key → Artist.artist_id — NOT NULL
- votes — INT
- Field (category) — VARCHAR(50)
- Field (vote_date) — DATETIME