Checking STRUCTURE phase 2
ALTER TABLE xray_rent_type ADD `xray_rent_type_name` VARCHAR(150) NOT NULL
ALTER TABLE xray_rent_status ADD `xray_rent_status_name` VARCHAR(150) NOT NULL
ALTER TABLE xray_rent_department ADD `xray_rent_department_name` VARCHAR(250) NOT NULL
ALTER TABLE xray_pack ADD `pack_accession_no` INT NOT NULL
ALTER TABLE xray_contrast_media_use ADD `volume_cc` INT NULL
ALTER TABLE xray_class_xn ADD `xray_rent_status_id` INT NULL
ALTER TABLE xray_class_xn ADD `pt_class_xn` INT NOT NULL
ALTER TABLE xray_class_xn ADD `pt_xn` INT NOT NULL
ALTER TABLE xray_class_rent ADD `xray_rent_type_id` INT NULL
ALTER TABLE xray_class_rent ADD `xray_rent_department_id` INT NULL
ALTER TABLE xray_class_rent ADD `rent_reason_id` INT NULL
ALTER TABLE xray_class_rent ADD `authrize_staff` VARCHAR(50) NULL
ALTER TABLE xray_class_rent ADD `rent_staff_name` VARCHAR(50) NULL
ALTER TABLE xray_class_rent ADD `rent_time` TIME NULL
ALTER TABLE xray_class_rent ADD `rent_date` DATE NULL
ALTER TABLE xray_class_rent ADD `pt_class_xn` INT NOT NULL
ALTER TABLE stock_subdraw ADD `stock_draw_ref_no` VARCHAR(150) NULL
ALTER TABLE stock_draw ADD `stock_draw_ref_no` VARCHAR(150) NULL
ALTER TABLE person_anc ADD `dental_tx_date` DATE NULL
ALTER TABLE person_anc ADD `husband_person_id` INT NULL
ALTER TABLE person_anc ADD `husband_lname` VARCHAR(60) NULL
ALTER TABLE person_anc ADD `husband_fname` VARCHAR(60) NULL
ALTER TABLE person_anc ADD `husband_pname` VARCHAR(30) NULL
ALTER TABLE person_anc ADD `thalasseima_husband_dx_icd10` VARCHAR(9) NULL
ALTER TABLE person_anc ADD `thalasseima_wife_dx_icd10` VARCHAR(9) NULL
ALTER TABLE person_anc ADD `thalasseima_husband_alpha1_result` CHAR(1) NULL
ALTER TABLE person_anc ADD `thalasseima_wife_alpha1_result` CHAR(1) NULL
ALTER TABLE person_anc ADD `thalasseima_husband_hbtyping_result` CHAR(1) NULL
ALTER TABLE person_anc ADD `thalasseima_wife_hbtyping_result` CHAR(1) NULL
ALTER TABLE person_anc ADD `thalasseima_husband_dcip_result` CHAR(1) NULL
ALTER TABLE person_anc ADD `thalasseima_wife_dcip_result` CHAR(1) NULL
ALTER TABLE person_anc ADD `thalasseima_husband_of_result` CHAR(1) NULL
ALTER TABLE person_anc ADD `thalasseima_wife_of_result` CHAR(1) NULL
ALTER TABLE person_anc ADD `thalasseima_preg_age` INT NULL
ALTER TABLE patient_hospital ADD `officer_check` CHAR(1) NULL
ALTER TABLE oapp_xray ADD `order_xn` INT NULL
ALTER TABLE membrane_type ADD `membrane_type_name` VARCHAR(150) NOT NULL
ALTER TABLE membrane_explode_type ADD `membrane_explode_type_name` VARCHAR(150) NOT NULL
ALTER TABLE medication_reconciliation_manage ADD `medication_reconciliation_manage_name` VARCHAR(100) NOT NULL
ALTER TABLE medication_reconciliation_detail ADD `medication_change_cause` VARCHAR(250) NULL
ALTER TABLE medication_reconciliation_detail ADD `medication_reconciliation_manage_id` INT NULL
ALTER TABLE medication_reconciliation_detail ADD `doctor_reconciliation_command_id` INT NULL
ALTER TABLE medication_reconciliation_detail ADD `last_receive_date` DATE NULL
ALTER TABLE medication_reconciliation_detail ADD `receive_location` VARCHAR(150) NULL
ALTER TABLE medication_reconciliation_detail ADD `medication_name` VARCHAR(150) NOT NULL
ALTER TABLE medication_reconciliation_detail ADD `medication_reconciliation_id` INT NOT NULL
ALTER TABLE medication_reconciliation ADD `note` text NULL
ALTER TABLE medication_reconciliation ADD `doctor` VARCHAR(25) NULL
ALTER TABLE medication_reconciliation ADD `staff` VARCHAR(25) NULL
ALTER TABLE medication_reconciliation ADD `last_recieve_medication_duration_day` INT NULL
ALTER TABLE medication_reconciliation ADD `last_receive_medication_date` DATE NULL
ALTER TABLE medication_reconciliation ADD `medication_survey` CHAR(1) NULL
ALTER TABLE medication_reconciliation ADD `an` VARCHAR(9) NOT NULL
ALTER TABLE labour_stage ADD `labour_stage_name` VARCHAR(150) NOT NULL
ALTER TABLE labour_sac_type ADD `labour_sac_type_name` VARCHAR(250) NOT NULL
ALTER TABLE labour_deliver_abnormal_type ADD `labour_deliver_abnormal_name` VARCHAR(150) NOT NULL
ALTER TABLE labour_complication ADD `icd10` VARCHAR(9) NULL
ALTER TABLE labour_complication ADD `labour_stage_id` INT NULL
ALTER TABLE labour_complication ADD `labour_complication_name` VARCHAR(150) NOT NULL
ALTER TABLE labour_amniotic_type ADD `labour_amniotic_type_name` VARCHAR(250) NOT NULL
ALTER TABLE labor ADD `labour_cervical_date` DATE NULL
ALTER TABLE labor ADD `labour_cervical_time` TIME NULL
ALTER TABLE labor ADD `labour_cervical_3cm_date` DATE NULL
ALTER TABLE labor ADD `labour_cervical_3cm_time` TIME NULL
ALTER TABLE labor ADD `entry_staff` VARCHAR(25) NULL
ALTER TABLE labor ADD `sulture_doctor` VARCHAR(9) NULL
ALTER TABLE ipt_type ADD `ipt_type_name` VARCHAR(150) NOT NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `labour_sac_type_id` INT NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `labour_amniotic_type_id` INT NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `station` VARCHAR(10) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `eff` DOUBLE(15,3) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `cervical_open_size` DOUBLE(15,3) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `fetal_heart_sound` VARCHAR(200) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `pe_abdomen` VARCHAR(200) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `pe_heart` VARCHAR(200) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `pe_lung` VARCHAR(200) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `hr` INT NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `rr` INT NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `bpd` DOUBLE(15,3) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `bps` DOUBLE(15,3) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `height` DOUBLE(15,3) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `temperature` DOUBLE(15,3) NULL
ALTER TABLE ipt_pregnancy_vital_sign ADD `bw` DOUBLE(15,3) NULL
ALTER TABLE ipt_pregnancy ADD `entry_staff` VARCHAR(50) NULL
ALTER TABLE ipt_pregnancy ADD `last_child_year` INT NULL
ALTER TABLE ipt_labour_infant ADD `entry_staff` VARCHAR(50) NULL
ALTER TABLE ipt_labour_infant ADD `labour_doctor` VARCHAR(9) NULL
ALTER TABLE ipt_labour_infant ADD `infant_dchtype` VARCHAR(2) NULL
ALTER TABLE ipt_labour_infant ADD `infant_dchstts` VARCHAR(2) NULL
ALTER TABLE ipt_labour_infant ADD `infant_fluid_type_id` INT NULL
ALTER TABLE ipt_labour_infant ADD `infant_an` CHAR(9) NULL
ALTER TABLE ipt_labour_infant ADD `infant_check_feed_milk` CHAR(1) NULL
ALTER TABLE ipt_labour_infant ADD `infant_check_narcan` CHAR(1) NULL
ALTER TABLE ipt_labour_infant ADD `infant_check_azt` CHAR(1) NULL
ALTER TABLE ipt_labour_infant ADD `infant_check_oxygen_box` CHAR(1) NULL
ALTER TABLE ipt_labour_infant ADD `infant_check_chest_pump` CHAR(1) NULL
ALTER TABLE ipt_labour_infant ADD `infant_check_et_tube` CHAR(1) NULL
ALTER TABLE ipt_labour_infant ADD `infant_check_ppv` CHAR(1) NULL
ALTER TABLE ipt_labour_infant ADD `infant_adaptor_type_id` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min10_color` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min10_tone` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min10_reflex` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min10_rr` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min10_hr` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min5_color` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min5_tone` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min5_reflex` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min5_hr` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min5_rr` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min1_color` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min1_tone` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min1_reflex` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min1_rr` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min1_hr` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min10` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min5` INT NULL
ALTER TABLE ipt_labour_infant ADD `apgar_score_min1` INT NULL
ALTER TABLE ipt_labour_infant ADD `head_length` INT NULL
ALTER TABLE ipt_labour_infant ADD `body_length` INT NULL
ALTER TABLE ipt_labour_infant ADD `infant_indication_type_id` INT NULL
ALTER TABLE ipt_labour_infant ADD `infant_delivery_type_id` INT NULL
ALTER TABLE ipt_labour_infant ADD `birth_weight` INT NULL
ALTER TABLE ipt_labour_infant ADD `birth_time` TIME NULL
ALTER TABLE ipt_labour_infant ADD `birth_date` DATE NULL
ALTER TABLE ipt_labour_infant ADD `sex` CHAR(1) NULL
ALTER TABLE ipt_labour_infant ADD `infant_number` INT NULL
ALTER TABLE ipt_labour_infant ADD `ipt_labour_id` INT NOT NULL
ALTER TABLE ipt_labour_complication ADD `complication_note` VARCHAR(250) NULL
ALTER TABLE ipt_labour_complication ADD `labour_stage_id` INT NOT NULL
ALTER TABLE ipt_labour_complication ADD `labour_complication_id` INT NOT NULL
ALTER TABLE ipt_labour_complication ADD `ipt_labour_id` INT NOT NULL
ALTER TABLE ipt_labour_birth_asphyxia ADD `ipt_labour_id` INT NOT NULL
ALTER TABLE ipt_labour_birth_asphyxia ADD `birth_asphyxia_id` INT NOT NULL
ALTER TABLE ipt_labour_birth_asphyxia ADD `birth_asphyxia_factor_id` INT NOT NULL
ALTER TABLE ipt_labour ADD `entry_staff` VARCHAR(50) NULL
ALTER TABLE ipt_labour ADD `t` INT NULL
ALTER TABLE ipt_labour ADD `labour_before_visit` CHAR(1) NULL
ALTER TABLE ipt_labour ADD `membrane_type_id` INT NULL
ALTER TABLE ipt_labour ADD `membrane_explode_type_id` INT NULL
ALTER TABLE ipt_labour ADD `delivery_type_id` INT NULL
ALTER TABLE infant_indication_type ADD `infant_indication_type_name` VARCHAR(150) NOT NULL
ALTER TABLE infant_fluid_type ADD `infant_fluid_type_name` VARCHAR(150) NOT NULL
ALTER TABLE infant_delivery_type ADD `infant_delivery_type_name` VARCHAR(150) NOT NULL
ALTER TABLE infant_adaptor_type ADD `infant_adaptor_type_name` VARCHAR(150) NOT NULL
ALTER TABLE doctor_reconciliation_command ADD `doctor_reconciliation_command_name` VARCHAR(250) NOT NULL
ALTER TABLE deliver_type ADD `deliver_name` VARCHAR(150) NOT NULL
ALTER TABLE birth_asphyxia_factor ADD `birth_asphyxia_factor_name` VARCHAR(150) NOT NULL
ALTER TABLE birth_asphyxia ADD `birth_asphyxia_name` VARCHAR(150) NOT NULL
CREATE TABLE xray_rent_type ( `xray_rent_type_id` INT NOT NULL )
CREATE TABLE xray_rent_status ( `xray_rent_status_id` INT NOT NULL )
CREATE TABLE xray_rent_department ( `xray_rent_department_id` INT NOT NULL )
CREATE TABLE xray_pack ( `xn` INT NOT NULL )
CREATE TABLE xray_class_xn ( `xray_class_xn_id` INT NOT NULL )
CREATE TABLE xray_class_rent ( `xray_class_rent_id` INT NOT NULL )
CREATE TABLE patient_hospital ( `hn` VARCHAR(9) NOT NULL )
CREATE TABLE membrane_type ( `membrane_type_id` INT NOT NULL )
CREATE TABLE membrane_explode_type ( `membrane_explode_type_id` INT NOT NULL )
CREATE TABLE medication_reconciliation_manage ( `medication_reconciliation_manage_id` INT NOT NULL )
CREATE TABLE medication_reconciliation_detail ( `medication_reconciliation_detail_id` INT NOT NULL )
CREATE TABLE medication_reconciliation ( `medication_reconciliation_id` INT NOT NULL )
CREATE TABLE labour_stage ( `labour_stage_id` INT NOT NULL )
CREATE TABLE labour_sac_type ( `labour_sac_type_id` INT NOT NULL )
CREATE TABLE labour_deliver_abnormal_type ( `labour_deliver_abnormal_type` INT NOT NULL )
CREATE TABLE labour_complication ( `labour_complication_id` INT NOT NULL )
CREATE TABLE labour_amniotic_type ( `labour_amniotic_type_id` INT NOT NULL )
CREATE TABLE ipt_type ( `ipt_type` INT NOT NULL )
CREATE TABLE ipt_pregnancy_vital_sign ( `an` VARCHAR(9) NOT NULL )
CREATE TABLE ipt_labour_infant ( `ipt_labour_infant_id` INT NOT NULL )
CREATE TABLE ipt_labour_complication ( `ipt_labour_complication_id` INT NOT NULL )
CREATE TABLE ipt_labour_birth_asphyxia ( `ipt_labour_birth_asphyxia_id` INT NOT NULL )
CREATE TABLE infant_indication_type ( `infant_indication_type_id` INT NOT NULL )
CREATE TABLE infant_fluid_type ( `infant_fluid_type_id` INT NOT NULL )
CREATE TABLE infant_delivery_type ( `infant_delivery_type_id` INT NOT NULL )
CREATE TABLE infant_adaptor_type ( `infant_adaptor_type_id` INT NOT NULL )
CREATE TABLE icd10_nhso ( `code` VARCHAR(9) NOT NULL )
CREATE TABLE doctor_reconciliation_command ( `doctor_reconciliation_command_id` INT NOT NULL )
CREATE TABLE deliver_type ( `deliver_type` INT NOT NULL )
CREATE TABLE birth_asphyxia_factor ( `birth_asphyxia_factor_id` INT NOT NULL )
CREATE TABLE birth_asphyxia ( `birth_asphyxia_id` INT NOT NULL )
Checking STRUCTURE phase 1
แสดงกระทู้
From ChaingMai
กำลังจะใช้กับระบบรักษาความปลอดภัยในรพ.)