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