Ellis improvement

ALTER TABLE BS_FILE_MANAGE
ADD COLUMN FILE_DIMENSION VARCHAR(50) DEFAULT NULL COMMENT 'File dimension (e.g., 1920x1080)',
ADD COLUMN CONTROL_REMARK VARCHAR(255) DEFAULT NULL COMMENT 'Control remark';

ALTER TABLE CO_DISPLAY_BANNER
ADD COLUMN REPETITION_YN CHAR(1) DEFAULT 'N' COMMENT 'Enable repetition (Y/N)',
ADD COLUMN MON_YN CHAR(1) DEFAULT 'N' COMMENT 'Repeat on Monday',
ADD COLUMN TUE_YN CHAR(1) DEFAULT 'N' COMMENT 'Repeat on Tuesday',
ADD COLUMN WED_YN CHAR(1) DEFAULT 'N' COMMENT 'Repeat on Wednesday',
ADD COLUMN THU_YN CHAR(1) DEFAULT 'N' COMMENT 'Repeat on Thursday',
ADD COLUMN FRI_YN CHAR(1) DEFAULT 'N' COMMENT 'Repeat on Friday',
ADD COLUMN SAT_YN CHAR(1) DEFAULT 'N' COMMENT 'Repeat on Saturday',
ADD COLUMN SUN_YN CHAR(1) DEFAULT 'N' COMMENT 'Repeat on Sunday',
ADD COLUMN REPETITION_FROM_TIME VARCHAR(5) DEFAULT NULL COMMENT 'Start time (HH:mm)',
ADD COLUMN REPETITION_TO_TIME VARCHAR(5) DEFAULT NULL COMMENT 'End time (HH:mm)',
ADD COLUMN CONTROL_REMARK VARCHAR(255) DEFAULT NULL COMMENT 'Control remark';

CREATE TABLE CO_POPULAR_DESTINATION_ITEM (
    POPULAR_DESTINATION_ITEM_SEQ     BIGINT AUTO_INCREMENT COMMENT '인기 여행지 순번'
        PRIMARY KEY,
    DISPLAY_AREA_SEQ            BIGINT                             NOT NULL COMMENT '전시 영역 순번',
    DESTINATION_NAME_EN         VARCHAR(100)                       NOT NULL COMMENT '여행지 이름: 영어',
    DESTINATION_NAME_KO         VARCHAR(100)                       NOT NULL COMMENT '여행지 이름: 한국어',
    DESTINATION_NAME_JA         VARCHAR(100)                       NULL COMMENT '여행지 이름: 일본어',
    DESTINATION_NAME_VI         VARCHAR(100)                       NULL COMMENT '여행지 이름: 베트남어',
    DESTINATION_NAME_ZH         VARCHAR(100)                       NULL COMMENT '여행지 이름: 중국어',
    DESTINATION_NAME_ZS         VARCHAR(255)                       NULL COMMENT '여행지 이름: 기타 언어 (ZS)',
    REGION_CODE                 BIGINT                             DEFAULT NULL COMMENT '지역 코드',
    COUNTRY_CODE                VARCHAR(10)                        DEFAULT NULL COMMENT '국가 코드',
    IMAGE_URL                   VARCHAR(500)                       DEFAULT NULL COMMENT '대표 이미지 URL',
    DISPLAY_ORDER               SMALLINT DEFAULT 999               NOT NULL COMMENT '노출 순서',
    CONTROL_REMARK              VARCHAR(500)                       NULL COMMENT '관리자 비고사항',
    FIRST_INSERT_UNO            BIGINT   DEFAULT 10000             NOT NULL COMMENT '최초 입력 사용자번호',
    FIRST_INSERT_DATETIME       DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT '최초 입력 시각',
    LAST_UPDATE_UNO             BIGINT   DEFAULT 10000             NOT NULL COMMENT '최종 수정 사용자번호',
    LAST_UPDATE_DATETIME        DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '최종 수정 시각',
    CONSTRAINT XPK_CO_POPULAR_DEST_ITEM
        UNIQUE (POPULAR_DESTINATION_ITEM_SEQ)
) COMMENT '컨텐츠_인기 여행지 항목';

CREATE INDEX XIN_CO_POPULAR_DEST_ITEM_REGION
ON CO_POPULAR_DESTINATION_ITEM (REGION_CODE);

CREATE INDEX XIN_CO_POPULAR_DEST_ITEM_COUNTRY
ON CO_POPULAR_DESTINATION_ITEM (COUNTRY_CODE);

