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