data.schema.sql

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