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