Checking STRUCTURE phase 2
ALTER TABLE referout ADD `with_ambulance` CHAR(1) NULL
ALTER TABLE referout ADD `with_nurse` CHAR(1) NULL
ALTER TABLE referout ADD `spclty` CHAR(2) NULL
ALTER TABLE patient_rx_note ADD `rx_note` longtext NULL
ALTER TABLE ipd_dosage_plan ADD `qty` INT NULL
ALTER TABLE ipd_dosage_plan ADD `day_number` INT NOT NULL
ALTER TABLE ipd_dosage_plan ADD `drugusage` VARCHAR(7) NOT NULL
ALTER TABLE ipd_dosage_plan ADD `icode` VARCHAR(7) NOT NULL
CREATE TABLE patient_rx_note ( `hn` VARCHAR(9) NOT NULL )
CREATE TABLE ipd_dosage_plan ( `ipd_dosage_plan_id` INT NOT NULL )
Checking STRUCTURE phase 1