OMH

CREATE TABLE OMH_SUITE.BK_BOOKING_HOTEL_B2C_VERIFICATION (
BOOKING_ITEM_CODE varchar(20) NOT NULL COMMENT '예약 아이템 코드',
PIN_CODE varchar(5) NOT NULL COMMENT 'pin code booking non-member',
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 (BOOKING_ITEM_CODE, PIN_CODE)
)
ENGINE = INNODB,
AVG_ROW_LENGTH = 833,
CHARACTER SET utf8mb4,
COLLATE utf8mb4_unicode_ci,
COMMENT = 'booking item verify b2c';

curl --location 'https://dev-newapi.ohmyhotel.com/user/send-pin-booking-code' \
--header 'sec-ch-ua-platform: "Windows"' \
--header 'Referer: http://localhost:4201/' \
--header 'User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.0.0 Safari/537.36' \
--header 'Accept: application/json, text/plain, */*' \
--header 'sec-ch-ua: "Not)A;Brand";v="8", "Chromium";v="138", "Google Chrome";v="138"' \
--header 'Content-Type: application/json' \
--header 'sec-ch-ua-mobile: ?0' \
--data '{
"stationTypeCode": "STN01",
"currency": "KRW",
"country": "KR",
"language": "KO",
"condition": {
"bookingItemCode": "191019AQ08H01"
}
}'