The healthcare database is the users relation under
chronobot directory on iPage.  The following is
the SQL script to define healthcare database.


CREATE TABLE  `users` (
 `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 `last_name` VARCHAR( 20 ) CHARACTER SET latin1 COLLATE
latin1_swedish_ci NOT NULL ,
 `first_name` VARCHAR( 20 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL ,
 `email` VARCHAR( 30 ) CHARACTER SET latin1 COLLATE
latin1_swedish_ci NOT NULL ,
 `date` VARCHAR( 30 ) CHARACTER SET latin1 COLLATE
latin1_swedish_ci NOT NULL ,
 `SPO2DataStream` VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL ,
 `Systolic` INT( 11 ) NOT NULL ,
 `Diastolic` INT( 11 ) NOT NULL ,
 `Pulse` INT( 11 ) NOT NULL ,
 `BloodPressureDataStream` VARCHAR( 30 ) CHARACTER SET
latin1 COLLATE latin1_swedish_ci NOT NULL ,
 `DateTimeBP` VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL ,
 `DateTimeSPO2` VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL ,
 `EKGDataStream` VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL ,
 `DateTimeEKG` VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL ,
 `TemperatureDataStream` VARCHAR( 30 ) CHARACTER SET
latin1 COLLATE latin1_swedish_ci NOT NULL ,
 `DateTimeTemperature` VARCHAR( 30 ) CHARACTER SET
latin1 COLLATE latin1_swedish_ci NOT NULL
) ENGINE = MYISAM ;




The following is the SQL script to add attributes
to the healthcare database.


ALTER TABLE  `users` ADD  `BloodPressureDataStream`
VARCHAR( 30 ) CHARACTER SET latin1 COLLATE
latin1_swedish_ci NOT NULL ,
ADD  `DateTimeBP` VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL ,
ADD  `DateTimeSPO2` VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL ,
ADD  `EKGDataStream` VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL ,
ADD  `DateTimeEKG` VARCHAR( 30 ) CHARACTER SET latin1
COLLATE latin1_swedish_ci NOT NULL ,
ADD  `TemperatureDataStream` VARCHAR( 30 ) CHARACTER
SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
ADD  `DateTimeTemperature` VARCHAR( 30 ) CHARACTER SET
latin1 COLLATE latin1_swedish_ci NOT NULL ;