Data index
Every table in the schema, what it holds, and where its contract is written down.
48 tables, 22 of them with no specification. That number is the reason this page exists: an undocumented table is invisible until somebody needs it, and a list of them is a countable gap rather than a vague one.
Generated from
packages/server-core/src/dbSchema.ts. The table list is read from the schema, so a new table appears here as a row with no spec yet rather than not appearing at all.
The ~35 per-entity specifications are deliberately deferred. They wait on
the actor model — the users
table and actor resolution — because roughly 34 columns across these tables
currently hold an identity provider's string rather than a foreign key. Writing
an entity spec before that lands means writing it twice, which is why they were
deferred ahead of v0.61.0 and still are.
| Table | What it holds | Contract |
|---|---|---|
attribute_groups |
How a system groups attributes on a sheet | System API |
bars |
Token bar definitions — the value function behind each | System API |
campaign_actions |
Action scripts persisted on a campaign | Action API |
campaign_characters |
Which characters belong to a campaign | no spec yet |
campaign_functions |
Campaign-scoped functions injected into action scope | Action API |
campaign_invites |
Outstanding invitations to a campaign | REST API |
campaign_members |
Who is in a campaign, and in what role | REST API |
campaigns |
A campaign — the top-level container for play | no spec yet |
character_access_requests |
Requests to be granted access to a character | REST API |
character_factions |
Faction membership per character | no spec yet |
character_invites |
Outstanding invitations to a character | REST API |
character_permissions |
Per-user read/edit grants on a character | REST API |
characters |
A character sheet and everything on it | no spec yet |
chat_messages |
The chat log, including the combat log's tagged entries | Realtime API |
conditions |
Status conditions a system defines | System API |
currencies |
Currency denominations a system defines | System API |
damage_types |
Damage types a system defines | System API |
deleted_items |
Soft-deleted rows, for undelete | REST API |
drawings |
Shapes drawn on a map | no spec yet |
entity_access_counts |
Access tallies behind the frequently-accessed lists | no spec yet |
equipment |
Equipment carried by a character | no spec yet |
faction_relationships |
How factions regard one another | no spec yet |
factions |
A faction | no spec yet |
fixture_versions |
Which fixture version a system has been seeded to | System API |
fog_of_war_shapes |
Revealed and hidden regions on a map | no spec yet |
ledger_entries |
A character's ledger | no spec yet |
library_item_tags |
Tags on a library asset — the join the map generator queries | REST API |
library_items |
The asset library | REST API |
light_source_types |
Light source types a system defines | System API |
map_generations |
Map generation requests and their results | AI API |
map_layers |
The layer stack on a map | no spec yet |
map_objects |
Objects placed on a map that are not tokens | no spec yet |
maps |
A map | no spec yet |
messages |
Notifications and messages sent to a user | Realtime API |
parties |
A party | no spec yet |
party_characters |
Which characters are in a party | no spec yet |
party_factions |
Which factions a party belongs to | no spec yet |
prop_types |
Prop types a system defines | System API |
property_definitions |
The properties a system gives a character or token | System API |
roll_table_entries |
Rows of a roll table | no spec yet |
roll_tables |
A roll table | no spec yet |
systems |
A game system and its inherited trait tables | System API |
token_permissions |
Per-user read/edit/delete grants on a token | REST API |
tokens |
A token on a map | no spec yet |
user_settings |
Per-user preferences | no spec yet |
validation_rule_preferences |
Which validation rules a user has turned off, and where | no spec yet |
vbl_shapes |
Vision-blocking geometry on a map | AI API |
vision_types |
Vision types a system defines | System API |