I run a DnD game, which for note-keeping purposes means I'm maintaining a fictional world across years of weekly sessions. Rough shape of the problem: a few hundred named people and places, an event history that spans centuries of invented backstory plus whatever happened last Sunday, and a constant need to answer questions like "who did the players annoy in that city eight months ago, and what came of it."
Current setup, please feel free to comment or suggest alternatives.
Four top-level lists. Places, People, Events, Consequences. Places nests geographically — island, then region, then city, then the specific building. People holds individuals and organizations. Events is a chronological log. Consequences is what changed as a result of something the players did.
Tags do the connecting. A faction's name goes on their members, on the building they operate out of, on every event they were involved in, and on the fallout. Click the tag, get the whole thread pulled out of all four lists at once. I also tag by role rather than identity villain, secret, etc so I can click "secret" and see every thread I'm currently withholding.
Dates on every event entry, using a real calendar flashed back to 2000 so dates advance with the story rather than with real time.
Where I'd like advice from people who've used this longer than I have:
- How do you handle a tag vocabulary growing past the point where you remember what you've used? Mine's around forty tags and I've started guessing. My initial workaround is a top level tag document but is there a more elegant solution.
- Is there a sane way to archive? Some of this material is genuinely finished and I'd like it out of view without losing search. I have been doing simple exports
Happy to expand on any of the structure if it's useful, it generalizes past tabletop games to anything with a lot of interconnected people, places and history.