ㅁ
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