루게더 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