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