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')