type   name                             tbl_name      sql                                                         
-----  -------------------------------  ------------  ------------------------------------------------------------
index  sqlite_autoindex_measurements_1  measurements                                                              

index  sqlite_autoindex_projects_1      projects                                                                  

table  measurements                     measurements  CREATE TABLE measurements (                                 
                                                                      project_id TEXT NOT NULL,                   
                                                                      measurement_key TEXT NOT NULL,              
                                                                      value_mm REAL NOT NULL,                     
                                                                      notes TEXT NOT NULL DEFAULT '',             
                                                                      status TEXT NOT NULL DEFAULT 'completed',   
                                                                      updated_at TEXT NOT NULL,                   
                                                                      PRIMARY KEY (project_id, measurement_key),  
                                                                      FOREIGN KEY (project_id)                    
                                                                          REFERENCES projects(id)                 
                                                                          ON DELETE CASCADE                       
                                                                  )                                               

table  projects                         projects      CREATE TABLE projects (                                     
                                                                      id TEXT PRIMARY KEY,                        
                                                                      name TEXT NOT NULL,                         
                                                                      reference_id TEXT NOT NULL DEFAULT '',      
                                                                      side TEXT NOT NULL,                         
                                                                      cover_class TEXT NOT NULL,                  
                                                                      osseointegration INTEGER NOT NULL DEFAULT 0,
                                                                      specialist_name TEXT NOT NULL DEFAULT '',   
                                                                      clinic_name TEXT NOT NULL DEFAULT '',       
                                                                      exclusion_zones TEXT NOT NULL DEFAULT '',   
                                                                      component_notes TEXT NOT NULL DEFAULT '',   
                                                                      review_notes TEXT NOT NULL DEFAULT '',      
                                                                      created_at TEXT NOT NULL,                   
                                                                      updated_at TEXT NOT NULL                    
                                                                  )