rl-docs-hub

Home · Apps · rl-main-infra · todo_api · todo_mobile

---

DB Schema (Local-first)

todo_mobile persists primary state in Hive, then syncs to backend.

Hive Boxes

Box	Type	Purpose
lists	Box<Map>	Local cache of TodoList entities
todos	Box<Map>	Local cache of TodoItem entities
auth	Box<String>	Reserved app auth storage box
syncQueue	Box<Map>	Pending outbound sync jobs (SyncJob)

Entity Shapes

TodoList

• id: String (UUID)
• name: String
• description: String
• updatedAt: DateTime (UTC)
• deleted: bool (soft delete)
• version: int (conflict/version tracking)

TodoItem

• id: String (UUID)
• listId: String (parent list)
• title: String
• description: String
• dueDate: DateTime?
• labels: List<String>
• reminderAt: DateTime?
• completed: bool
• updatedAt: DateTime (UTC)
• deleted: bool (soft delete)
• version: int

SyncJob

• id: String
• entityType: String (e.g. todo, future entities)
• payload: Map<String, dynamic>
• updatedAt: DateTime (UTC)
• retries: int

Local Data Model

erDiagram
    TODO_LIST ||--o{ TODO_ITEM : contains
    TODO_ITEM ||--o{ SYNC_JOB : enqueued_as_payload

    TODO_LIST {
      string id PK
      string name
      string description
      datetime updatedAt
      bool deleted
      int version
    }

    TODO_ITEM {
      string id PK
      string listId FK
      string title
      string description
      datetime dueDate
      string[] labels
      datetime reminderAt
      bool completed
      datetime updatedAt
      bool deleted
      int version
    }

    SYNC_JOB {
      string id PK
      string entityType
      json payload
      datetime updatedAt
      int retries
    }

Notes

• Reads are served from Hive only (fast/offline UX).
• Soft-delete fields are preserved for sync semantics.
• version is used by conflict logic (serverWins, clientWins, manualMerge).