itemSimulator

Tables (5)

CharacterInventory

  • chrInvCode — int — Primary key — NOT NULL
  • characterCode — int — Foreign key → Characters.characterCode — NOT NULL
  • itemCode — int — Foreign key → Items.itemCode — NOT NULL
  • createdAt — datetime(3) — NOT NULL
  • updatedAt — datetime(3) — NOT NULL

CharacterItem

  • chrItemCode — int — Primary key — NOT NULL
  • characterCode — int — Foreign key → Characters.characterCode — NOT NULL
  • itemCode — int — Foreign key → Items.itemCode — NOT NULL
  • createdAt — datetime(3) — NOT NULL
  • updatedAt — datetime(3) — NOT NULL

Characters

  • characterCode — int — Primary key — NOT NULL
  • userCode — int — Foreign key → Users.userCode — NOT NULL
  • characterName — varchar(191) — NOT NULL
  • health — int — NOT NULL
  • power — int — NOT NULL
  • money — int — NOT NULL
  • createdAt — datetime(3) — NOT NULL
  • updatedAt — datetime(3) — NOT NULL

Items

  • itemCode — int — Primary key — NOT NULL
  • itemName — varchar(191) — NOT NULL
  • itemPrice — int — NOT NULL
  • power — int — NOT NULL
  • health — int — NOT NULL
  • createdAt — datetime(3) — NOT NULL
  • updatedAt — datetime(3) — NOT NULL

Users

  • userCode — int — Primary key — NOT NULL
  • userId — varchar(191) — NOT NULL
  • password — varchar(191) — NOT NULL
  • name — varchar(191) — NOT NULL
  • createdAt — datetime(3) — NOT NULL
  • updatedAt — datetime(3) — NOT NULL