8_분석실습_4팀_세빌
테이블 (6)
artist (아티스트)
- Key (artist_id) — INT — 기본 키 — NOT NULL
- - (artist_name) — VARCHAR(100) — NOT NULL
- - (group_name) — VARCHAR(100) — NOT NULL
- - (created_at) — DATETIME — NOT NULL
credit (크레딧)
- Key (user_id) — INT — 외래 키 → user.Key — NOT NULL
- - (balance) — DECIMAL(10, 2) — NOT NULL
follow (팔로우)
- Key (artist_id) — INT — 외래 키 → artist.Key — NOT NULL
- Key (user_id) — INT — 외래 키 → user.Key — NOT NULL
- Field (followed_at) — DATETIME — NOT NULL
support (조공 프로젝트)
- Key (support_id) — INT — 기본 키 — NOT NULL
- Field (title) — VARCHAR(200) — NOT NULL
- Field2 (goal_amount) — DECIMAL(10, 2) — NOT NULL
- Field3 (current_amount) — DECIMAL(10, 2) — NOT NULL
- Field4 (start_date) — DATE — NOT NULL
- Field5 (end_date) — DATE — NOT NULL
- Field6 (status) — ENUM('ONGOING','COMPLETED','FAILED') — NOT NULL
- Field7 (created_at) — DATETIME — NOT NULL
- Key (artist_id) — INT — 외래 키 → artist.Key — NOT NULL
user (유저)
- Key (user_id) — INT — 기본 키 — NOT NULL
- - (email) — VARCHAR(50) — NOT NULL
- - (nickname) — VARCHAR(50) — NOT NULL
- - (password) — VARCHAR(250) — NOT NULL
- - (created_at) — DATETIME — NOT NULL
vote (투표)
- Key (vote_id) — INT — 기본 키 — NOT NULL
- - (credit_used) — DECIMAL(10, 2)
- - (voted_at) — DATETIME — NOT NULL
- Key (user_id) — INT — 외래 키 → user.Key — NOT NULL
- Key (artist_id) — INT — 외래 키 → artist.Key — NOT NULL