name          sql                                                         
------------  ------------------------------------------------------------
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                       
                          )                                               

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                    
                          )                                               
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