-- Create Table Statement for 'Provisioning Transaction Response Detail' DROP TABLE IF EXISTS `PROVISIONING_TRANSACTION_RESPONSE_DETAIL`; CREATE TABLE `PROVISIONING_TRANSACTION_RESPONSE_DETAIL` ( ID bigint(20) NOT NULL, MERCHANT_ACCOUNT_CODE int(11) NOT NULL, FIELD_NAME varchar, PORTFOLIO_CODE int(11), RESPONSE_MESSAGE varchar, OBJECT_NAME varchar, PROVISIONING_TRANSACTION_RESPONSE_STATUS_CL varchar, PROVIDER_RESPONSE_MESSAGE varchar, PROVIDER_RESPONSE_CODE varchar, RESPONSE_MESSAGE varchar, PROVIDER_RESPONSE_MESSAGE varchar, RESPONSE_MESSAGE varchar, PROVIDER_RESPONSE_MESSAGE varchar, RAW_ERROR_DATA longtext, RESPONSE_DATA longtext, RAW_RESPONSE_DATA_TYPE varchar, RAW_WARNING_DATA longtext, RAW_SUPPLEMENT_DATA longtext, PROVIDER_OPERATION_NAME varchar, REQUEST_DATE datetime, RESPONSE_DATE datetime, RAW_ERROR_DATA longtext, RESPONSE_DATA longtext, RAW_RESPONSE_DATA_TYPE varchar, RAW_WARNING_DATA longtext, RAW_SUPPLEMENT_DATA longtext, PROVIDER_OPERATION_NAME varchar, REQUEST_DATE datetime, RESPONSE_DATE datetime, PROVIDER_RESPONSE_CODE varchar, PROVIDER_RESPONSE_CODE varchar, RAW_ERROR_DATA longtext, RESPONSE_DATA longtext, RAW_RESPONSE_DATA_TYPE varchar, RAW_WARNING_DATA longtext, RAW_SUPPLEMENT_DATA longtext, PROVIDER_OPERATION_NAME varchar, REQUEST_DATE datetime, RESPONSE_DATE datetime, PROVISIONING_TRANSACTION_FK bigint(20), PROVISIONING_TRANSACTION_FK bigint(20), PROVISIONING_TRANSACTION_FK bigint(20), PRIMARY KEY (ID) ) ENGINE=InnoDB;