Skip to main content

Data Model

Documentation Map​

Data Model

Core Entities​

Project​

  • primary operator scope boundary
  • referenced by most other domain objects
  • carries settings, integrations, and dashboard state

Task​

  • canonical work item in Mission Control
  • linked to a lane
  • may be mirrored to repo issues and Plane issues

Lane​

  • board-state bucket for tasks
  • drives work-board visibility and sync semantics

Agent​

  • operator/runtime-facing identity used for assignment and dispatch visibility

Handoff​

  • explicit transfer or blocked-work contract between actors

Planning Objects​

  • cycle
  • module
  • knowledge page

These structure project planning and can be synchronized or projected to external planning surfaces.

Delivery Objects​

  • pipeline
  • deployment
  • release
  • environment

These normalize provider delivery state into operator-facing objects.

Integration Connection​

  • stores provider-specific connection metadata
  • examples:
    • repo provider connections
    • Plane connection
    • n8n configuration

External Mapping​

  • links local Mission Control entities to external IDs
  • examples:
    • Plane issue mapping
    • repo issue mapping

Audit Entry​

  • operational trace for sync, mutation, recovery, and runtime work

Snapshot​

  • project-state recovery checkpoint

Key Relationships​

  • one project -> many tasks
  • one project -> many planning objects
  • one project -> many delivery objects
  • one task -> one current lane
  • one project -> many integration connections
  • one local object -> zero or many external mappings depending on sync surface

Important IDs / Keys​

  • project_id
  • task_key
  • provider external IDs
  • Plane object IDs
  • connection keys such as provider connection identifiers
  • page slug

Persistence Assumptions​

  • PostgreSQL is the canonical runtime data store
  • Git repository history remains the canonical persisted source for verified repo changes and documentation
  • external mappings are required to reconcile local and remote state deterministically

Integration Relevance​

The most integration-relevant entities are:

  • project
  • task
  • lane
  • integration connection
  • external mapping
  • knowledge page
  • audit entry

License: AGPLv3

Helpifyr: https://helpifyr.com