Actions
결함(Bug) #315
open[Log] Add log front end for Admin Site, Dotbiz
Added by Joseph Vo 10 months ago. Updated 7 months ago.
Start date:
05/21/2025
Due date:
05/22/2025 (about 10 months late)
% Done:
100%
Estimated time:
12.00 h
Part:
Build env.:
Staging
Description
Request :
Add log front end for Admin Site, Dotbiz
Updated by Tom Dong 10 months ago
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);
Actions
