HOSxP 3.51.5.14

[doramon]

HOSxP 3.51.5.14

โค๊ด: SQL

1. ALTER TABLE wbc_location_type  ADD `wbc_location_type_name` VARCHAR(100) NOT NULL  
2. ALTER TABLE person_wbc_service  ADD `wbc_location_type_id` INT NULL  
3. ALTER TABLE person_anc_service  ADD `anc_location_type_id` INT NULL  
4. ALTER TABLE person_anc_preg_care  MODIFY COLUMN `sugar_level`  VARCHAR(25)  
5. ALTER TABLE person_anc_preg_care  MODIFY COLUMN `albumin_level`  VARCHAR(25)  
6. ALTER TABLE doctor_position  ADD `anes_doctor` CHAR(1) NULL  
7. ALTER TABLE anc_location_type  ADD `anc_location_type_name` VARCHAR(100) NOT NULL  
8. CREATE TABLE wbc_location_type ( `wbc_location_type_id` INT NOT NULL  )
9. CREATE TABLE iptbedmove_reason ( `reason` VARCHAR(200) NOT NULL  )
10. CREATE TABLE anc_location_type ( `anc_location_type_id` INT NOT NULL  )
11. Checking STRUCTURE phase 1
12.  
13.  
14.