OMH

CREATE TABLE OMH_SUITE.VD_VENDOR_HOTEL_MASTER_EXT (
VENDOR_COMP_CODE int(11) NOT NULL COMMENT '공급자 회사 코드',
VENDOR_HOTEL_CODE varchar(50) NOT NULL COMMENT '공급자 호텔 코드',
RATING_AVERAGE varchar(5) DEFAULT NULL COMMENT 'Rating hotel',
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 (VENDOR_COMP_CODE, VENDOR_HOTEL_CODE)
)
ENGINE = INNODB,
AVG_ROW_LENGTH = 1544,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_unicode_ci,
COMMENT = '공급_공급자 호텔 마스터';

ALTER TABLE OMH_SUITE.VD_VENDOR_HOTEL_MASTER_EXT
ADD INDEX XIF_VD_VENDOR_HOTEL_MASTER_EXT_01 (VENDOR_COMP_CODE);

ALTER TABLE OMH_SUITE.VD_VENDOR_HOTEL_MASTER_EXT
ADD INDEX XIF_VD_VENDOR_HOTEL_MASTER_EXT_02 (VENDOR_HOTEL_CODE);

ALTER TABLE OMH_SUITE.VD_VENDOR_HOTEL_MASTER_EXT
ADD UNIQUE INDEX XPK_VD_VENDOR_HOTEL_MASTER_EXT (VENDOR_COMP_CODE, VENDOR_HOTEL_CODE);

CREATE TABLE OMH_SUITE.HO_HOTEL_MASTER_EXT (
HOTEL_CODE bigint(20) NOT NULL COMMENT 'hotel-code',
AGODA_RATING_AVERAGE varchar(5) DEFAULT NULL COMMENT 'Agoda Rating hotel',
PRIMARY KEY (HOTEL_CODE),
LAST_UPDATE_UNO bigint NOT NULL DEFAULT 10000 COMMENT '최종 수정 사용자번호',
LAST_UPDATE_DATETIME datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '최종 수정 시각',
UNIQUE INDEX XPK_HO_HOTEL_MASTER_EXT (HOTEL_CODE)
)
ENGINE = INNODB,
AVG_ROW_LENGTH = 5563,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_unicode_ci,
COMMENT = 'table HO_HOTEL_MASTER_EXT from HO_HOTEL_MASTER';