interface/forms/vitalsM/table.sql

   1 CREATE TABLE IF NOT EXISTS `form_vitalsM` (
   2 `id`                bigint(20)      NOT NULL auto_increment,
   3 `date`              datetime        default NULL,
   4 `pid`               bigint(20)      default 0,
   5 `user`              varchar(255)    default NULL,
   6 `groupname`         varchar(255)    default NULL,
   7 `authorized`        tinyint(4)      default 0,
   8 `activity`          tinyint(4)      default 0,
   9 `bps`               varchar(40)     default 0,
  10 `bpd`               varchar(40)     default 0,
  11 `weight`            FLOAT(5,2)      default 0,
  12 `height`            FLOAT(5,2)      default 0,
  13 `temperature`       FLOAT(5,2)      default 0,
  14 `temp_method`       VARCHAR(255)    default NULL,
  15 `pulse`             FLOAT(5,2)      default 0,
  16 `respiration`       FLOAT(5,2)      default 0,
  17 `note`              VARCHAR(255)    default NULL,
  18 `BMI`               FLOAT(4,1)      default 0,
  19 `BMI_status`        VARCHAR(255)    default NULL,
  20 `waist_circ`        FLOAT(5,2)      default 0,
  21 `head_circ`         FLOAT(5,2)      default 0,
  22 `oxygen_saturation` FLOAT(5,2)      default 0,
  23 PRIMARY KEY (id)
  24 ) TYPE=MyISAM;