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