CREATE TABLE OMH_SUITE.CO_POPULAR_DESTINATION_MASTER (
  POPULAR_DESTINATION_MASTER_SEQ bigint NOT NULL AUTO_INCREMENT COMMENT '대표 인기 여행지 그룹 순번',
  DISPLAY_AREA_SEQ bigint NOT NULL COMMENT '전시 영역 순번',
  GROUP_TITLE_EN varchar(100) NOT NULL COMMENT '그룹 제목: 영어',
  GROUP_TITLE_KO varchar(100) NOT NULL COMMENT '그룹 제목: 한국어',
  GROUP_TITLE_JA varchar(100) DEFAULT NULL COMMENT '그룹 제목: 일본어',
  GROUP_TITLE_VI varchar(100) DEFAULT NULL COMMENT '그룹 제목: 베트남어',
  GROUP_TITLE_ZH varchar(100) DEFAULT NULL COMMENT '그룹 제목: 중국어',
  GROUP_TITLE_ZS varchar(100) DEFAULT NULL COMMENT '그룹 제목: 기타',
  POPULAR_DESTINATION_ITEM_SEQS varchar(500) NOT NULL COMMENT '인기 여행지 아이템 SEQ 배열 (6개)',
  DISPLAY_ORDER smallint DEFAULT 999 COMMENT '표시 순서',
  CONTROL_REMARK varchar(500) DEFAULT NULL COMMENT '관리자 비고사항',
  FIRST_INSERT_UNO bigint NOT NULL DEFAULT 10000 COMMENT '최초 입력 사용자번호',
  FIRST_INSERT_DATETIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '최초 입력 시각',
  LAST_UPDATE_UNO bigint NOT NULL DEFAULT 10000 COMMENT '최종 수정 사용자번호',
  LAST_UPDATE_DATETIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '최종 수정 시각',
  PRIMARY KEY (POPULAR_DESTINATION_MASTER_SEQ),
  UNIQUE INDEX XPK_CO_POPULAR_DESTINATION_MASTER (POPULAR_DESTINATION_MASTER_SEQ)
)
ENGINE = INNODB,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_unicode_ci,
COMMENT = '대표 인기 여행지 그룹 마스터';

CREATE TABLE CO_HOTEL_RECOMMENDATION_MASTER (
    HOTEL_RECOMMENDATION_MASTER_SEQ BIGINT AUTO_INCREMENT PRIMARY KEY COMMENT '호텔 추천 그룹 순번',
    RECOMMENDATION_TITLE_EN VARCHAR(255) NOT NULL COMMENT 'Recommendation title (English)',
    RECOMMENDATION_TITLE_KO VARCHAR(255) NOT NULL COMMENT 'Recommendation title (Korean)',
    RECOMMENDATION_TITLE_JA VARCHAR(255) DEFAULT NULL COMMENT 'Recommendation title (Japanese)',
    RECOMMENDATION_TITLE_VI VARCHAR(255) DEFAULT NULL COMMENT 'Recommendation title (Vietnamese)',
    RECOMMENDATION_TITLE_ZH VARCHAR(255) DEFAULT NULL COMMENT 'Recommendation title (Chinese)',
    RECOMMENDATION_TITLE_ZS VARCHAR(255) DEFAULT NULL COMMENT 'Recommendation title (Simplified Chinese)',
    USE_YN CHAR(1) DEFAULT 'Y' NOT NULL COMMENT 'Use Yes/No',
    DISPLAY_FROM DATE DEFAULT NULL COMMENT 'Display start date',
    DISPLAY_TO DATE DEFAULT NULL COMMENT 'Display end date',
    FIRST_INSERT_UNO BIGINT NOT NULL DEFAULT 10000 COMMENT 'Created by user',
    FIRST_INSERT_DATETIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created datetime',
    LAST_UPDATE_UNO BIGINT NOT NULL DEFAULT 10000 COMMENT 'Updated by user',
    LAST_UPDATE_DATETIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated datetime',
    CONTROL_REMARK VARCHAR(500) DEFAULT NULL COMMENT 'Admin remarks'
) COMMENT='Hotel recommendation master table with multilingual titles and display control';

CREATE TABLE CO_HOTEL_RECOMMENDATION_ITEM (
    HOTEL_RECOMMENDATION_ITEM_SEQ BIGINT AUTO_INCREMENT PRIMARY KEY COMMENT '호텔 추천 아이템 순번',
    HOTEL_RECOMMENDATION_MASTER_SEQ BIGINT NOT NULL COMMENT '호텔 추천 마스터 순번',
    HOTEL_CODE BIGINT NOT NULL COMMENT '호텔 코드',
    IMAGE_URL VARCHAR(1000) DEFAULT NULL COMMENT '이미지 URL',
    DISPLAY_ORDER SMALLINT NOT NULL DEFAULT 999 COMMENT '표시 순서',
    BASIS_CURRENCY VARCHAR(10) DEFAULT NULL COMMENT '기준 통화 (예: USD, KRW)',
    LOWEST_RATE DECIMAL(15, 2) DEFAULT NULL COMMENT '최저 요금',
    USE_YN CHAR(1) NOT NULL DEFAULT 'Y' COMMENT '사용 여부',
    FIRST_INSERT_UNO BIGINT NOT NULL DEFAULT 10000 COMMENT '최초 입력 사용자번호',
    FIRST_INSERT_DATETIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '최초 입력 시각',
    LAST_UPDATE_UNO BIGINT NOT NULL DEFAULT 10000 COMMENT '최종 수정 사용자번호',
    LAST_UPDATE_DATETIME DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '최종 수정 시각',
    CONTROL_REMARK VARCHAR(500) DEFAULT NULL COMMENT '관리자 비고사항'
) COMMENT='Hotel recommendation item table';

Testing on task #1410