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