database/gravity_sdoh.sqbpro

<?xml version="1.0" encoding="UTF-8"?><sqlb_project><db path="/Users/niloy/Documents/GitHub/SQL Agent Demo/sdoh/gravity_sdoh_observations.db" readonly="0" foreign_keys="1" case_sensitive_like="0" temp_store="0" wal_autocheckpoint="1000" synchronous="2"/><attached/><window><main_tabs open="structure browser pragmas query" current="0"/></window><tab_structure><column_width id="0" width="300"/><column_width id="1" width="0"/><column_width id="2" width="100"/><column_width id="3" width="10670"/><column_width id="4" width="0"/><expanded_item id="0" parent="1"/><expanded_item id="1" parent="1"/><expanded_item id="2" parent="1"/><expanded_item id="3" parent="1"/></tab_structure><tab_browse><current_table name="4,7:mainPatient"/><default_encoding codec=""/><browse_table_settings/></tab_browse><tab_sql><sql name="SQL 1">CREATE TABLE RiskScore (
    patient_id TEXT,       -- Reference to the patient
    risk_score DECIMAL(4, 2),  -- Risk score, a decimal value between 0.0 and 1.0
    risk_score_date TEXT,  -- Date of the risk score

    PRIMARY KEY (patient_id, risk_score_date)  -- Composite primary key: patient ID and risk score date
);
</sql><current_tab id="0"/></tab_sql></sqlb_project>