Sqlite Schema Repo Pattern

SQLite Schema + Repository Pattern

Trigger

Use this skill when:

• Domain tables or migrations are being introduced.
• Repository responsibilities are unclear or mixed.
• Data consistency rules must be enforced.

Do not use this skill when:

• Task is strictly UI styling or copy.

Source of Truth

• docs/illustration_versioning_spec_google_first.md
• Focus: domain model and technical stack sections.

Workflow

1. Translate domain entities into normalized schema.
2. Define keys, constraints, and status enum storage strategy.
3. Assign query ownership to repositories by aggregate boundary.
4. Validate transactional operations for save flows.
5. Invoke $self-review-gate.

Output Contract