8_5

Tables (10)

ChartRanking

  • ranking_id — VARCHAR(255) — 순위 기록 식별을 위한 고유 ID
  • chart_type — VARCHAR(255) — NOT NULL
  • idol_id — VARCHAR(255) — NOT NULL
  • rank — INT — NOT NULL
  • vote_count — INT — NOT NULL
  • recorded_at — DATE — NOT NULL

CreditProduct

  • product_id — VARCHAR(255) — 상품 식별을 위한 고유 ID
  • product_name — VARCHAR(255) — NOT NULL
  • credit_amount — INT — NOT NULL
  • price — INT — NOT NULL

Idol

  • idol_id — VARCHAR(255) — 아이돌 식별을 위한 고유 ID
  • name — VARCHAR(255) — NOT NULL
  • group_id — VARCHAR(255)
  • agency — VARCHAR(255)
  • profile_image_url — VARCHAR(255)

IdolGroup

  • group_id — VARCHAR(255) — 그룹 식별을 위한 고유 ID
  • group_name — VARCHAR(255) — NOT NULL
  • agency — VARCHAR(255)
  • debut_date — DATE

News_Notice

  • post_id — VARCHAR(255) — 게시물 식별을 위한 고유 ID
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP
  • related_idol_id — VARCHAR(255)

SponsorProject

  • project_id — VARCHAR(255) — 프로젝트 식별을 위한 고유 ID
  • project_name — VARCHAR(255) — NOT NULL
  • target_idol_id — VARCHAR(255)
  • required_credit — INT — NOT NULL
  • current_amount — INT
  • end_date — DATE — NOT NULL
  • image_url — VARCHAR(255)

Transaction

  • transaction_id — VARCHAR(255) — 거래 식별을 위한 고유 ID
  • user_id — VARCHAR(255) — NOT NULL
  • transaction_type — ENUM('charge', 'sponsor', 'vote') — NOT NULL
  • amount — INT — NOT NULL
  • transacted_at — TIMESTAMP
  • related_id — VARCHAR(255)

User

  • user_id — VARCHAR(255) — 사용자 식별을 위한 고유 ID
  • nickname — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • credit_balance — INT
  • created_at — TIMESTAMP

User_Interest

  • user_id — VARCHAR(255) — Primary key — NOT NULL
  • idol_id — VARCHAR(255) — Primary key — NOT NULL
  • added_at — TIMESTAMP

Vote

  • vote_id — VARCHAR(255) — 투표 기록 식별을 위한 고유 ID
  • user_id — VARCHAR(255) — NOT NULL
  • idol_id — VARCHAR(255) — NOT NULL
  • vote_credit — INT — NOT NULL
  • voted_at — TIMESTAMP