HOSxP Version 3.54.4.28
Checking structure phase 2
ALTER TABLE lab_form_head ADD `out_lab` char(1) NULL
ALTER TABLE ekg_result_image ADD `ekg_result_note` text NULL
ALTER TABLE ekg_result_image ADD `ekg_result_doctor` varchar(20) NULL
ALTER TABLE ekg_result_image ADD `ekg_result_image_blob` longblob NULL
ALTER TABLE ekg_request_status ADD `ekg_request_status_name` varchar(150) NOT NULL
ALTER TABLE ekg_request ADD `hn` varchar(9) NULL
ALTER TABLE ekg_request ADD `ekg_request_note` text NULL
ALTER TABLE ekg_request ADD `ekg_report_time` time NULL
ALTER TABLE ekg_request ADD `ekg_report_date` date NULL
ALTER TABLE ekg_request ADD `ekg_report_doctor` varchar(10) NULL
ALTER TABLE ekg_request ADD `ekg_request_status_id` int NOT NULL
ALTER TABLE ekg_request ADD `ekg_request_doctor` varchar(10) NULL
ALTER TABLE ekg_request ADD `ekg_item_id` int NOT NULL
ALTER TABLE ekg_request ADD `an` varchar(9) NULL
ALTER TABLE ekg_request ADD `vn` varchar(12) NULL
ALTER TABLE ekg_request ADD `patient_department` char(3) NULL
ALTER TABLE ekg_request ADD `ekg_request_time` time NULL
ALTER TABLE ekg_request ADD `ekg_request_date` date NULL
ALTER TABLE ekg_item ADD `icd9cm` varchar(10) NULL
ALTER TABLE ekg_item ADD `ipd_price3` double(15,3) NULL
ALTER TABLE ekg_item ADD `ipd_price2` double(15,3) NULL
ALTER TABLE ekg_item ADD `ipd_price1` double(15,3) NULL
ALTER TABLE ekg_item ADD `price3` double(15,3) NULL
ALTER TABLE ekg_item ADD `price2` double(15,3) NULL
ALTER TABLE ekg_item ADD `price1` double(15,3) NULL
ALTER TABLE ekg_item ADD `icode` char(7) NULL
ALTER TABLE ekg_item ADD `ekg_item_name` varchar(200) NOT NULL
ALTER TABLE cancer_icd10 ADD `account_id` int NULL
CREATE TABLE ekg_result_image ( `ekg_result_image_id` int NOT NULL )
CREATE TABLE ekg_request_status ( `ekg_request_status_id` int NOT NULL )
CREATE TABLE ekg_request ( `ekg_request_id` int NOT NULL )
CREATE TABLE ekg_item ( `ekg_item_id` int NOT NULL )
CREATE TABLE cancer_icd10 ( `icd10` varchar(9) NOT NULL )
Checking structure phase 1
หัวข้อ: HOSxP Version 3.54.4.28 (อ่าน 18348 ครั้ง)