-- Create Table Statement for 'Paymentus Auth Retail Transaction'
DROP TABLE IF EXISTS `PAYMENTUS_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `PAYMENTUS_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	USER_LOGIN_ID varchar,
	HEADER_OPERATION varchar,
	HEADER_EXTERNAL_REFERENCE_NUMBER varchar,
	HEADER_ACCOUNT_NUMBER varchar,
	HEADER_REFERENCE_NUMBER varchar,
	HEADER_PAYMENT_AMOUNT varchar,
	HEADER_PAYMENT_TYPE_CODE varchar,
	PAYMENT_METHOD_TYPE varchar,
	PAYMENT_METHOD_CARD_HOLDER_NAME varchar,
	PAYMENT_METHOD_CREDIT_CARD_EXPIRY_MONTH varchar,
	PAYMENT_METHOD_CREDIT_CARD_EXPIRY_YEAR varchar,
	CUSTOMER_FIRST_NAME varchar,
	CUSTOMER_MIDDLE_NAME varchar,
	CUSTOMER_LAST_NAME varchar,
	CUSTOMER_DAY_PHONE_NR varchar,
	CUSTOMER_EMAIL varchar,
	CUSTOMER_ADDRESS_LINE1 varchar,
	CUSTOMER_ADDRESS_STATE varchar,
	CUSTOMER_ADDRESS_ZIP_CODE varchar,
	CUSTOMER_ADDRESS_CITY varchar,
	CUSTOMER_ADDRESS_COUNTRY varchar,
	PAYMENT_RESPONSE_PAYMENT_STATUS varchar,
	PAYMENT_RESPONSE_PAYMENT_STATUS_DESCRIPTION varchar,
	PAYMENT_RESPONSE_ERRORS varchar,
	PAYMENT_RESPONSE_REFERENCE_NUMBER varchar,
	PAYMENT_RESPONSE_PAYMENT_DATE varchar,
	PAYMENT_RESPONSE_PAYMENT_AMOUNT varchar,
	PAYMENT_RESPONSE_CONVENIENCE_FEE varchar,
	PAYMENT_RESPONSE_TOTAL_AMOUNT varchar,
	PAYMENT_RESPONSE_ADDITIONAL_AMOUNT varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	PAYMENT_METHOD_FI_NAME varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;