-- Create Table Statement for 'Paymentech Principal'
DROP TABLE IF EXISTS `PAYMENTECH_PRINCIPAL`;
CREATE TABLE `PAYMENTECH_PRINCIPAL` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	BUSINESS_OWNER_FK bigint(20),
	PRINCIPAL_OWNER_FIRST_NAME varchar,
	PRINCIPAL_OWNER_LAST_NAME varchar,
	PRINCIPAL_OWNER_STREET_ADDRESS varchar,
	PRINCIPAL_OWNER_STREET_ADDRESS2 varchar,
	PRINCIPAL_OWNER_CITY varchar,
	PRINCIPAL_OWNER_STATE varchar,
	PRINCIPAL_OWNER_COUNTRY varchar,
	PRINCIPAL_OWNER_ZIP_CODE varchar,
	PRINCIPAL_OWNER_DOB varchar,
	PRINCIPAL_OWNER_TAX_ID varchar,
	PRINCIPAL_OWNER_ID_TYPE varchar,
	PRINCIPAL_OWNER_PHONE_NUMBER varchar,
	PAYMENTECH_PROVISIONING_TRANSACTION_FK bigint(20),
	ONBOARDING_OWNER_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;