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