sesac_manufacturing_v0.3

Tables (15)

citations

  • id — INTEGER — Primary key — NOT NULL
  • request_id — TEXT — Foreign key → evidence_bundles.request_id — NOT NULL
  • source_id — TEXT — NOT NULL
  • doc_type — TEXT
  • text — TEXT

evidence_bundles

  • request_id — TEXT — Foreign key → requests.request_id — NOT NULL
  • retrieval_profile — TEXT
  • queries_json — TEXT
  • evidence_summary — TEXT
  • created_at — TEXT — NOT NULL

gate_reports

  • id — INTEGER — Primary key — NOT NULL
  • request_id — TEXT — Foreign key → requests.request_id — NOT NULL
  • gate_name — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • route_hint — TEXT
  • reason — TEXT
  • seq — INTEGER
  • created_at — TEXT — NOT NULL

machine_values

  • id — INTEGER — Primary key — NOT NULL
  • session_id — TEXT — Foreign key → sessions.session_id — NOT NULL
  • name — TEXT — NOT NULL
  • value — TEXT — NOT NULL
  • unit — TEXT
  • created_at — TEXT — NOT NULL

machine_values_v2

  • id — INTEGER — Primary key — NOT NULL
  • session_id — TEXT — Foreign key → sessions.session_id — NOT NULL
  • request_id — TEXT — Foreign key → requests.request_id
  • name — TEXT — NOT NULL
  • value — TEXT — NOT NULL
  • unit — TEXT
  • is_current — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL

prediction_mode_probs

  • failure_mode — TEXT — Primary key — NOT NULL
  • request_id — TEXT — Foreign key → predictions_v2.request_id — NOT NULL
  • prob — REAL — NOT NULL

predictions

  • id — INTEGER — Primary key — NOT NULL
  • request_id — TEXT — Foreign key → requests.request_id — NOT NULL
  • session_id — TEXT — Foreign key → sessions.session_id — NOT NULL
  • created_at — TEXT — NOT NULL
  • execution_mode — TEXT
  • status — TEXT
  • failure_prob — REAL
  • risk_level — TEXT
  • likely_failure — TEXT
  • schema_version — TEXT
  • artifact_json — TEXT — NOT NULL

predictions_v2

  • request_id — TEXT — Foreign key → requests.request_id — NOT NULL
  • session_id — TEXT — Foreign key → sessions.session_id — NOT NULL
  • created_at — TEXT — NOT NULL
  • execution_mode — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • failure_prob — REAL
  • risk_level — TEXT
  • likely_failure — TEXT
  • model_name — TEXT
  • model_source — TEXT
  • model_version — TEXT
  • schema_version — TEXT — NOT NULL
  • artifact_json — TEXT — NOT NULL

requests

  • request_id — TEXT — Primary key — NOT NULL
  • session_id — TEXT — Foreign key → sessions.session_id — NOT NULL
  • user_message — TEXT — NOT NULL
  • intent — TEXT
  • final_status — TEXT
  • latency_ms — INTEGER
  • created_at — TEXT — NOT NULL

runs

  • id — INTEGER — Primary key — NOT NULL
  • request_id — TEXT — Foreign key → requests.request_id — NOT NULL
  • session_id — TEXT — Foreign key → sessions.session_id — NOT NULL
  • trace_json — TEXT — NOT NULL
  • created_at — TEXT — NOT NULL

safety_decisions

  • request_id — TEXT — Foreign key → requests.request_id — NOT NULL
  • risk_level — TEXT — NOT NULL
  • blocked — INTEGER — NOT NULL
  • forbidden_actions — TEXT
  • required_safety_notes — TEXT
  • summary — TEXT
  • created_at — TEXT — NOT NULL

sessions

  • session_id — TEXT — Primary key — NOT NULL
  • created_at — TEXT — NOT NULL
  • last_seen_at — TEXT — NOT NULL
  • meta_json — TEXT

summaries

  • id — INTEGER — Primary key — NOT NULL
  • session_id — TEXT — Foreign key → sessions.session_id — NOT NULL
  • kind — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TEXT — NOT NULL

turns

  • id — INTEGER — Primary key — NOT NULL
  • session_id — TEXT — Foreign key → sessions.session_id — NOT NULL
  • role — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TEXT — NOT NULL

turns_v2

  • id — INTEGER — Primary key — NOT NULL
  • session_id — TEXT — Foreign key → sessions.session_id — NOT NULL
  • request_id — TEXT — Foreign key → requests.request_id
  • role — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TEXT — NOT NULL