Workable version

[simpleipd.git] / schema.sql

diff --git a/schema.sql b/schema.sql
index a202092ab6f30bc8ca2795a8b6df407c87ceab43..855f5de41aa2bf2020afc7629dbc12cd6dc995f0 100644 (file)
--- a/schema.sql
+++ b/schema.sql
@@ -3,15 +3,18 @@ pid int,
 time int,
 data text
 );
-CREATE TABLE drugs(
+CREATE TABLE death(
+pid int,
+time int,
+data text
+);
+CREATE TABLE discharge(
 pid int,
 name text,
 dose text,
 route text,
 frequency text,
-start int,
 duration text,
-omit boolean,
 addl text
 );
 CREATE TABLE patients(
@@ -20,7 +23,14 @@ name text,
 age int,
 sex text,
 status text,
-data text
+diagnosis text,
+summary text,
+admission int,
+departure int,
+ward text,
+bed int,
+data text,
+history text
 );
 CREATE TABLE reports(
 pid int,
@@ -28,3 +38,14 @@ time int,
 form text,
 data text
 );
+CREATE TABLE treatment(
+pid int,
+name text,
+dose text,
+route text,
+frequency text,
+start int,
+duration text,
+omit boolean,
+addl text
+);