-- Create Table Statement for 'Onboarding Business Info'
DROP TABLE IF EXISTS `ONBOARDING_BUSINESS_INFO`;
CREATE TABLE `ONBOARDING_BUSINESS_INFO` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	WEB_SITE varchar,
	STATE varchar,
	ANNUAL_CARDS_VOLUME int(11),
	DEPOSIT_BANK_NAME varchar,
	DEPOSIT_ACCOUNT_NUMBER varchar,
	MAX_TRANSACTION_AMOUNT int(11),
	ONBOARDING_OWNERSHIP_STRUCTURE varchar,
	DESCRIPTOR_PHONE varchar,
	DEPOSIT_ACCOUNT_TYPE_CL varchar,
	DEPOSIT_HOLDER_NAME varchar,
	ANNUAL_DIRECT_DEBIT_VOLUME int(11),
	AVG_DIRECT_DEBIT_TRANSACTION_AMOUNT int(11),
	COUNTRY_CODE varchar,
	AVG_CARDS_TRANSACTION_AMOUNT int(11),
	PORTFOLIO_CODE int(11),
	DESCRIPTION varchar,
	MERCHANT_CATEGORY_CODE varchar,
	ZIP_CODE varchar,
	STREET1 varchar,
	STREET2 varchar,
	CONTACT_PHONE varchar,
	TAX_ID varchar,
	LEGAL_NAME varchar,
	BUSINESS_NAME varchar,
	CITY varchar,
	DEPOSIT_ROUTING_NUMBER varchar,
	FEE_SCHEMA varchar,
	REGISTRATION_STATE varchar,
	REGISTRATION_YEAR int(11),
	REGISTRATION_COUNTRY_CODE varchar,
	RELATIONSHIP_BEGIN_DATE datetime,
	WORK_HOURS varchar,
	CURRENCY_CODE varchar,
	DEPOSIT_BANK_PHONE varchar,
	CARD_DESCRIPTOR varchar,
	DIRECT_DEBIT_DESCRIPTOR varchar,
	FEE_PROCESSOR_CODE int(11),
	REMITTER_CODE int(11),
	DRIVER_LICENSE_STATE varchar,
	DRIVER_LICENSE varchar,
	CARD_TYPE_DISTRIBUTION varchar,
	ENTRY_MODE_DISTRIBUTION varchar,
	DRIVER_LICENSE_COUNTRY_CODE varchar,
	SETTLEMENT_TYPE varchar,
	SETTLEMENT_CUTOFF int(11),
	REMITTANCE_CURRENCY_CODE varchar,
	FEE_TEMPLATE_CODE bigint(20),
	DEPOSIT_BANK_PHONE varchar,
	CHARGE_BANK_NAME varchar,
	CHARGE_BANK_PHONE varchar,
	CHARGE_HOLDER_NAME varchar,
	CHARGE_ACCOUNT_NUMBER varchar,
	CHARGE_ROUTING_NUMBER varchar,
	ACCOUNT_USAGE_CL_CHARGE varchar,
	EMAIL varchar,
	DIRECT_DEBIT_DESCRIPTOR_MERCHANT_NAME varchar,
	FEE_TEMPLATE_CODE_ENCRYPTED varchar,
	DEPOSIT_ACCOUNT_STORE_FK bigint(20),
	DEPOSIT_ACCOUNT_STORE_FK bigint(20),
	DEPOSIT_ACCOUNT_STORE_FK bigint(20),
	DEPOSIT_ACCOUNT_STORE_FK bigint(20),
	DEPOSIT_ACCOUNT_STORE_FK bigint(20),
	DIRECT_DEBIT_DESCRIPTOR_ITEM varchar,
	DIRECT_DEBIT_DESCRIPTOR varchar,
	DIRECT_DEBIT_DESCRIPTOR_ITEM varchar,
	DIRECT_DEBIT_DESCRIPTOR varchar,
	IS_AMEX_OPT_BLUE_ACQUIRED tinyint(1),
	AMEX_MID varchar,
	FEE_PREFIX varchar,
	DIRECT_DEBIT_DESCRIPTOR_ITEM varchar,
	IS_AMEX_OPT_BLUE_ACQUIRED tinyint(1),
	AMEX_MID varchar,
	FEE_PREFIX varchar,
	IS_AMEX_OPT_BLUE_ACQUIRED tinyint(1),
	AMEX_MID varchar,
	FEE_PREFIX varchar,
	DEPOSIT_BANK_NAME varchar,
	DEPOSIT_HOLDER_NAME varchar,
	DEPOSIT_BANK_NAME varchar,
	DEPOSIT_HOLDER_NAME varchar,
	DEPOSIT_ACCOUNT_TYPE_CL varchar,
	DEPOSIT_ACCOUNT_TYPE_CL varchar,
	VAT_NUMBER varchar,
	VAT_NUMBER varchar,
	VAT_NUMBER varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;