sprint_mission_17

Tables (8)

Chart (Untitled5)

  • chart_id (차트 아이디) — INT — Primary key — NOT NULL
  • name (차트 이름) — VARCHAR(100) — NOT NULL
  • rank (순위) — INT — NOT NULL — CHECK(rank > 0)
  • idol_id (아이돌 id) — INT — Foreign key → Idol.idol_id — NOT NULL — CHECK (point >=0)
  • point (득표수) — INT — NOT NULL

Credit (Untitled8)

  • credit_id (크레딧 id) — INT — Primary key — NOT NULL
  • credit_type (크레딧 종류) — ENUM('100', '200', '500') — NOT NULL — (100, 200, 500)
  • price (가격) — INT — NOT NULL — CHECK(price>0)

Credit_log (Untitled6)

  • log_id (로그 id) — INT — Primary key — NOT NULL
  • user_id (사용자 id) — INT — Foreign key → User.user_id — NOT NULL
  • event_type (이벤트 유형) — ENUM — NOT NULL — ('충전', '사용')
  • total_amount (총 금액) — INT — NOT NULL — CHECK(total_amount > 0 )
  • create_at (생성 일시) — DATETIME — NOT NULL

Event (Untitled4)

  • event_id (이벤트 id) — INT — Primary key — NOT NULL
  • idol_id (아이돌 id) — INT — Foreign key → Idol.idol_id
  • group_id (그룹 id) — INT — Foreign key → Group.group_id
  • title (제목) — VARCHAR(100) — NOT NULL
  • purpose (목적) — VARCHAR(100) — NOT NULL
  • start_date (시작일) — DATETIME — NOT NULL
  • end_date (종료일) — DATETIME — NOT NULL
  • target_credit (목표 크레딧) — INT — NOT NULL
  • now_credit (현재 크레딧) — INT — NOT NULL

Group (Untitled2)

  • group_id (그룹 id) — INT — Primary key — NOT NULL
  • name (그룹 이름) — VARCHAR(100) — NOT NULL
  • size (그룹 인원) — INT — NOT NULL — CHECK (group_size >= 0)

Idol (Untitled3)

  • idol_id (아이돌 id) — INT — Primary key — NOT NULL
  • name (아이돌 이름) — VARCHAR(20) — NOT NULL
  • agency (소속사) — VARCHAR(100) — NOT NULL
  • group_id (그룹 id) — INT — Foreign key → Group.group_id
  • birthday (생일) — DATETIME
  • debut (데뷔날짜) — DATETIME

User (Untitled)

  • user_id (사용자 id) — INT — Primary key — NOT NULL
  • user_pw (사용자 비밀번호) — VARCHAR(100)
  • credit (보유 크레딧) — INT — NOT NULL
  • create_date (계정 생성 일시) — DATETIME — NOT NULL
  • idol_id (관심있는 아이돌 id) — INT — Foreign key → Idol.idol_id

User_favorite_idols (Untitled7)

  • idol_id (아이돌 id) — INT — Foreign key → Idol.idol_id — NOT NULL
  • user_id (사용자 id) — INT — Foreign key → User.user_id — NOT NULL