-- Create Table Statement for 'Wells Fargo Onboarding Owner'
DROP TABLE IF EXISTS `WELLS_FARGO_ONBOARDING_OWNER`;
CREATE TABLE `WELLS_FARGO_ONBOARDING_OWNER` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	ONBOARDING_OWNER_FK bigint(20),
	OWNER_TYPE varchar,
	OWNER_F_NAME varchar,
	OWNER_L_NAME varchar,
	OWNER_EMAIL_ADDRESS varchar,
	OWNER_PHONE_NUMBER varchar,
	OWNER_STREET varchar,
	OWNER_CITY varchar,
	OWNER_STATE varchar,
	OWNER_ZIP varchar,
	OWNER_COUNTRY varchar,
	OWNER_PERCENTAGE varchar,
	OWNER_DOB varchar,
	OWNER_CITIZENSHIP varchar,
	OWNERSHIP_TYPE varchar,
	WELLS_FARGO_PROVISIONING_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;