Fandom_k
테이블 (24)
게시물 (posts)
- post_id — BIGINT — 기본 키 — NOT NULL
- artist_id — BIGINT — 외래 키 — NOT NULL
- title — VARCHAR(150) — NOT NULL
- content — TEXT — NOT NULL
- media_url — VARCHAR(500)
- is_published — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
결제내역 (payments)
- payment_id (Key4) — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- payment_method_id — BIGINT — 외래 키 — NOT NULL
- package_id — BIGINT — 외래 키
- paid_amount — DECIMAL(10,2) — NOT NULL
- charged_credit — INT — NOT NULL
- status — ENUM('PENDING','PAID','FAILED','CANCELED','REFUNDED') — NOT NULL
- requested_at — DATETIME — NOT NULL
- paid_at — DATETIME
결제수단 (payment_methods)
- payment_method_id (Key) — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- payment_type — ENUM('card','bank_account') — NOT NULL
- provider — VARCHAR(30)
- is_default — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
계좌 이체 (bank_accounts)
- payment_method_id — BIGINT — 외래 키
- bank_name — VARCHAR(20)
- account_holder — VARCHAR(50)
- masked_account — VARCHAR(20) — ****0000
- method — VARCHAR(20) — 가상계좌/계좌일반결제
- created_at — DATETIME — NOT NULL
그룹 (group_idols)
- group_id (Key) — BIGINT — 기본 키 — NOT NULL
- group_name — VARCHAR(100) — NOT NULL
- agency — VARCHAR(100)
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
그룹 멤버 (group_members)
- group_member_id (Key2) — BIGINT — 기본 키 — NOT NULL
- group_id — BIGINT — 외래 키 — NOT NULL
- artist_id — BIGINT — 외래 키 — NOT NULL
- role — VARCHAR(50)
- joined_at — DATE
- left_at — DATE
아티스트 (artists)
- artist_id (Key) — BIGINT — 기본 키 — NOT NULL
- artist_name — VARCHAR(100) — NOT NULL
- gender — ENUM('male','female','other','unknown') — NOT NULL
- agency — VARCHAR(100)
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
알림 (notifications)
- notif_id (Key) — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- noti_type — ENUM('NEW_POST','DONATION_SUCCESS','VOTE_RESULT','VOTE_ENDING','SYSTEM') — NOT NULL
- message — VARCHAR(250) — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
조공 프로젝트 (projects)
- project_id (Key2) — BIGINT — 기본 키 — NOT NULL
- artist_id — BIGINT — 외래 키 — NOT NULL
- title — VARCHAR(150) — NOT NULL
- project_type — VARCHAR(50)
- target_credit — INT — NOT NULL
- current_credit — INT — NOT NULL
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- status — ENUM('DRAFT','OPEN','SUCCESS','FAILED','CLOSED') — NOT NULL
- created_at — DATETIME — NOT NULL
카드 정보 (cards)
- payment_method_id — BIGINT — 외래 키
- card_brand — VARCHAR(20)
- masked_card_no — VARCHAR(20)
- exp_month — TINYINT
- exp_year — SMALLINT
- method — VARCHAR(20) — credit,debit,samsungpay,naverpay,tosspay,alipay,paypal
- created_at — DATETIME — NOT NULL
크레딧 거래내역 (credit_transactions)
- tx_id — BIGINT — 기본 키
- user_id — BIGINT — 외래 키 — NOT NULL
- txn_type — ENUM('TOPUP','VOTE','DONATION','REFUND','ADJUST') — NOT NULL
- delta_amount — INT — NOT NULL
- balance_after — INT — NOT NULL
- payment_id — BIGINT — 외래 키
- refund_id — BIGINT — 외래 키
- vote_id — BIGINT — 외래 키 → 투표 내역.vote_id
- contribution_id — BIGINT — 외래 키
- created_at — DATETIME — NOT NULL
크레딧 지갑 (credit_wallets)
- user_id — BIGINT — 외래 키
- balance — INT — NOT NULL
- updated_at — DATETIME — NOT NULL
크레딧 패키지 (credit_packages)
- package_id (Key) — BIGINT — 기본 키 — NOT NULL
- package_name — VARCHAR(50)
- credit_amount — INT — NOT NULL
- price_amount — DECIMAL(10,2) — NOT NULL
- currency — CHAR(3) — NOT NULL
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
투표 내역 (votes)
- vote_id — BIGINT — 기본 키
- round_id — BIGINT — 외래 키 → 투표 라운드.round_id — NOT NULL
- candidate_id — BIGINT — 외래 키 → 투표 후보.candidate_id — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- vote_units — INT — NOT NULL
- unit_cost — INT — NOT NULL
- credit_amount — INT — NOT NULL
- created_at — DATETIME — NOT NULL
투표 라운드 (vote_rounds)
- round_id — BIGINT — 기본 키
- event_id — BIGINT — 외래 키 → 투표 이벤트.event_id — NOT NULL
- round_no — INT — NOT NULL
- title — VARCHAR(100)
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- status — ENUM('DRAFT','OPEN','CLOSED') — NOT NULL
- created_at — DATETIME — NOT NULL
투표 이벤트 (vote_events)
- event_id — BIGINT — 기본 키
- category_id — BIGINT — 외래 키 → 투표 카테고리.category_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- status — ENUM('DRAFT','OPEN','CLOSED') — NOT NULL
- created_at — DATETIME — NOT NULL
투표 카테고리 (vote_categories)
- category_id — BIGINT — 기본 키
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(200)
투표 후보 (vote_candidates)
- candidate_id — BIGINT — 기본 키
- round_id — BIGINT — 외래 키 → 투표 라운드.round_id — NOT NULL
- artist_id — BIGINT — 외래 키
- group_id — BIGINT — 외래 키
- seed_rank — INT
- created_at — DATETIME — NOT NULL
팔로우 (follows)
- follow_id (Key3) — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- artist_id — BIGINT — 외래 키 — NOT NULL
- status — ENUM('active','muted','unfollowed') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
프로젝트 업데이트 (project_updates)
- update_id (Key3) — BIGINT — 기본 키 — NOT NULL
- project_id — BIGINT — 외래 키 — NOT NULL
- title — VARCHAR(150) — NOT NULL
- content — TEXT — NOT NULL
- media_url — VARCHAR(500)
- is_published — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
프로젝트_후원내역 (project_contributions)
- contribution_id (Key) — BIGINT — 기본 키 — NOT NULL
- project_id — BIGINT — 외래 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- credit_amount — INT — NOT NULL
- created_at — DATETIME — NOT NULL
환불 내역 (payment_refunds)
- refund_id (Key5) — BIGINT — 기본 키 — NOT NULL
- payment_id — BIGINT — 외래 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- refund_amount — DECIMAL(10,2) — NOT NULL
- refund_credit — INT — NOT NULL
- status — ENUM('REQUESTED','APPROVED','REJECTED','DONE') — NOT NULL
- requested_at — DATETIME — NOT NULL
- refunded_at — DATETIME
회원 (users)
- 회원아이디 (user_id) — BIGINT — 기본 키 — NOT NULL
- 이메일 (email) — VARCHAR(255) — NOT NULL
- 비밀번호 (password) — VARCHAR(255) — NOT NULL
- 이름 (name) — VARCHAR(50)
- 닉네임 (nickname) — VARCHAR(50) — NOT NULL
- 휴대폰번호 (phone) — VARCHAR(20)
- 성별 (gender) — ENUM('male','female','other')
- 나이 (age) — INT
- 상태 (status) — ENUM('active','banned','deleted') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
회원접속기록 (user_logs)
- user_log_id (Key2) — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 — NOT NULL
- login_at — DATETIME — NOT NULL
- device — VARCHAR(50)
- ip_address — VARCHAR(45)
- channel_type — ENUM('WEB','IOS','AOS')