lupa

Tables (9)

Pet (펫)

  • uid (Key2) — String — Foreign key → user.uid — NOT NULL
  • pet_uid (Field7) — String
  • name (Field5) — String
  • character_asset_key (Field) — String
  • personality (Field6) — String
  • satiety (Field2) — int
  • vitality (Field8) — int
  • is_egg (Field3) — boolean
  • is_sleep (Field4) — boolean
  • updated_at (Field9) — LocalDateTime

Pet_equipped_itmes (펫 착장)

  • pet_uid (Key22) — String — Foreign key → Pet.uid — NOT NULL
  • item_id (Field) — int

friend_request (친구요청)

  • uid (Key) — String — Foreign key → user.uid — NOT NULL
  • to_user_id (Key2) — String — Foreign key → user.uid — NOT NULL
  • ceated_at (Field) — LocalDateTime
  • responded_at (Field2) — LocalDateTime
  • status (Field3) — String

friendship (친구 목록)

  • uid (Key2) — String — Foreign key → user.uid — NOT NULL
  • friend_uid (Field) — String
  • friends_since (Field2) — LocalDateTime
  • status (Field3) — String

furniture (방 가구)

  • uid (Key2) — String — Foreign key → user.uid — NOT NULL
  • furniture_id (Field) — Long
  • x (Field2) — int
  • y (Field3) — int
  • direction (Field4) — int
  • status (Field5) — String

inven (인벤토리)

  • uid (Key2) — String — Foreign key → user.uid — NOT NULL
  • item_id (Field) — int
  • item_count (Field2) — int
  • item_name (Field3) — String
  • instance_id (Field4) — String

items (아이템 목록)

  • item_id (Key) — int — Primary key — NOT NULL
  • price (Field) — int
  • item_name (Field2) — String

room (방 벽지 및 타일)

  • uid (Key2) — String — Foreign key → user.uid — NOT NULL
  • wall_type (Field) — String
  • floor_tile_type (Field2) — Stirng

user (유저)

  • uid (Key) — String — Primary key — NOT NULL
  • kakao_id (Field6) — Long
  • nickname (Field) — String
  • friend_code (Field3) — String
  • gold (Field4) — Long
  • last_hearbeat_at (Field2) — LocalDateTime