Ellis improvement

Table Logs

--
-- Create table `BS_B2C_TRANSACTION_LOG`
--
CREATE TABLE BS_B2C_TRANSACTION_LOG (
  B2C_TRANSACTION_LOG_SEQ bigint NOT NULL AUTO_INCREMENT,
  STATION_TYPE_CODE varchar(5) NOT NULL COMMENT 'STN01: B2C; STN02: Partnert; STN03: Admin',
  API_SERVICE_URL varchar(1500) DEFAULT NULL COMMENT 'API_SERVICE_URL',
  ERROR_MESSAGE mediumtext DEFAULT NULL COMMENT 'ERROR_MESSAGE',
  USER_AGENT mediumtext DEFAULT NULL COMMENT 'USER_AGENT',
  REQUEST_UNO bigint DEFAULT NULL,
  ERROR_YN varchar(1) NOT NULL DEFAULT 'N' COMMENT 'ERROR_YN',
  TRANSACTION_DATETIME datetime DEFAULT NULL,
  PRIMARY KEY (B2C_TRANSACTION_LOG_SEQ),
  UNIQUE INDEX XPK_BS_B2C_TRANSACTION_LOG (B2C_TRANSACTION_LOG_SEQ)
)
ENGINE = INNODB,
AUTO_INCREMENT = 1297,
AVG_ROW_LENGTH = 2128,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_unicode_ci;

--
-- Create index `XIF_BS_B2C_TRANSACTION_LOG_01` on table `BS_B2C_TRANSACTION_LOG`
--
ALTER TABLE BS_B2C_TRANSACTION_LOG
ADD FULLTEXT INDEX XIF_BS_B2C_TRANSACTION_LOG_01 (API_SERVICE_URL);

--
-- Create index `XIN_BS_B2C_TRANSACTION_LOG_02` on table `BS_B2C_TRANSACTION_LOG`
--
ALTER TABLE BS_B2C_TRANSACTION_LOG
ADD INDEX XIN_BS_B2C_TRANSACTION_LOG_02 (STATION_TYPE_CODE);

--
-- Create index `XIN_BS_B2C_TRANSACTION_LOG_03` on table `BS_B2C_TRANSACTION_LOG`
--
ALTER TABLE BS_B2C_TRANSACTION_LOG
ADD INDEX XIN_BS_B2C_TRANSACTION_LOG_03 (REQUEST_UNO);

--
-- Create index `XIN_BS_B2C_TRANSACTION_LOG_04` on table `BS_B2C_TRANSACTION_LOG`
--
ALTER TABLE BS_B2C_TRANSACTION_LOG
ADD INDEX XIN_BS_B2C_TRANSACTION_LOG_04 (ERROR_YN);