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