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