Fandom-KKK
Tables (9)
Artists
- artist_id — INT
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- description — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
Credits
- credit_id — INT
- user_id — INT — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
DonationGoals
- goal_id — INT
- artist_id — INT — NOT NULL
- target_amount — DECIMAL(10, 2) — NOT NULL
- current_credit — DECIMAL(10, 2)
- deadline — DATE — NOT NULL
- situation — ENUM('진행 중', '달성 완료') — NOT NULL
Donations
- donation_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
Events
- event_id — INT
- event_name — VARCHAR(100) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- location — VARCHAR(255)
Follows
- follow_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- UNIQUE(user_id, — artist_id)
Users
- user_id — INT
- username — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
Votes
- vote_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- category — ENUM('솔로', '그룹', '기타') — NOT NULL
- vote_count — DECIMAL(10, 2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
favorite_artists
- favorite_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- category — ENUM('최애', '차애', '기타') — NOT NULL