스프린트미션17
테이블 (8)
Artist
- artist_id — INT
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50)
- description — TEXT
CreditTransaction
- transaction_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- type — ENUM('충전', '사용') — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- platform_id — INT — NOT NULL
- timestamp — DATETIME
Follow
- follow_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- timestamp — DATETIME
- UNIQUE(user_id, — artist_id)
Platform
- platform_id — INT
- name — VARCHAR(50) — NOT NULL
Revenue
- revenue_id — INT
- transaction_id — INT — NOT NULL
- fee_rate — DECIMAL(5, 4)
- fee_amount — DECIMAL(10, 2) — NOT NULL
- platform_id — INT — NOT NULL
- timestamp — DATETIME
Support
- support_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- credit_used — DECIMAL(10, 2) — NOT NULL
- goal_reached — BOOLEAN
- platform_id — INT — NOT NULL
- timestamp — DATETIME
User
- user_id — INT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- credit_balance — DECIMAL(10, 2)
Vote
- vote_id — INT
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- credit_used — DECIMAL(10, 2)
- platform_id — INT — NOT NULL
- timestamp — DATETIME