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)