DASH

Tables (9)

change_log

  • seq — INTEGER — Primary key — NOT NULL
  • kind — TEXT — NOT NULL
  • event_pk — INTEGER — Foreign key → events.event_pk
  • failure_id — INTEGER — Foreign key → ingest_failures.failure_id
  • project_id — INTEGER — Foreign key → projects.project_id
  • committed_at — TEXT — NOT NULL
  • CHECK((kind=event — AND — NOT NULL

events

  • event_pk — INTEGER — Primary key — NOT NULL
  • project_id — INTEGER — Foreign key → projects.project_id — NOT NULL
  • event_id — TEXT — NOT NULL
  • ts — TEXT — NOT NULL
  • v — INTEGER — NOT NULL
  • source — TEXT
  • agent — TEXT — NOT NULL
  • event_type — TEXT — NOT NULL
  • session_id — TEXT — NOT NULL
  • cwd — TEXT — NOT NULL
  • agent_id — TEXT
  • agent_type — TEXT
  • thread_id — TEXT
  • turn_id — TEXT
  • request_id — TEXT
  • skill — TEXT
  • skill_run_id — TEXT
  • attribution — TEXT
  • recommended_next_skill — TEXT
  • submission_id — TEXT
  • prompt — TEXT
  • invocation — TEXT
  • observed_via — TEXT
  • parent_run_id — TEXT
  • run_sequence — INTEGER
  • model_status — TEXT — NOT NULL
  • model_issues_json — TEXT — NOT NULL
  • raw_bytes — BLOB — NOT NULL
  • canonical_hash — TEXT — NOT NULL
  • received_at — TEXT — NOT NULL

handoff_targets

  • position — INTEGER — Primary key — NOT NULL
  • event_pk — INTEGER — Foreign key → events.event_pk — NOT NULL
  • target_skill — TEXT — NOT NULL

ingest_failures

  • failure_id — INTEGER — Primary key — NOT NULL
  • failure_key — TEXT — NOT NULL
  • event_pk — INTEGER — Foreign key → events.event_pk
  • project_id — INTEGER — Foreign key → projects.project_id
  • filename — TEXT — NOT NULL
  • raw_hash — TEXT — NOT NULL
  • reason_code — TEXT — NOT NULL
  • raw_bytes — BLOB — NOT NULL
  • observed_at — TEXT — NOT NULL

legacy_imports

  • import_id — INTEGER — Primary key — NOT NULL
  • relative_path — TEXT — NOT NULL
  • file_sha256 — TEXT — NOT NULL
  • byte_size — INTEGER — NOT NULL
  • total_lines — INTEGER — NOT NULL
  • imported_lines — INTEGER — NOT NULL
  • duplicate_lines — INTEGER — NOT NULL
  • failed_lines — INTEGER — NOT NULL
  • next_line — INTEGER — NOT NULL
  • state — TEXT — NOT NULL
  • verified_at — TEXT
  • deleted_at — TEXT
  • error_code — TEXT

projects

  • project_id — INTEGER — Primary key — NOT NULL
  • slug — TEXT — NOT NULL
  • root_key — TEXT — NOT NULL
  • root — TEXT — NOT NULL
  • display_name — TEXT — NOT NULL
  • created_at — TEXT — NOT NULL

schema_meta

  • singleton_id — INTEGER — Primary key — NOT NULL
  • database_id — TEXT — NOT NULL
  • schema_version — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL
  • migrated_at — TEXT — NOT NULL

submission_skills

  • position — INTEGER — Primary key — NOT NULL
  • event_pk — INTEGER — Foreign key → events.event_pk — NOT NULL
  • skill — TEXT — NOT NULL

usage_measurements

  • usage_key — TEXT — Primary key — NOT NULL
  • event_pk — INTEGER — Foreign key → events.event_pk — NOT NULL
  • input_tokens — INTEGER — NOT NULL
  • output_tokens — INTEGER — NOT NULL
  • cache_read_tokens — INTEGER
  • cache_write_tokens — INTEGER
  • reasoning_tokens — INTEGER
  • kind — TEXT — NOT NULL
  • measurement_hash — TEXT — NOT NULL