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
หัวข้อ: HOSxP 3.55.2.27 (อ่าน 24281 ครั้ง)