Fandom_K 워크벤치
테이블 (10)
Artists
- artist_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- debut_date — DATE — NOT NULL
Categories
- category_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
Credits
- credit_id — INT — NOT NULL
- user_id — INT — NOT NULL
- credit_balance — DECIMAL(10, 2) — NOT NULL
- charge_amount — DECIMAL(10, 2)
- charging_date — DATE
Follows
- user_id — INT — 기본 키 — NOT NULL
- artist_id — INT — 기본 키 — NOT NULL
- follow_date — DATETIME
Notifications
- notification_id — INT — NOT NULL
- user_id — INT — NOT NULL
- message — TEXT
- is_read — BOOLEAN
- created_at — DATETIME
- transaction_id — INT
- support_id — INT
- vote_id — INT
- notification_type — ENUM('project', 'support', 'vote', 'transaction') — NOT NULL
Support
- support_id — INT — NOT NULL
- user_id — INT — NOT NULL
- project_id — INT
- amount — DECIMAL(10, 2)
- support_date — DATETIME
- description — TEXT
Transactions
- transaction_id — INT — NOT NULL
- project_id — INT
- user_id — INT — NOT NULL
- transaction_type — ENUM('method', 'charge', 'vote', 'support')
- transaction_amount — DECIMAL(10, 2)
- transaction_date — DATETIME
- support_id — INT
Tribute
- tribute_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- goal_amount — DECIMAL(10, 2) — NOT NULL
- current_amount — DECIMAL(10, 2)
- status — ENUM('active', 'completed', 'cancelled')
- vote_id — INT
Users
- user_id — INT — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- join_date — DATETIME — NOT NULL
Votes
- vote_id — INT — NOT NULL
- user_id — INT — NOT NULL
- artist_id — INT — NOT NULL
- category_id — INT — NOT NULL
- credit_spent — DECIMAL(10, 2)
- voting_start_date_time — DATETIME
- voting_end_date_time — DATETIME