DurisMUD Engineering
Database Authority Model
DurisMUD database authority model
Data model showing account-scoped player revisions and components, idempotent critical operations, current balance and ownership rows reconciled to ledgers, disabled pending-policy lifecycle metadata, and immutable schema and lookup history.
PLAYER AUTHORITY
TRANSACTIONAL AUTHORITY
GOVERNANCE AND HISTORY
1
N
1
N
REVISION
1
N
SCOPES
1
N
1
N
RECORDS
1
N
RECONCILE
BLOCKED
ROOT
Account Identity
# accounts.account_name
account_characters.pid
credentials / status
CURRENT
Player Revision
# player_data.pid
save_revision
saved_at / metadata
one published revision
ROWS
Player Components
player_items / pets
skills / affects / timers
revision-bound assembly
linear materialization
OPERATION
Critical Inbox/Outbox
# operation_id
critical_operation_inbox
critical_outbox
status / result hash
exact retry identity
CURRENT
Current Authority
epic / currency balance
item_current_owner
item_owner_revision
auction / frag results
atomic current rows
LEDGER
Domain Ledgers
epic / currency / auction
item_ownership_ledger
combat / artifact / guild
operation-bound history
DISABLED
Lifecycle and Privacy Metadata
lifecycle_archive_jobs / batches / rows
personal_data_export_requests / sections
account_erasure_requests / tombstones
policy checksum / redacted evidence
PENDING CONTROLLER DECISIONS
no canonical mutation adapter
HISTORY
Schema and Dataset Identity
mud_schema_baselines
mud_schema_history / migration_state
lookup_dataset_state
immutable prefix / exact checksums
verified before service availability
LEGEND
# PRIMARY KEY
1 / N CARDINALITY
POLICY-BLOCKED ROUTE
docs/reference/DATABASE.md