Checking structure phase 2
ALTER TABLE patient_history_source ADD `patient_history_source_name` varchar(150) NOT NULL
ALTER TABLE patient_history_pe_visit ADD `other_result_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `ward` varchar(4) NULL
ALTER TABLE patient_history_pe_visit ADD `spclty` varchar(2) NULL
ALTER TABLE patient_history_pe_visit ADD `plan_of_management` text NULL
ALTER TABLE patient_history_pe_visit ADD `provisional_diagnosis` text NULL
ALTER TABLE patient_history_pe_visit ADD `neuro_result_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `neuro_result` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `extremities_result_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `extremities_result` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `ascessment_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `xray_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `lab_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `pe_ga_abdomen_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `pe_ga_abdomen` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `pe_ga_lung_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `pe_ga_lung` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `pe_ga_heart_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `pe_ga_heart` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `pe_ga_ln_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `pe_ga_ln` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `pe_ga_heent_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `pe_ga_heent` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `pe_bpd` int NULL
ALTER TABLE patient_history_pe_visit ADD `pe_bps` int NULL
ALTER TABLE patient_history_pe_visit ADD `pe_rr` double(15,3) NULL
ALTER TABLE patient_history_pe_visit ADD `pe_pulse` double(15,3) NULL
ALTER TABLE patient_history_pe_visit ADD `pe_temperature` double(15,3) NULL
ALTER TABLE patient_history_pe_visit ADD `pe_hight` double(15,3) NULL
ALTER TABLE patient_history_pe_visit ADD `pe_bw` double(15,3) NULL
ALTER TABLE patient_history_pe_visit ADD `ros_neuro_psychiatric_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `ros_neuro_psychiatric` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `ros_gynecological_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `ros_gynecological` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `ros_genito_urinary_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `ros_genito_urinary` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `ros_gastro_intestinal_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `ros_gastro_intestinal` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `ros_cardiovascular_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `ros_cardiovascular` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `ros_respiratory_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `ros_respiratory` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `ros_heent_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `ros_heent` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `ros_general_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `ros_general` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `personal_gd` text NULL
ALTER TABLE patient_history_pe_visit ADD `personal_vaccine` text NULL
ALTER TABLE patient_history_pe_visit ADD `personal_allergy_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `personal_allergy` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `other_history` text NULL
ALTER TABLE patient_history_pe_visit ADD `family_history` text NULL
ALTER TABLE patient_history_pe_visit ADD `career_history` text NULL
ALTER TABLE patient_history_pe_visit ADD `personal_operation_detail` text NULL
ALTER TABLE patient_history_pe_visit ADD `personal_operation` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `personal_drinking` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `personal_smoking` char(1) NULL
ALTER TABLE patient_history_pe_visit ADD `past_history` text NULL
ALTER TABLE patient_history_pe_visit ADD `present_illness` text NULL
ALTER TABLE patient_history_pe_visit ADD `chief_complaint` text NULL
ALTER TABLE patient_history_pe_visit ADD `patient_history_source_id` int NULL
ALTER TABLE patient_history_pe_visit ADD `pe_time` time NULL
ALTER TABLE patient_history_pe_visit ADD `pe_date` date NULL
ALTER TABLE patient_history_pe_visit ADD `doctor` varchar(10) NOT NULL
ALTER TABLE patient_history_pe_visit ADD `vn` varchar(13) NOT NULL
ALTER TABLE patient_history_pe_visit ADD `hn` varchar(9) NOT NULL
CREATE TABLE patient_history_source ( `patient_history_source_id` int NOT NULL )
CREATE TABLE patient_history_pe_visit ( `patient_history_pe_visit_id` int NOT NULL )
Checking structure phase 1