루게더 mvp (최종)

테이블 (25)

categories

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • color_hex — VARCHAR(20)
  • visibility — VARCHAR(30)
  • icon_key — VARCHAR(100)
  • sort_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

characters

  • id — BIGSERIAL — 기본 키 — 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 — 기본 키 — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • cost_currency_type — VARCHAR(30)
  • cost_amount — INT — NOT NULL
  • draw_count — INT — NOT NULL
  • starts_at — TIMESTAMP
  • ends_at — TIMESTAMP
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • id (theme_id) — BIGSERIAL — 외래 키 → themes.id — NOT NULL

gacha_pool_entries

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • gacha_id — BIGINT — 외래 키 → gacha.id — NOT NULL
  • reward_type — VARCHAR(30) — NOT NULL
  • item_id — BIGINT — 외래 키 → items.id
  • currency_type — VARCHAR(30)
  • reward_amount — INT
  • rarity — VARCHAR(30)
  • weight — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL

goals

  • id — BIGSERIAL — 기본 키 — 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 — 기본 키 — NOT NULL
  • owner_user_id — BIGINT — 외래 키 → 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

house_goals

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • house_id — BIGINT — 외래 키 → house.id — NOT NULL
  • goal_id — BIGINT — 외래 키 → goals.id — NOT NULL

house_members

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • house_id — BIGINT — 외래 키 → house.id — NOT NULL
  • user_id — BIGINT — 외래 키 → 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 — 기본 키 — NOT NULL
  • mission_id — BIGINT — 외래 키 → house_missions.id — NOT NULL
  • membership_id — BIGINT — 외래 키 → house_members.id — NOT NULL
  • contribution_value — INT — NOT NULL
  • reward_claimed — BOOLEAN — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

house_missions

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • house_id — BIGINT — 외래 키 → 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 — 기본 키 — NOT NULL
  • theme_id — BIGSERIAL — 외래 키 → themes.id — 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 — 외래 키 → users.id — NOT NULL
  • growth_level — INT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

photo_verifications

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • routine_log_id — BIGINT — 외래 키 → routine_logs.id — NOT NULL
  • storage_key — VARCHAR(255) — NOT NULL
  • privacy_scope — VARCHAR(30) — NOT NULL
  • ai_review_status — VARCHAR(30) — NOT NULL
  • uploaded_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

room_guestbooks

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP
  • room_owner_id — BIGINT — 외래 키 → users.id — NOT NULL
  • house_id — BIGINT — 외래 키 → house.id — NOT NULL
  • author_id — BIGINT — 외래 키 → users.id — NOT NULL

room_surface_slots

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • room_user_id — BIGINT — 외래 키 → personal_rooms.user_id — NOT NULL
  • slot_type — VARCHAR(40) — NOT NULL
  • user_item_id — BIGINT — 외래 키 → user_items.id
  • saved_at — TIMESTAMP — NOT NULL

routine_logs

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • routine_id — BIGINT — 외래 키 → routines.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
  • created_at — TIMESTAMP — NOT NULL

routines

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • category_id — BIGINT — 외래 키 → categories.id
  • title — VARCHAR(160) — NOT NULL
  • auth_type — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • repeat_type — VARCHAR(40)
  • repeat_days — JSON
  • scheduled_time — TIME
  • starts_on — DATE
  • ends_on — DATE
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

streaks

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — 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

themes

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • cover_image_key — VARCHAR(255)
  • is_active — BOOLEAN — NOT NULL

todos

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • category_id — BIGINT — 외래 키 → 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

user_characters

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • character_id — BIGINT — 외래 키 → 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

user_goals

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • goal_id — BIGINT — 외래 키 → goals.id — NOT NULL
  • is_primary — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_items

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.id — NOT NULL
  • item_id — BIGINT — 외래 키 → items.id — NOT NULL
  • acquired_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

user_wallets

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → 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 — 기본 키 — NOT NULL
  • nickname — VARCHAR(30)
  • last_login_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP