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