players
| player_id | player_name |
|---|---|
| 1 | Chris |
| 2 | Michal |
| 3 | Cassie |
| 4 | Violet |
characters
| character_id | player_id | character_name | class | race | inventory_id |
|---|---|---|---|---|---|
| 1 | 1 | Arwen | Wizard | Elf | 1 |
| 2 | 2 | Gimli | Barbarian | Dwarf | 2 |
| 3 | 3 | Legolas | Ranger | Elf | 3 |
inventory
| inventory_id | item_name | weight | gold_value | description |
|---|---|---|---|---|
| 1 | Short Sword | 2.00 | 10.00 | A basic, non-magical sword |
| 2 | Greatsword | 6.00 | 50.00 | A heavy two-handed sword |
| 3 | Leather Armor | 4.00 | 15.00 | Basic protective armor |