ㅁ

Tables (24)

categories

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL — 카테고리
  • color_hex — VARCHAR(20) — UI
  • icon_key — VARCHAR(100) — 아이콘
  • sort_order — INT — NOT NULL — 목록
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft

characters

  • id — BIGSERIAL — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL — 캐릭터
  • base_asset_key — VARCHAR(255) — NOT NULL — 기본
  • sort_order — INT — NOT NULL — 목록
  • is_active — BOOLEAN — NOT NULL — 선택

gacha

  • id — BIGSERIAL — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(120) — NOT NULL — 뽑기
  • cost_currency_type — VARCHAR(30) — 뽑기
  • cost_amount — INT — NOT NULL — 1회
  • draw_count — INT — NOT NULL — 1회
  • starts_at — TIMESTAMP — 뽑기
  • ends_at — TIMESTAMP — 뽑기
  • is_active — BOOLEAN — NOT NULL — 현재
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

gacha_pool_entries

  • id — BIGSERIAL — Primary key — NOT NULL
  • gacha_id — BIGINT — Foreign key → gacha.id — NOT NULL
  • reward_type — VARCHAR(30) — NOT NULL — 보상
  • item_id — BIGINT — Foreign key → items.id — 보상
  • currency_type — VARCHAR(30) — 보상
  • reward_amount — INT — 보상
  • rarity — VARCHAR(30) — 희귀도
  • weight — INT — NOT NULL — 추첨
  • is_active — BOOLEAN — NOT NULL — 풀

goals

  • id — BIGSERIAL — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL — 사용자에게
  • sort_order — INT — NOT NULL — 목록
  • is_active — BOOLEAN — NOT NULL — 선택

house

  • id — BIGSERIAL — Primary key — NOT NULL
  • owner_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • name — VARCHAR(120) — NOT NULL — 집
  • description — TEXT — 집
  • cover_image_key — VARCHAR(255) — 대표
  • max_members — INT — 최대
  • current_member_count — INT — NOT NULL — 현재
  • level — INT — NOT NULL — 집
  • growth_points — INT — NOT NULL — 집
  • invite_code — VARCHAR(50) — 초대
  • invite_expires_at — TIMESTAMP — 초대
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft

house_goals

  • id — BIGSERIAL — Primary key — NOT NULL
  • house_id — BIGINT — Foreign key → house.id — NOT NULL
  • goal_id — BIGINT — Foreign key → goals.id — NOT NULL — 연결된

house_members

  • id — BIGSERIAL — Primary key — NOT NULL
  • house_id — BIGINT — Foreign key → house.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — 구성원
  • role — VARCHAR(30) — NOT NULL — 역할
  • status — VARCHAR(30) — NOT NULL — 구성원
  • joined_at — TIMESTAMP — NOT NULL — 가입
  • left_at — TIMESTAMP — 탈퇴/추방

house_mission_participants

  • id — BIGSERIAL — Primary key — NOT NULL
  • mission_id — BIGINT — Foreign key → house_missions.id — NOT NULL
  • membership_id — BIGINT — Foreign key → house_members.id — NOT NULL — 참여
  • contribution_value — INT — NOT NULL — 개인
  • reward_claimed — BOOLEAN — NOT NULL — 보상
  • updated_at — TIMESTAMP — NOT NULL

house_missions

  • id — BIGSERIAL — Primary key — NOT NULL
  • house_id — BIGINT — Foreign key → house.id — NOT NULL
  • title — VARCHAR(160) — NOT NULL — 미션
  • mission_type — VARCHAR(50) — NOT NULL — 미션
  • target_value — INT — NOT NULL — 달성
  • status — VARCHAR(30) — NOT NULL — 미션
  • starts_at — TIMESTAMP — 미션
  • ends_at — TIMESTAMP — 미션
  • created_at — TIMESTAMP — NOT NULL

items

  • id — BIGSERIAL — Primary key — NOT NULL
  • category_code — VARCHAR(50) — NOT NULL
  • placement_type — VARCHAR(40) — NOT NULL — 배치
  • surface_slot_type — VARCHAR(40) — 표면
  • character_slot_type — VARCHAR(40) — 캐릭터
  • name — VARCHAR(120) — NOT NULL — 아이템
  • purchase_currency_type — VARCHAR(30) — 구매
  • price_amount — INT — 구매
  • asset_key — VARCHAR(255) — NOT NULL — 아이템
  • is_limited — BOOLEAN — NOT NULL — 한정
  • is_active — BOOLEAN — NOT NULL — 상점

