integrity_check --------------- ok name type --------------------------------------- ------- design_forge_snapshots_project_idx index design_forge_snapshots_sha_idx index measurement_revisions_record_idx index measurement_session_records_project_idx index measurement_sessions_project_idx index snapshot_supersessions_snapshot_idx index design_forge_measurement_snapshots table design_forge_snapshot_supersessions table measurement_revisions table measurement_session_records table measurement_sessions table measurements table projects table design_forge_snapshots_no_delete trigger design_forge_snapshots_no_update trigger measurement_revisions_no_delete trigger measurement_revisions_no_update trigger snapshot_supersessions_no_delete trigger snapshot_supersessions_no_update trigger cid name type notnull dflt_value pk --- ---------------- ------- ------- ---------- -- 0 id TEXT 0 1 1 name TEXT 1 0 2 reference_id TEXT 1 '' 0 3 side TEXT 1 0 4 cover_class TEXT 1 0 5 osseointegration INTEGER 1 0 0 6 specialist_name TEXT 1 '' 0 7 clinic_name TEXT 1 '' 0 8 exclusion_zones TEXT 1 '' 0 9 component_notes TEXT 1 '' 0 10 review_notes TEXT 1 '' 0 11 created_at TEXT 1 0 12 updated_at TEXT 1 0 13 oi_type TEXT 1 'none' 0 cid name type notnull dflt_value pk --- ------------- ---- ------- ---------- -- 0 id TEXT 0 1 1 project_id TEXT 1 0 2 status TEXT 1 0 3 guide_version TEXT 1 0 4 started_at TEXT 1 0 5 completed_at TEXT 0 0 6 created_at TEXT 1 0 7 updated_at TEXT 1 0 cid name type notnull dflt_value pk --- --------------- ---- ------- ----------- -- 0 session_id TEXT 1 1 1 project_id TEXT 1 0 2 measurement_key TEXT 1 2 3 value_mm REAL 1 0 4 notes TEXT 1 '' 0 5 status TEXT 1 'completed' 0 6 updated_at TEXT 1 0 cid name type notnull dflt_value pk --- ----------------- ---- ------- ---------- -- 0 id TEXT 0 1 1 project_id TEXT 1 0 2 session_id TEXT 0 0 3 measurement_key TEXT 1 0 4 previous_value_mm REAL 0 0 5 new_value_mm REAL 1 0 6 previous_notes TEXT 1 '' 0 7 new_notes TEXT 1 '' 0 8 previous_status TEXT 0 0 9 new_status TEXT 1 0 10 change_reason TEXT 1 0 11 changed_by TEXT 1 0 12 changed_at TEXT 1 0 cid name type notnull dflt_value pk --- --------------- ------- ------- ---------- -- 0 id TEXT 0 1 1 project_id TEXT 1 0 2 session_id TEXT 0 0 3 snapshot_json TEXT 1 0 4 snapshot_sha256 TEXT 1 0 5 created_at TEXT 1 0 6 immutable INTEGER 1 1 0 cid name type notnull dflt_value pk --- ----------- ---- ------- ---------- -- 0 id TEXT 0 1 1 snapshot_id TEXT 1 0 2 project_id TEXT 1 0 3 revision_id TEXT 1 0 4 reason TEXT 1 0 5 created_at TEXT 1 0