Skip to content

Data Model

Status: Planned Last Updated: 2025-11-23

This documentation is planned but not yet written.

Temporary references (see project root): - See CLAUDE.md (Architecture section) for current architecture information - See internal/repository/sqlite/migrations.go for current schema - See internal/models/ for domain models

Planned Content

This page will cover:

  • Database Schema: Complete schema documentation with table descriptions
  • Entity Relationships: ER diagrams and relationship explanations
  • Migration System: How migrations work, adding new migrations, best practices
  • Data Types: Field types, constraints, and indexing strategies
  • Multi-tenancy Model: Organization-scoped data isolation patterns
  • Query Patterns: Common query patterns and performance considerations

This page will be completed in a future documentation task.