personal_rooms

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • growth_level — INT — NOT NULL — 방
  • snapshot_key — VARCHAR(255) — 공유용
  • updated_at — TIMESTAMP — NOT NULL

photo_verifications

  • id — BIGSERIAL — Primary key — NOT NULL
  • routine_log_id — BIGINT — Foreign key → routine_logs.id — NOT NULL
  • storage_key — VARCHAR(255) — NOT NULL — 오브젝트
  • privacy_scope — VARCHAR(30) — NOT NULL — 사진
  • ai_review_status — VARCHAR(30) — NOT NULL — AI
  • uploaded_at — TIMESTAMP — NOT NULL — 사진
  • deleted_at — TIMESTAMP — Soft

room_surface_slots

  • id — BIGSERIAL — Primary key — NOT NULL
  • room_user_id — BIGINT — Foreign key → personal_rooms.user_id — NOT NULL
  • slot_type — VARCHAR(40) — NOT NULL — 슬롯
  • user_item_id — BIGINT — Foreign key → user_items.id — 배치된
  • saved_at — TIMESTAMP — NOT NULL — 마지막

routine_logs

  • id — BIGSERIAL — Primary key — NOT NULL
  • routine_id — BIGINT — Foreign key → routines.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL — 수행한
  • routine_date — DATE — NOT NULL — 루틴
  • status — VARCHAR(30) — NOT NULL — 수행
  • completed_at — TIMESTAMP — 완료
  • reward_currency_type — VARCHAR(30) — 지급된
  • reward_amount — INT — NOT NULL — 지급된
  • streak_after — INT — NOT NULL — 완료
  • created_at — TIMESTAMP — NOT NULL

routine_schedules

  • id — BIGSERIAL — Primary key — NOT NULL
  • routine_id — BIGINT — Foreign key → routines.id — NOT NULL
  • repeat_type — VARCHAR(40) — NOT NULL — 반복
  • repeat_days — VARCHAR(50) — specific_days일
  • scheduled_time — TIME — 루틴
  • reminder_time — TIME — 리마인더
  • target_count — INT — weekly_n일
  • target_period — VARCHAR(30) — period일
  • starts_on — DATE — NOT NULL — 일정
  • ends_on — DATE — 일정
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

routines

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • category_id — BIGINT — Foreign key → categories.id — 루틴
  • title — VARCHAR(160) — NOT NULL — 루틴
  • auth_type — VARCHAR(30) — NOT NULL — 인증
  • visibility — VARCHAR(30) — NOT NULL — 공개
  • status — VARCHAR(30) — NOT NULL — 루틴
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft

streaks

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • streak_type — VARCHAR(40) — NOT NULL — 스트릭
  • current_count — INT — NOT NULL — 현재
  • longest_count — INT — NOT NULL — 최장
  • last_success_date — DATE — 마지막
  • last_evaluated_date — DATE — 마지막
  • status — VARCHAR(30) — NOT NULL — 스트릭
  • updated_at — TIMESTAMP — NOT NULL

todos

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • category_id — BIGINT — Foreign key → categories.id — 투두
  • title — VARCHAR(160) — NOT NULL — 투두
  • description — TEXT — 투두
  • due_date — DATE — 완료
  • status — VARCHAR(30) — NOT NULL — 상태
  • completed_at — TIMESTAMP — 완료
  • reward_currency_type — VARCHAR(30) — 완료
  • reward_amount — INT — NOT NULL — 완료
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft

user_characters

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • character_id — BIGINT — Foreign key → characters.id — NOT NULL — 보유
  • is_selected — BOOLEAN — NOT NULL — 현재
  • acquired_at — TIMESTAMP — NOT NULL — 캐릭터
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft

user_goals

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • goal_id — BIGINT — Foreign key → goals.id — NOT NULL — 선택된
  • is_primary — BOOLEAN — NOT NULL — 대표
  • created_at — TIMESTAMP — NOT NULL

user_items

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • item_id — BIGINT — Foreign key → items.id — NOT NULL — 보유
  • acquired_source — VARCHAR(40) — NOT NULL — 획득
  • acquired_at — TIMESTAMP — NOT NULL — 획득
  • deleted_at — TIMESTAMP — Soft

user_wallets

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • currency_type — VARCHAR(30) — NOT NULL — 재화
  • balance — INT — NOT NULL — 현재
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL — 이메일
  • provider_user_id — VARCHAR(255) — NOT NULL — 소셜
  • auth_provider — VARCHAR(30) — NOT NULL — 소셜
  • status — VARCHAR(30) — NOT NULL — 계정
  • last_login_at — TIMESTAMP — 마지막
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP — Soft