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