HOSXP 3.50.10.11

[doramon]

HOSXP 3.50.10.11

กำลังทดสอบครับ

โค๊ด: SQL

1. ALTER TABLE physic_main_ipd  ADD `send_datetime` datetime NULL  
2. ALTER TABLE physic_main_ipd  ADD `send_ward` VARCHAR(7) NULL  
3. ALTER TABLE physic_main_ipd  ADD `send_staff` VARCHAR(15) NULL  
4. ALTER TABLE physic_main_ipd  ADD `hn` VARCHAR(9) NULL  
5. ALTER TABLE physic_main_ipd  ADD `service_time` TIME NULL  
6. ALTER TABLE physic_main_ipd  ADD `vstdate` DATE NULL  
7. ALTER TABLE physic_main_ipd  ADD `type_text` VARCHAR(250) NULL  
8. ALTER TABLE physic_main_ipd  ADD `doctor_text` VARCHAR(250) NULL  
9. ALTER TABLE physic_main_ipd  ADD `progress_text` longtext NULL  
10. ALTER TABLE physic_main_ipd  ADD `plan_text` longtext NULL  
11. ALTER TABLE physic_main_ipd  ADD `problem_text` longtext NULL  
12. ALTER TABLE physic_main_ipd  ADD `physic_chronic_id` INT NULL  
13. ALTER TABLE physic_main_ipd  ADD `service_text` VARCHAR(250) NULL  
14. ALTER TABLE physic_main_ipd  ADD `type3` CHAR(1) NULL  
15. ALTER TABLE physic_main_ipd  ADD `type2` CHAR(1) NULL  
16. ALTER TABLE physic_main_ipd  ADD `type1` CHAR(1) NULL  
17. ALTER TABLE physic_main_ipd  ADD `an` VARCHAR(9) NOT NULL  
18. ALTER TABLE physic_list_ipd  ADD `physic_group_id` INT NULL  
19. ALTER TABLE physic_list_ipd  ADD `opi_guid` VARCHAR(38) NULL  
20. ALTER TABLE physic_list_ipd  ADD `price` DOUBLE(15,3) NULL  
21. ALTER TABLE physic_list_ipd  ADD `icode` VARCHAR(7) NULL  
22. ALTER TABLE physic_list_ipd  ADD `doctor` VARCHAR(7) NULL  
23. ALTER TABLE physic_list_ipd  ADD `physic_items_id` INT NULL  
24. ALTER TABLE physic_list_ipd  ADD `physic_main_ipd_id` INT NOT NULL  
25. ALTER TABLE nutrition_level  ADD `name` VARCHAR(100) NOT NULL  
26. CREATE TABLE physic_main_ipd ( `physic_main_ipd_id` INT NOT NULL  )
27. CREATE TABLE physic_list_ipd ( `physic_ipd_id` INT NOT NULL  )
28. CREATE TABLE nutrition_level ( `nutrition_level` INT NOT NULL  )
29.  
30.  
31.