-- Create Table Statement for 'PayFacto Onboarding Terminal'
DROP TABLE IF EXISTS `PAYFACTO_ONBOARDING_TERMINAL`;
CREATE TABLE `PAYFACTO_ONBOARDING_TERMINAL` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TERMINAL_ID varchar,
	SET_LIKE_TERMINAL_ID varchar,
	PINPAD_ID varchar,
	TERMINAL_COMMAND varchar,
	PINPAD_COMMAND varchar,
	RESULT_CODE varchar,
	RESULT_TEXT varchar,
	PINPAD_RESULT_CODE varchar,
	PINPAD_RESULT_TEXT varchar,
	ONBOARDING_TERMINAL_FK bigint(20),
	MERCHANT_ID varchar,
	PAYFACTO_PROVISIONING_TRANSACTION_FK bigint(20),
	PINPAD_STATUS varchar,
	PINPAD_STATUS_DESC varchar,
	PINPAD_UPDATE_TYPE varchar,
	PINPAD_UPDATE_TYPE_DESC varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;