name type ------------ ----- measurements table projects table 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 cid name type notnull dflt_value pk --- --------------- ---- ------- ----------- -- 0 project_id TEXT 1 1 1 measurement_key TEXT 1 2 2 value_mm REAL 1 0 3 notes TEXT 1 '' 0 4 status TEXT 1 'completed' 0 5 updated_at TEXT 1 0 project_rows ------------ 0 measurement_rows ---------------- 0