-- Create Table Statement for 'Vantiv Tandem Onboarding Terminal'
DROP TABLE IF EXISTS `VANTIV_TANDEM_ONBOARDING_TERMINAL`;
CREATE TABLE `VANTIV_TANDEM_ONBOARDING_TERMINAL` (
	ID bigint(20) NOT NULL,
	EQUIPMENT_CODE varchar,
	VANTIV_TANDEM_PROVISIONING_TRANSACTION_FK bigint(20),
	ENVIRONMENT varchar,
	CARD_TYPE1 varchar,
	CARD_TYPE2 varchar,
	CARD_TYPE3 varchar,
	CARD_TYPE4 varchar,
	CARD_TYPE5 varchar,
	CARD_TYPE6 varchar,
	AUTO_CLOSE varchar,
	AUTO_CLOSE_TIME varchar,
	CUSTOMER_SPECIFIC_TERMINAL_LEVEL_ID varchar,
	MERCHANT_ACCOUNT_CODE int(11),
	CARD_TYPE7 varchar,
	TERMINAL_ID varchar,
	DESCRIPTION varchar,
	STATUS varchar,
	ONBOARDING_TERMINAL_FK bigint(20),
	TANDEM_UPDATE_ID varchar,
	STATUS varchar,
	ONBOARDING_TERMINAL_FK bigint(20),
	TANDEM_UPDATE_ID varchar,
	STATUS varchar,
	ONBOARDING_TERMINAL_FK bigint(20),
	TANDEM_UPDATE_ID varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;