ALTER TABLE `creditApplication` ADD `province` VARCHAR(100) AFTER `addressStatus`; 
ALTER TABLE `creditApplication` ADD `provinceStatus` VARCHAR(50) DEFAULT 'N' AFTER `province`; 

ALTER TABLE `creditApplication` ADD `companyProvince` VARCHAR(100) AFTER `province`; 
ALTER TABLE `creditApplication` ADD `companyProvinceStatus` VARCHAR(50) DEFAULT 'N' AFTER `companyProvince`; 

ALTER TABLE `creditDetail` DROP `downPaymentRate`; 
ALTER TABLE `creditDetail` DROP `marginRate`; 

ALTER TABLE `creditApplication` ADD `dateOfBirth` DATETIME AFTER `childrenCountStatus`; 
ALTER TABLE `creditApplication` ADD `dateOfBirthStatus` VARCHAR(50) DEFAULT 'N' AFTER `dateOfBirth`; 

ALTER TABLE `creditApplication` ADD `bankAccountBca` DATETIME AFTER `bankAccountStatus`; 
ALTER TABLE `creditApplication` ADD `bankAccountBcaStatus` VARCHAR(50) DEFAULT 'N' AFTER `bankAccountBca`; 

ALTER TABLE `creditApplication` ADD `bankAccountBri` DATETIME AFTER `bankAccountBcaStatus`; 
ALTER TABLE `creditApplication` ADD `bankAccountBriStatus` VARCHAR(50) DEFAULT 'N' AFTER `bankAccountBri`; 

ALTER TABLE `creditApplication` ADD `bankAccountBni` DATETIME AFTER `bankAccountBriStatus`; 
ALTER TABLE `creditApplication` ADD `bankAccountBniStatus` VARCHAR(50) DEFAULT 'N' AFTER `bankAccountBni`; 

ALTER TABLE `creditApplication` ADD `bankAccountMandiri` DATETIME AFTER `bankAccountBniStatus`; 
ALTER TABLE `creditApplication` ADD `bankAccountMandiriStatus` VARCHAR(50) DEFAULT 'N' AFTER `bankAccountMandiri`; 

ALTER TABLE `creditApplication` DROP `bankAccount`; 
ALTER TABLE `creditApplication` DROP `bankAccountStatus`; 