phone
Tables (13)
character_equipment (장착 상태)
- id (pk) — bigint — Primary key — NOT NULL
- user_id (fk) — bigint — Foreign key → users.id — NOT NULL
- item_id (fk2) — bigint — Foreign key → items.id — NOT NULL
- slot_type (HAT/HEAD/BODY/SHOES/ACC) — ENUM
- equipped_at (장착 시각) — datetime
- UNIQUE (슬롯당 1개만) — (user_id, slot_type)
furniture (CopyOfUntitled3)
- id (pk) — bigint — Primary key — NOT NULL
- name (아이템 이름) — varchar(1000
- category (desk/chair/clock/bed/closet/lamp/window/frame) — ENUM
- rarity (common/rare/epic/legendary) — ENUM
- asset_address (3D 에셋 경로 / URL) — varchar(500)
- thumbnail_url (인벤토리 썸네일) — varchar(500)
- in_price (인게임 재화 가격)
group_users (Untitled9)
- id (pk) — Primary key — NOT NULL
- group_id (fk) — bigint — Foreign key → groups.id — NOT NULL
- user_id (fk2) — bigint — Foreign key → users.id — NOT NULL
groups (Untitled7)
- id (pk) — bigint — Primary key — NOT NULL
- goal (달성/안보기) — ENUM
- goal_time (달성) — datetime
- goal_start (안보기 시작) — datetime
- goal_end (안보기 끝) — datetime
items (Untitled3)
- id (pk) — bigint — Primary key — NOT NULL
- name (아이템 이름) — varchar(1000
- slot_type (hat/head/body/shoes/acc/pet/action) — ENUM
- rarity (common/rare/epic/legendary) — ENUM
- asset_address (3D 에셋 경로 / URL) — varchar(500)
- thumbnail_url (인벤토리 썸네일) — varchar(500)
- in_price (인게임 재화 가격) — bigint
room_furniture (Untitled6)
- id (pk) — bigint — Primary key — NOT NULL
- room_id (fk) — bigint — Foreign key → rooms.id — NOT NULL
- (ignore) — Foreign key → rooms.user_id — NOT NULL
- furniture_id (fk2) — bigint — Foreign key → furniture.id — NOT NULL
- pos_x (Field) — float
- pos_y (Field2) — float
- pos_z (Field3) — float
- rotation (Field4) — float
- placed_at (Field5) — datetime
rooms (Untitled4)
- id (pk) — bigint — Primary key — NOT NULL
- user_id (pk2) — bigint — Foreign key → users.id — NOT NULL
- name (Field) — varchar(50)
- created_at (Field2) — datetime
social_accounts (Untitled2)
- id (pk) — bigint — Primary key — NOT NULL
- user_id (pk2) — bigint — Foreign key → users.id — NOT NULL
- provider (apple/google/) — ENUM
- provider_id (OAuth 고유 ID) — varchar(200)
user_focus_time (Untitled10)
- Key — Primary key — NOT NULL
- user_id (fk) — bigint — Foreign key → users.id — NOT NULL
- focus_time (이번 세션 집중 시간) — datetime
user_furniture (Untitled5)
- idp (pk) — bigint — Primary key — NOT NULL
- user_id (fk) — bigint — Foreign key → users.id — NOT NULL
- furniture_id (fk2) — bigint — Foreign key → furniture.id — NOT NULL
- acquired_at (Field) — datetime
- UNIQUE ((user_id, furniture_id))
user_items (인벤토리)
- id (pk) — bigint — Primary key — NOT NULL
- user_id (fk2) — bigint — Foreign key → users.id — NOT NULL
- item-id (fk) — bigint — Foreign key → items.id — NOT NULL
- acquired_at (획득시간) — datetime
- UNIQUE (중복 소유 방지) — (user_id, item_id)
user_screen_time (Untitled8)
- Key — Primary key — NOT NULL
- user_id (fk) — bigint — Foreign key → users.id — NOT NULL
users (Untitled)
- id (pk) — bigint — Primary key — NOT NULL
- nickname (닉네임) — varchar(50)
- profile_image_url (프로필 이미지) — varchar(500)
- created_at (Field3) — datetime
- goal_time (스크린 타임 목표 시간 (보는거)) — datetime