item-simulator

Tables (5)

CharacterInventory

  • inventoryId — autoincrement — Primary key — NOT NULL
  • characterId — autoincrement — Foreign key → Characters.characterId — NOT NULL
  • itemId (itemis) — autoIncrement — Foreign key → Items.itemId — NOT NULL
  • itemCount — Not null
  • createdAt — Not null
  • updatedAt — Not null

CharacterItems

  • characterItemId — autoincrement — Primary key — NOT NULL
  • inventoryId — autoincrement — Foreign key → CharacterInventory.inventoryId — NOT NULL

Characters

  • characterId — autoincrement — Primary key — NOT NULL
  • userId — autoincrement — Foreign key → Users.userId — NOT NULL
  • characterName — Not null
  • health — Not null
  • power — Not null
  • money — null
  • createdAt — Not null

Items

  • itemId (itemis) — autoIncrement — Primary key — NOT NULL
  • itemName — Not null
  • itemPrice — Not null
  • itemHealth — Not null
  • itemPower — Not null
  • createdAt — Not null
  • updatedAt — Not null

Users

  • userId — autoincrement — Primary key — NOT NULL
  • id — Not null
  • password — Not null
  • userName — Notnull
  • createdAt — Not null
  • updatedAt — Not null