Skip to content

Data Model

Jump to bottom
Daniel Boles edited this page Oct 29, 2026 · 1 revision

Mirrored from docs/architecture/DATA_MODEL.md (content sha256 4a627d25faab) by scripts/Sync-Wiki.ps1. Edit the source, not this page -- the next sync overwrites it.

Data Model

SQLite is the default local metadata store.

Proposed tables:

  • documents
  • document_versions
  • projects
  • tasks
  • steps
  • prompts
  • rosettas
  • artifacts
  • artifact_metadata
  • notes
  • topics
  • entities
  • tags
  • relationships
  • semantic_metadata
  • embeddings
  • filename_candidates
  • file_events
  • recovery_sessions
  • clipboard_items
  • notebook_cells
  • notebook_outputs
  • security_events
  • signatures
  • integrity_checks
  • settings
  • schema_migrations

Sensitive rows must inherit the owning document/project security policy.

Generated from dboles99/bachelorpadplus_rust@feat/phase-01-foundation-ui by scripts/Sync-Wiki.ps1. Licence: GPL-3.0-only.

BachelorPad+

Start here

Design

Memory

Working on it

Clone this wiki locally