-- Create Table Statement for 'Vantiv Tandem Onboarding Owner'
DROP TABLE IF EXISTS `VANTIV_TANDEM_ONBOARDING_OWNER`;
CREATE TABLE `VANTIV_TANDEM_ONBOARDING_OWNER` (
	CREATE_DATE datetime,
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CONTACT_FULL_NAME varchar,
	CONTACT_FIRST_NAME varchar,
	CONTACT_LAST_NAME varchar,
	TITLE varchar,
	ADDRESS_LINE1 varchar,
	ADDRESS_LINE2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	PHONE varchar,
	EMAIL varchar,
	PERCENT_OWNED varchar,
	DATE_OF_BIRTH varchar,
	TIME_ZONE varchar,
	CONTACT_TYPE varchar,
	ONBOARDING_OWNER_FK bigint(20),
	STATUS varchar,
	DESCRIPTION varchar,
	TANDEM_UPDATE_ID varchar,
	VANTIV_TANDEM_PROVISIONING_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;