data.schema.sql

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