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