Checking structure phase 2
ALTER TABLE ipt_vital_sign_history_detail  ADD `ipt_vital_sign_history_detail_datetime` datetime NULL   
ALTER TABLE ipt_vital_sign_history_detail  ADD `vital_sign_value` varchar(250) NULL   
ALTER TABLE ipt_vital_sign_history_detail  ADD `vital_sign_id` int NOT NULL   
ALTER TABLE ipt_vital_sign_history_detail  ADD `ipt_vital_sign_history_id` int NOT NULL   
ALTER TABLE ipt_vital_sign_history  ADD `nurse_note` text NULL   
ALTER TABLE ipt_vital_sign_history  ADD `staff` varchar(50) NULL   
ALTER TABLE ipt_vital_sign_history  ADD `ipt_vital_sign_history_time` time NULL   
ALTER TABLE ipt_vital_sign_history  ADD `ipt_vital_sign_history_date` date NULL   
ALTER TABLE ipt_vital_sign_history  ADD `an` varchar(9) NOT NULL   
ALTER TABLE ipt_vital_sign  ADD `vital_sign_datetime` datetime NULL   
CREATE TABLE ipt_vital_sign_history_detail ( `ipt_vital_sign_history_detail_id` int NOT NULL  ) 
CREATE TABLE ipt_vital_sign_history ( `ipt_vital_sign_history_id` int NOT NULL  ) 
Checking structure phase 1