GNvMwVPs

1CREATE TABLE IF NOT EXISTS Patient 
2( PatientId INTEGER PRIMARY KEY AUTOINCREMENT );
3
4CREATE TABLE IF NOT EXISTS Event 
5( 
6PatientId INTEGER REFERENCES Patient( PatientId ),
7DateTime TEXT,
8EventTypeCode TEXT,
9PRIMARY KEY( PatientId, DateTime, EventTypeCode )
10);
11
12CREATE TABLE IF NOT EXISTS Reading 
13( 
14PatientId INTEGER REFERENCES Patient( PatientId ),
15DateTime TEXT REFERENCES Event (DateTime),
16EventTypeCode TEXT REFERENCES Event (EventTypeCode),
17Value REAL,
18PRIMARY KEY( PatientId, DateTime, EventTypeCode )
19);
20	
21INSERT INTO Event (PatientId, DateTime, EventTypeCode) VALUES (1, '2011-01-23 19:26:59', 'R')
22	
23INSERT INTO Reading (PatientId, DateTime, EventTypeCode, Value) VALUES (1, '2011-01-23 19:26:59', 'R', 7.9)