Fandom-K2
Tables (9)
Artists (아티스트)
- artist_id (아티스트_id) — INT — Primary key — NOT NULL
- name (아티스트 이름) — VARCHAR(255) — NOT NULL
- agency (소속사) — VARCHAR(255)
- debut_date (데뷔일자) — DATE
- project_id (프로젝트_id) — INT — Foreign key → Tribute.Tribute_id
- vote_id (투표_id) — INT — Foreign key → Votes.vote_id
Categories (투표카테고리)
- category_id (카테고리_id) — INT — Primary key
- name (이름) — VARCHAR(100) — NOT NULL
- description (설명) — TEXT
- vote_id (투표_id) — INT — Foreign key → Votes.vote_id
Credits (크레딧)
- credit_id (크레딧_id) — INT — Primary key — NOT NULL
- user_id (유저_id) — INT — NOT NULL
- Credit_balance (크레딧 잔액) — DECIMAL(10, 2)
- Charge_amount (충전금액) — INT
- Charging_date (충전일) — DATE
Follows (팔로우)
- user_id — INT — Primary key — NOT NULL
- artist_id — INT — Primary key — NOT NULL
- follow_date (팔로우 일시) — DATETIME
- user_id (유저_id2) — INT — NOT NULL
- user_id (유저_id) — INT — NOT NULL
- user_id (유저_id3) — INT — Foreign key → Users.user_id — NOT NULL
- user_id (유저_id22) — INT — Foreign key → Users.user_id — NOT NULL
- artist_id (아티스트_id) — INT — Foreign key → Artists.artist_id — NOT NULL
Support (후원)
- support_id (후원 아티스트_id) — INT — Primary key
- user_id (유저_id) — INT — NOT NULL
- project_id (프로젝트_id) — INT — NOT NULL
- amount (후원금액) — DECIMAL(10, 2) — NOT NULL
- support_date (후원일) — DATETIME
- description (설명) — TEXT
Transactions (거래 기록)
- transaction_id (거래고유_id) — INT — Primary key
- project_id (조공 프로젝트_id) — INT — Foreign key → Tribute.Tribute_id
- user_id (유저_id) — INT — NOT NULL
- transaction_type (거래 유형) — ENUM('credit_charge', 'vote', 'support') — NOT NULL
- amount (거래 금액) — DECIMAL(10, 2) — NOT NULL
- transaction_date (거래 일시) — DATETIME
- credit_id (크레딧_id) — INT — Foreign key → Credits.credit_id — NOT NULL
- support_id (후원 아티스트_id) — INT — Foreign key → Support.support_id
Tribute (조공)
- Tribute_id (조공 _id) — INT — Primary key
- artist_id (아티스트_id) — INT — NOT NULL
- goal_amount (목표 금액) — DECIMAL(10, 2) — NOT NULL
- current_amount (현재 금액) — DECIMAL(10, 2)
- status (프로젝트 상태) — ENUM('active', 'completed', 'cancelled')
Users (유저)
- user_id (유저_id) — INT — Primary key — NOT NULL
- user_id (유저_id2) — INT — Foreign key → Credits.credit_id — NOT NULL
- email (이메일) — VARCHAR(255) — NOT NULL
- nickname (닉네임) — VARCHAR(100) — NOT NULL
- password (비밀번호) — VARCHAR(255) — NOT NULL
- join_date (가입 날짜) — DATETIME — NOT NULL
- vote_id (투표_id) — INT — Foreign key → Votes.vote_id
Votes (투표)
- vote_id (투표_id) — INT — Primary key
- user_id (유저_id) — INT — NOT NULL
- artist_id (아티스트_id) — INT — NOT NULL
- category_id (카테고리_id) — INT — NOT NULL
- credit_spent (소모크레딧) — DECIMAL(10, 2) — NOT NULL
- Voting_ start _date _time (투표시작일시) — DATETIME
- Voting_ end _date _time (투표종료일시) — DATETIME