schema.sql

   1 CREATE TABLE clinical(
   2 pid int,
   3 time int,
   4 data text
   5 );
   6 CREATE TABLE death(
   7 pid int,
   8 time int,
   9 data text
  10 );
  11 CREATE TABLE discharge(
  12 pid int,
  13 name text,
  14 dose text,
  15 route text,
  16 frequency text,
  17 duration text,
  18 addl text
  19 );
  20 CREATE TABLE patients(
  21 pid int unique,
  22 name text,
  23 age int,
  24 sex text,
  25 status text,
  26 diagnosis text,
  27 summary text,
  28 admission int,
  29 departure int,
  30 ward text,
  31 bed int,
  32 data text,
  33 history text
  34 );
  35 CREATE TABLE reports(
  36 pid int,
  37 time int,
  38 form text,
  39 data text
  40 );
  41 CREATE TABLE treatment(
  42 pid int,
  43 drug text,
  44 dose text,
  45 route text,
  46 frequency text,
  47 start int,
  48 end int,
  49 duration text,
  50 omit boolean,
  51 addl text
  52 );
  53 CREATE TABLE users(
  54 user text unique,
  55 usergroup text,
  56 hash text,
  57 change boolean,
  58 last int
  59 );