ALTER TABLE patient_pttype ADD `authorize_datetime` datetime NULL
ALTER TABLE patient_pttype ADD `authorize_staff` VARCHAR(25) NULL
ALTER TABLE patient_pttype ADD `paid_amount` DOUBLE(15,3) NULL
ALTER TABLE patient_pttype ADD `max_debt_amount` DOUBLE(15,3) NULL
ALTER TABLE patient_pttype ADD `contract_id` INT NULL
ALTER TABLE patient_pttype ADD `company_id` INT NULL
ALTER TABLE patient_pttype ADD `pttype_number` INT NULL
ALTER TABLE patient_pttype ADD `pttypeno` VARCHAR(50) NULL
ALTER TABLE patient_pttype ADD `hospsub` CHAR(5) NULL
ALTER TABLE patient_pttype ADD `hospmain` CHAR(5) NULL
ALTER TABLE patient_pttype ADD `expire_date` DATE NULL
ALTER TABLE patient_pttype ADD `begin_date` DATE NULL
ALTER TABLE patient_pttype ADD `pttype` CHAR(2) NOT NULL
ALTER TABLE patient_pttype ADD `hn` VARCHAR(9) NOT NULL
CREATE TABLE patient_pttype ( `patient_pttype_id` INT NOT NULL )