e4a5c81
main
Database
▸Dungeon Master's Vault
A live tabletop RPG campaign generates more state than a spreadsheet can handle — characters,
inventory, quests, gear, and loot all have complex relationships. This MySQL database models that
domain properly: 3NF schema across 5 tables, a many-to-many inventory bridge, and a deliberate
indexing strategy (FK joins, text search, boolean flags, composite indexes for equipped gear).
Gameplay queries cover character sheets, encumbrance, quest tracking, and loot extraction.
mysqlsqlschema design
indexinglucidchart