Hero's Harvest ERD

Tables (5)

CharacterInventory

  • CharacterUniqueID — Long — Foreign key → UserCharacterOverview.CharacterUniqueID — NOT NULL
  • User Unique ID — Long — Foreign key → UserCharacterOverview.User Unique ID — NOT NULL
  • InventoryNumber — Int
  • ItemName — varchar(30)

PlayerLocation

  • CharacterUniqueID — Long — Foreign key → UserCharacterOverview.CharacterUniqueID — NOT NULL
  • User Unique ID — Long — Foreign key → UserCharacterOverview.User Unique ID — NOT NULL
  • PositionX — double
  • PositionY — double

UserAccount

  • User Unique ID — Long — Primary key — NOT NULL — AutoIncrement
  • ID — varchar(20)
  • Password — varchar(20)
  • Email — varchar(30)
  • Name — varchar(30)
  • Nickname — varchar(30)

UserCharacterOverview

  • CharacterUniqueID — Long — Primary key — NOT NULL
  • User Unique ID — Long — Foreign key → UserAccount.User Unique ID — NOT NULL
  • CharacterNickname — varchar(20)
  • CharacterSlotNumber (ChaaracterSlotNumber) — Int

UserCharacterStatus

  • CharacterUniqueID — Long — Foreign key → UserCharacterOverview.CharacterUniqueID — NOT NULL
  • User Unique ID — Long — Foreign key → UserCharacterOverview.User Unique ID — NOT NULL
  • CharacterNickname — varchar(20)
  • CharacterLevel — Int
  • CharacterHP — double
  • CharacterMP — double
  • CharacterStamina — double
  • Gold — Long
  • CharacterExp — Long