ALTER TABLE rcpt_credit MODIFY COLUMN `rcpno` VARCHAR(200)
ALTER TABLE rcpt_credit MODIFY COLUMN `finance_number` VARCHAR(200)
ALTER TABLE person_anc_service ADD `service_text` VARCHAR(250) NULL
ALTER TABLE person_anc_service ADD `anc_service_number` INT NULL
ALTER TABLE person_anc_service ADD `anc_service_type_id` INT NULL
ALTER TABLE person_anc_service ADD `old_visitno` INT NULL
ALTER TABLE person_anc_service ADD `pa_week` INT NULL
ALTER TABLE person_anc_preg_care ADD `perineum_normal` CHAR(1) NULL
ALTER TABLE person_anc_preg_care ADD `advice_text` text NULL
ALTER TABLE person_anc_preg_care ADD `sugar_level` DOUBLE(15,3) NULL
ALTER TABLE person_anc_preg_care ADD `albumin_level` DOUBLE(15,3) NULL
ALTER TABLE person_anc_preg_care ADD `nipple_normal` CHAR(1) NULL
ALTER TABLE person_anc_preg_care ADD `lochia_normal` CHAR(1) NULL
ALTER TABLE person_anc_preg_care ADD `uterus_level_normal` CHAR(1) NULL
ALTER TABLE person_anc_preg_care ADD `anc_preg_care_location_id` INT NULL
ALTER TABLE person_anc_preg_care ADD `care_date` DATE NULL
ALTER TABLE person_anc_preg_care ADD `person_anc_id` INT NOT NULL
ALTER TABLE person_anc ADD `discharge_date` DATE NULL
ALTER TABLE person_anc ADD `discharge` CHAR(1) NULL
ALTER TABLE person_anc ADD `ga` INT NULL
ALTER TABLE anc_service_type ADD `anc_service_type_name` VARCHAR(100) NOT NULL
CREATE TABLE person_anc_preg_care ( `person_anc_preg_care_id` INT NOT NULL )
CREATE TABLE anc_service_type ( `anc_service_type_id` INT NOT NULL )
Checking STRUCTURE phase 1