-- Create Table Statement for 'Payment Option'
DROP TABLE IF EXISTS `PAYMENT_OPTION`;
CREATE TABLE `PAYMENT_OPTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	REF_CODE varchar,
	SYS_MESSAGE varchar,
	CREATE_DATE datetime,
	IMPORT_DATE datetime,
	IS_ACTIVE tinyint(1),
	HOLDER_NAME varchar,
	TOKEN_CODE varchar,
	NUMBER varchar,
	NUMBER_LAST4 varchar,
	MASKED_NUMBER varchar,
	ACCESSORY varchar,
	MASKED_ACCESSORY varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	COUNTRY_CL varchar,
	FIRST_BILLING_DATE datetime,
	PAYMENT_OPTION_CL varchar,
	COLLECTOR_ACCOUNT_CODE int(11),
	LAST_UPDATE_DATE datetime,
	ISSUER_BANK_NAME varchar,
	ISSUER_BANK_PHONE varchar,
	DECLINE_COUNT int(11),
	DECLINE_DATE datetime,
	DECLINE_CL varchar,
	IS_VISIBLE_EXTERNALLY tinyint(1),
	ENCODED_BIN varchar,
	ACTIVATOR_CODE varchar,
	IS_BIN_UNAVAILABLE tinyint(1),
	IS_UPDATE_REQUIRED tinyint(1),
	LAST_ACCOUNT_UPDATE_DATE datetime,
	CUSTOMER_ACCOUNT_FK bigint(20),
	BANK_INFO_FK int(11),
	ACCOUNT_UPDATER_HISTORY_FK bigint(20),
	PHONE varchar,
	LAST_ACTIVATE_DATE datetime,
	BASE_OBJECT_CODE bigint(20),
	TOKEN_EXTENDED varchar,
	LAST_EMAIL_ACCOUNT_EXPIRATION_SENT_DATE datetime,
	NETWORK_TRANSACTION_ID varchar,
	NETWORK_TRANSACTION_ID varchar,
	NETWORK_TRANSACTION_ID varchar,
	CARD_TYPE varchar,
	CARD_TYPE varchar,
	ADDRESS varchar,
	ADDRESS varchar,
	HOLDER_NAME varchar,
	CARD_TYPE varchar,
	ADDRESS varchar,
	CARD_TYPE varchar,
	ADDRESS varchar,
	IS_ACTIVE tinyint(1),
	HOLDER_NAME varchar,
	NUMBER varchar,
	NETWORK_TRANSACTION_ID varchar,
	NETWORK_TRANSACTION_ID varchar,
	COUNTRY_CL varchar,
	COUNTRY_CL varchar,
	TOKEN varchar,
	TOKEN varchar,
	TOKEN varchar,
	BANK_INFO_FK int(11),
	BANK_INFO_FK int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;