Skip to content
Self-Engine

Schema & Types

@life-manager/db has four distinct type and schema layers.

1. PowerSync Schema

Section titled “1. PowerSync Schema”

The offline database schema lives in packages/db/src/schema.ts and is exported as AppSchema from @life-manager/db/schema.

Relevant API pages:

Current Tables

Section titled “Current Tables”

The schema currently defines 20 tables.

System

Section titled “System”
  • profiles
  • settings
  • notification

Work

Section titled “Work”
  • appointment
  • work_project
  • work_project_tag
  • work_folder
  • work_time_entry
  • time_tracker

Finance

Section titled “Finance”
  • bank_account
  • tag
  • contact
  • finance_project
  • finance_project_adjustment
  • finance_project_tag
  • recurring_cashflow
  • recurring_cashflow_tag
  • single_cashflow
  • single_cashflow_tag
  • payout

2. Supabase-generated DB Types

Section titled “2. Supabase-generated DB Types”

The generated database types live in packages/db/src/supabase.types.ts and are exposed through @life-manager/db/supabase.

Use these when you need exact table-level types such as:

  • Tables<"...">
  • TablesInsert<"...">
  • TablesUpdate<"...">
  • Enums<"...">

This is the lowest-level typed interface to the underlying database model.

3. Domain Type Barrels

Section titled “3. Domain Type Barrels”

The package exposes domain-oriented type barrels:

  • @life-manager/db/types/work
  • @life-manager/db/types/finance
  • @life-manager/db/types/system

These are mostly re-exports of entity-local types and are the preferred app-facing type layer.

Example API pages:

4. Validation / Deserialization Schemas

Section titled “4. Validation / Deserialization Schemas”

Each entity owns local Zod schemas in <entity>.schema.ts.

Those schemas are used when building collections in createAllCollections() so the offline layer can:

  • validate incoming records
  • deserialize DB values into domain shapes
  • reject malformed local or synced rows

The compatibility barrel @life-manager/db/schemas re-exports these schemas.

Practical Rule

Section titled “Practical Rule”

Choose the layer that matches your job:

  • use @life-manager/db/supabase for exact DB-level typing
  • use @life-manager/db/types/* for app/domain typing
  • use entity-local schema files or @life-manager/db/schemas for validation and deserialization
  • use AppSchema only when working on the runtime or collection bootstrap layer