-- Create Table Statement for 'Onboarding Application'
DROP TABLE IF EXISTS `ONBOARDING_APPLICATION`;
CREATE TABLE `ONBOARDING_APPLICATION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CREATE_DATE datetime,
	BIRTH_DATE datetime,
	STATE varchar,
	COUNTRY_CODE varchar,
	PORTFOLIO_CODE int(11),
	STATUS_CL varchar,
	ONBOARDING_AGREEMENT_FK bigint(20),
	APPLICATION_CODE varchar,
	SOCIAL_SECURITY varchar,
	EMAIL varchar,
	ZIP_CODE varchar,
	LAST_NAME varchar,
	STREET2 varchar,
	PHONE varchar,
	STREET1 varchar,
	CITY varchar,
	FIRST_NAME varchar,
	ONBOARDING_BUSINESS_INFO_FK bigint(20),
	RESELLER_CODE int(11),
	TIME_ZONE varchar,
	SUBMERCHANT_REF_CODE varchar,
	SUBMERCHANT_NAME varchar,
	MERCHANT_PROFILE varchar,
	CHANNEL_CODE bigint(20),
	MERCHANT_CREATION_POLICY_CL varchar,
	PROCESSING_CONFIGURATION_SCRIPT varchar,
	BILLING_CONFIGURATION_SCRIPT varchar,
	NOTIFY_URL varchar,
	RETURN_URL varchar,
	CANCEL_URL varchar,
	PROFILE_TYPE varchar,
	MERCHANT_NAME varchar,
	MID_REQUEST_STATUS_CL varchar,
	MID_REQUEST_DATE datetime,
	MID_RESPONSE_STATUS_CL varchar,
	MID_RESPONSE_DATE datetime,
	MERCHANT_CREATION_STATUS_CL varchar,
	MERCHANT_CREATION_DATE datetime,
	PROVIDER_PROFILE_CONFIGURATION_STATUS_CL varchar,
	PROVIDER_PROFILE_CONFIGURATION_DATE datetime,
	MERCHANT_FEE_CONFIGURATION_STATUS_CL varchar,
	MERCHANT_FEE_CONFIGURATION_DATE datetime,
	BILLING_CONFIGURATION_STATUS_CL varchar,
	BILLING_CONFIGURATION_DATE datetime,
	MERCHANT_REF_CODE varchar,
	MERCHANT_CODE varchar,
	PROCESSOR_APPLICATION_ID varchar,
	DISTRIBUTION_SCHEMA_CODE varchar,
	NOTIFICATION_POLICY varchar,
	MERCHANT_ID varchar,
	PROFILE_ID varchar,
	ONBOARDING_PROFILE_CODE bigint(20),
	PROFILE_ID varchar,
	ONBOARDING_PROFILE_CODE bigint(20),
	CLIENT_HOST varchar,
	CLIENT_HOST varchar,
	ACCOUNT_STORE bigint(20),
	CLIENT_HOST varchar,
	MERCHANT_TYPE varchar,
	ACCOUNT_STORE bigint(20),
	MERCHANT_TYPE varchar,
	PROFILE_ID varchar,
	ONBOARDING_PROFILE_CODE bigint(20),
	CLIENT_HOST varchar,
	ACCOUNT_STORE bigint(20),
	MERCHANT_TYPE varchar,
	USER_NAME varchar,
	ACCOUNT_STORE bigint(20),
	LAST_STATUS_UPDATE_DATE datetime,
	USER_NAME varchar,
	ACCOUNT_STORE bigint(20),
	USER_NAME varchar,
	ONBOARDING_AGREEMENT_FK bigint(20),
	ONBOARDING_AGREEMENT_FK bigint(20),
	FTP_ACCESS_CREATION_STATUS_CL varchar,
	FTP_ACCESS_CREATION_DATE datetime,
	FTP_ACCESS_CREATION_STATUS_CL varchar,
	FTP_ACCESS_CREATION_DATE datetime,
	TERMINALS varchar,
	TERMINAL_SETUP varchar,
	LAST_STATUS_UPDATE_DATE datetime,
	TERMINALS varchar,
	TERMINAL_SETUP varchar,
	SUBMERCHANT_NAME varchar,
	SUBMERCHANT_REF_CODE varchar,
	SUBMERCHANT_NAME varchar,
	SUBMERCHANT_REF_CODE varchar,
	REQUEST_HOST varchar,
	TRANSACTION_OPERATION_CL varchar,
	IS_EMBEDDED tinyint(1),
	PAGE_FORMAT varchar,
	RETURN_URL_POLICY varchar,
	FIELD_LIST_READONLY varchar,
	FIELD_LIST_HIDDEN varchar,
	MERCHANT_FK int(11),
	PROCESSING_PROFILE_FK bigint(20),
	PORTFOLIO_FK int(11),
	RESELLER_FK int(11),
	VERIFICATION_PROFILE_FK bigint(20),
	STAKE_PERCENTAGE int(11),
	FTP_ACCESS_CREATION_STATUS_CL varchar,
	FTP_ACCESS_CREATION_DATE datetime,
	LAST_STATUS_UPDATE_DATE datetime,
	TERMINALS varchar,
	TERMINAL_SETUP varchar,
	MERCHANT_CODE varchar,
	COUNTRY_CODE varchar,
	COUNTRY_CODE varchar,
	MERCHANT_CODE varchar,
	STAKE_PERCENTAGE int(11),
	ACTION_CL varchar,
	PREV_ONBOARDING_APPLICATION_FK bigint(20),
	NEXT_ONBOARDING_APPLICATION_FK bigint(20),
	REQUEST_HOST varchar,
	IS_EMBEDDED tinyint(1),
	PAGE_FORMAT varchar,
	RETURN_URL_POLICY varchar,
	FIELD_LIST_READONLY varchar,
	FIELD_LIST_HIDDEN varchar,
	MERCHANT_FK int(11),
	PORTFOLIO_FK int(11),
	RESELLER_FK int(11),
	OPERATION_CL varchar,
	MID_REQUEST_STATUS_CL varchar,
	MID_RESPONSE_STATUS_CL varchar,
	MERCHANT_CREATION_STATUS_CL varchar,
	PROVIDER_PROFILE_CONFIGURATION_STATUS_CL varchar,
	MERCHANT_FEE_CONFIGURATION_STATUS_CL varchar,
	BILLING_CONFIGURATION_STATUS_CL varchar,
	OFFICER_CODE varchar,
	STATUS_CL varchar,
	FTP_ACCESS_CREATION_STATUS_CL varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	PROVIDER_REFERENCE_NUMBER varchar,
	PROVIDER_OPERATION_CL varchar,
	VERIFICATION_PROFILE_FK bigint(20),
	TITLE varchar,
	TERMINAL_CONFIGURATION_STATUS_CL varchar,
	TERMINAL_CONFIGURATION_DATE datetime,
	VERIFICATION_REQUEST_STATUS_CL varchar,
	VERIFICATION_REQUEST_DATE datetime,
	PROCESSING_PROFILE_FK bigint(20),
	VERIFICATION_RESPONSE_STATUS_CL varchar,
	VERIFICATION_RESPONSE_STATUS_DATE datetime,
	VERIFICATION_STATUS_CL varchar,
	REQUEST_ID varchar,
	STAKE_PERCENTAGE int(11),
	REQUEST_HOST varchar,
	OPERATION_CL varchar,
	IS_EMBEDDED tinyint(1),
	PAGE_FORMAT varchar,
	RETURN_URL_POLICY varchar,
	FIELD_LIST_READONLY varchar,
	FIELD_LIST_HIDDEN varchar,
	MERCHANT_FK int(11),
	PROCESSING_PROFILE_FK bigint(20),
	PORTFOLIO_FK int(11),
	RESELLER_FK int(11),
	VERIFICATION_PROFILE_FK bigint(20),
	ANNUAL_FEE_POLICY varchar,
	PROCESSOR_APPLICATION_ID varchar,
	IS_LEGACY_APPLICATION tinyint(1),
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	PROVIDER_REFERENCE_NUMBER varchar,
	TITLE varchar,
	VERIFICATION_REQUEST_STATUS_CL varchar,
	VERIFICATION_REQUEST_DATE datetime,
	VERIFICATION_STATUS_CL varchar,
	PROCESSOR_APPLICATION_ID varchar,
	ANNUAL_FEE_POLICY varchar,
	IS_LEGACY_APPLICATION tinyint(1),
	ACTION_CL varchar,
	PREV_ONBOARDING_APPLICATION_FK bigint(20),
	NEXT_ONBOARDING_APPLICATION_FK bigint(20),
	OPERATION_CL varchar,
	OFFICER_CODE varchar,
	PROVIDER_OPERATION_CL varchar,
	MID_REQUEST_STATUS_CL varchar,
	MID_RESPONSE_STATUS_CL varchar,
	MERCHANT_CREATION_STATUS_CL varchar,
	PROVIDER_PROFILE_CONFIGURATION_STATUS_CL varchar,
	MERCHANT_FEE_CONFIGURATION_STATUS_CL varchar,
	BILLING_CONFIGURATION_STATUS_CL varchar,
	STATUS_CL varchar,
	FTP_ACCESS_CREATION_STATUS_CL varchar,
	VERIFICATION_RESPONSE_STATUS_CL varchar,
	VERIFICATION_RESPONSE_STATUS_DATE datetime,
	TERMINAL_CONFIGURATION_STATUS_CL varchar,
	TERMINAL_CONFIGURATION_DATE datetime,
	PROCESSING_PROFILE_FK bigint(20),
	PROVIDER_RESPONSE_CODE varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	PROVIDER_REFERENCE_NUMBER varchar,
	TITLE varchar,
	VERIFICATION_REQUEST_STATUS_CL varchar,
	VERIFICATION_REQUEST_DATE datetime,
	VERIFICATION_STATUS_CL varchar,
	ANNUAL_FEE_POLICY varchar,
	IS_LEGACY_APPLICATION tinyint(1),
	ACTION_CL varchar,
	PREV_ONBOARDING_APPLICATION_FK bigint(20),
	NEXT_ONBOARDING_APPLICATION_FK bigint(20),
	OFFICER_CODE varchar,
	PROVIDER_OPERATION_CL varchar,
	VERIFICATION_RESPONSE_STATUS_CL varchar,
	VERIFICATION_RESPONSE_STATUS_DATE datetime,
	TERMINAL_CONFIGURATION_STATUS_CL varchar,
	TERMINAL_CONFIGURATION_DATE datetime,
	ACCOUNT_PROCESSING_POLICY varchar,
	ACCOUNT_PROCESSING_POLICY varchar,
	OFFICER_CODE varchar,
	APPLICATION_CODE varchar,
	OFFICER_CODE varchar,
	APPLICATION_CODE varchar,
	ACCOUNT_PROCESSING_POLICY varchar,
	EXTRA_FEATURES_POLICY varchar,
	CARD_FEE_DESCRIPTOR varchar,
	FEE_PROCESSOR_TEMPLATE_ID bigint(20),
	FEE_PROCESSOR_APPLICATION_ID bigint(20),
	FEE_PROCESSOR_CONFIGURATION_STATUS_CL varchar,
	FEE_PROCESSOR_CONFIGURATION_DATE datetime,
	DIRECT_DEBIT_FEE_DESCRIPTOR varchar,
	TAG_LIST varchar,
	EXTRA_FEATURES_POLICY varchar,
	CARD_FEE_DESCRIPTOR varchar,
	FEE_PROCESSOR_TEMPLATE_ID bigint(20),
	FEE_PROCESSOR_APPLICATION_ID bigint(20),
	FEE_PROCESSOR_CONFIGURATION_STATUS_CL varchar,
	FEE_PROCESSOR_CONFIGURATION_DATE datetime,
	DIRECT_DEBIT_FEE_DESCRIPTOR varchar,
	TAG_LIST varchar,
	RECURRING_FEES_BEGIN_DATE datetime,
	REMITTANCE_START_DATE datetime,
	RECURRING_FEES_BEGIN_DATE datetime,
	REMITTANCE_START_DATE datetime,
	AGENT_CODE int(11),
	EXTRA_FEATURES_POLICY varchar,
	CARD_FEE_DESCRIPTOR varchar,
	FEE_PROCESSOR_TEMPLATE_ID bigint(20),
	FEE_PROCESSOR_APPLICATION_ID bigint(20),
	FEE_PROCESSOR_CONFIGURATION_STATUS_CL varchar,
	FEE_PROCESSOR_CONFIGURATION_DATE datetime,
	DIRECT_DEBIT_FEE_DESCRIPTOR varchar,
	TAG_LIST varchar,
	RECURRING_FEES_BEGIN_DATE datetime,
	REMITTANCE_START_DATE datetime,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;