REST_Quest
Tables (9)
FriendRequest (friend)
- id — NOT NULL — Primary key — NOT NULL
- fromUserId (from_user_id) — NOT NULL — Foreign key → User.id — NOT NULL
- toUserId (to_user_id) — NOT NULL — Foreign key → User.id — NOT NULL
- status — NOTNULL
- createdAt (created_at) — NOTNULL
- deletedAt (deleted_at)
Item
- id — NOT NULL — Primary key — NOT NULL
- price — DEFAULT 0
- itemName (item_name) — NOT NULL
- rId (r_id) — NOT NULL
- description
- gemPrice (gem_price) — DEFAULT 0
- sellPrice (sell_price) — NOT NULL
- itemType (item_type) — NOT NULL
- itemGrade (item_grade) — NOT NULL
- goldCoupon (gold_coupon) — DEFAULT 0
- gemCoupon (gem_coupon) — DEFAULT 0
- expCoupon (exp_coupon) — DEFAULT 0
Npc (npc)
- id — NOT NULL — Primary key — NOT NULL
- rId (r_id) — NOT NULL
- name — NOT NULL
- description — NOT NULL
- locationKey (location_key) — NOT NULL
- active — DEFAULT 1
Profile (profile)
- id — NOT NULL — Primary key — NOT NULL
- level — NOT NULL
- exp — DEFAULT 0
- userId (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
Refresh_Token (Token)
- id — NOT NULL — Primary key — NOT NULL
- refreshToken — NOT NULL
- refreshTokenExpired (refreshToken_Expired) — NOT NULL
- userId (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
- isExpired (is_expired) — DEFAULT 0
- status — NOTNULL
User (user)
- id — NOT NULL — Primary key — NOT NULL
- email — NOT NULL
- password — NOT NULL
- nickname — NOT NULL
- role — NOT NULL
- status — NOT NULL
- provider — NOT NULL
- createdAt (created_at) — NOT NULL
- lastLoginAt (last_login_at) — DEFAULT NULL
- gemFloor (gem_floor) — DEFAULT 0
Wallet (wallet)
- id — NOT NULL — Primary key — NOT NULL
- gold — DEFAULT 3000
- gem — DEFAULT 100
- userId (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
npcItem
- id — NOT NULL — Primary key — NOT NULL
- npcId — NOT NULL — Foreign key → Npc.id — NOT NULL
- itemId — NOT NULL — Foreign key → Item.id — NOT NULL
- quantity — NOT NULL
- sortOrder (sort_order) — NOT NULL
userItem
- id — NOT NULL — Primary key — NOT NULL
- userId — NOT NULL — Foreign key → User.id — NOT NULL
- itemId (item_id) — NOT NULL — Foreign key → Item.id — NOT NULL
- quantity
- equipped (Boolean) — DEFAULT FALSE
- acquiredAt (acquired_at) — NOTNULL
- deletedAt (deleted_at)