47
« เมื่อ: พฤศจิกายน 09, 2007, 14:24:20 PM »
เรียน อ.ชัยพร
version 3.50.7.22 ระบบงานห้อง Lab ติกที่ รายงานผลที่ยืนยันแล้ว และ รายงานผลทั้งหมด ทำให้ระบบ HOSxP ทั้งระบบ ช้า ผมส่ง คำสั่ง ที่อ.ให้มา (show create table lab_head,lab_order) มาให้ดูด้วย
lab_head
CREATE TABLE `lab_head` (
`lab_order_number` int(11) NOT NULL default '0',
`doctor_code` varchar(7) collate tis620_bin default NULL,
`lab_items_group_code` int(11) default NULL,
`vn` varchar(13) collate tis620_bin default NULL,
`lab_head_remark` varchar(250) collate tis620_bin default NULL,
`hn` varchar(9) collate tis620_bin default NULL,
`order_date` date default NULL,
`report_date` date default NULL,
`reporter_name` varchar(100) collate tis620_bin default NULL,
`report_time` time default NULL,
`confirm_specimen` char(1) collate tis620_bin default NULL,
`confirm_report` char(1) collate tis620_bin default NULL,
`department` varchar(5) collate tis620_bin default NULL,
`form_name` varchar(200) collate tis620_bin default NULL,
`sub_group_list` varchar(200) collate tis620_bin default NULL,
`order_time` time default NULL,
`receive_date` date default NULL,
`receive_time` time default NULL,
`ward` char(2) collate tis620_bin default NULL,
`result_note` text collate tis620_bin,
`lock_result` char(1) collate tis620_bin default NULL,
`result_rtf` longtext collate tis620_bin,
`order_note` text collate tis620_bin,
`lab_receive_number` int(11) default NULL,
`approve_staff` varchar(25) collate tis620_bin default NULL,
`anonymous` char(1) collate tis620_bin default NULL,
`appointment` char(1) collate tis620_bin default NULL,
`appointment_date` date default NULL,
`appointment_time` time default NULL,
`lis_order_no` varchar(25) collate tis620_bin default NULL,
`confirm_charge_money` char(1) collate tis620_bin default NULL,
`finance_lab_confirm` char(1) collate tis620_bin default NULL,
`lab_order_number_guid` varchar(38) collate tis620_bin default NULL,
`anonymous_request` char(1) collate tis620_bin default NULL,
`clinic` char(3) collate tis620_bin default NULL,
`send_to_cashier` char(1) collate tis620_bin default NULL,
PRIMARY KEY (`lab_order_number`),
UNIQUE KEY `lab_order_number_unique` (`lab_order_number`),
KEY `confirm_specimen` (`confirm_specimen`),
KEY `hn` (`hn`),
KEY `vn` (`vn`),
KEY `ix_order_date` (`order_date`),
KEY `order_date` (`order_date`),
KEY `lab_order_number` (`lab_order_number`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 COLLATE=tis620_bin
lab_order
CREATE TABLE `lab_order` (
`lab_order_number` int(11) NOT NULL,
`lab_items_code` int(11) NOT NULL,
`lab_order_result` varchar(250) default NULL,
`lab_order_remark` varchar(250) default NULL,
`staff` varchar(50) default NULL,
`confirm` char(1) default NULL,
`lab_items_name_ref` varchar(250) default NULL,
`lab_items_normal_value_ref` varchar(150) default NULL,
`specimen_code` int(11) default NULL,
`lab_items_sub_group_code` int(11) default NULL,
`order_type` char(1) default NULL,
PRIMARY KEY (`lab_order_number`,`lab_items_code`),
UNIQUE KEY `lab_order_number_unique` (`lab_order_number`,`lab_items_code`),
KEY `lab_order_number` (`lab_order_number`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620