COPY-11ST

Tables (16)

API Interlocking unreceived information transmission (tb_11st_nonrcv_log)

  • Interface serial number (intrfc_log_id) — BIGINT — Primary key — NOT NULL
  • Interface sequence (intrfc_mst_seq) — BIGINT — Foreign key → Interface master.Interface master ID — NOT NULL
  • Interface date and time (intrfc_dt) — DATETIME — NOT NULL
  • Interface status (intrfc_stts) — VARCHAR(3) — NOT NULL
  • Interface result (intrfc_rslt) — VARCHAR(3) — NOT NULL
  • Booking number (rsrv_no_11st) — Long — NOT NULL — 11st Reservation Number
  • Reservation serial number (rsrv_seq_11st) — Long — NOT NULL — Reservation Sequence from 11st
  • Order Number (ordr_no_11st) — Long — NOT NULL — Order Number
  • Order product order (ordr_prd_seq_11st) — Long — NOT NULL — Order Number Sequence
  • Reservation status (rsrv_stts) — VARCHAR(3) — Reservation status from 11st
  • OMH Reservation number (rsrv_no01_omh) — VARCHAR(200) — NOT NULL — Booking number 01 from OMH
  • OMH Reservation number 2 (rsrv_no02_omh) — VARCHAR(200)
  • OMH Revision date (res_updtd_dt) — DATETIME — OMH updated date for final cancel fee and alternative text
  • RES Result code (res_rslt_cd) — VARCHAR(4) — OMH Response Fail/Success Result Code
  • RES Message (res_rslt_msg) — VARCHAR(500) — Response Fail/Success Message from OMH

API Product Addition & Modification (tb_11st_add_prdct_log)

  • Interface serial number (intrfc_log_id) — BIGINT — Primary key — NOT NULL — interface log sequence
  • Interface sequence (intrfc_mst_seq) — BIGINT — Foreign key → Interface master.Interface master ID — NOT NULL
  • Interface date and time (intrfc_dt) — DATETIME — NOT NULL
  • Interface status (intrfc_stts) — VARCHAR(3) — NOT NULL
  • Interface result (intrfc_rslt) — VARCHAR(3) — NOT NULL
  • Interface failure message (intrfc_err_msg) — VARCHAR(500)
  • Callback URL (callback_url) — VARCHAR(500) — NOT NULL

API Product Registration (tb_11st_reg_prdct_log)

  • Interface serial number (intrfc_log_id) — BIGINT — Primary key — NOT NULL — interface log id
  • Interface sequence (intrfc_mst_seq) — BIGINT — Foreign key → Interface master.Interface master ID — NOT NULL
  • Interface date and time (intrfc_dt) — DATETIME — NOT NULL
  • Interface status (intrfc_stts) — VARCHAR(3) — NOT NULL
  • Interface result (intrfc_rslt) — VARCHAR(3) — NOT NULL
  • Call url (call_url) — VARCHAR(500) — NOT NULL — Call Url for registering product

API Product Search (tb_11st_prdt_req_log)

  • Interface serial number (intrfc_req_id) — BIGINT — Primary key — NOT NULL — Interface Request Id
  • Interface master ID (intrfc_mst_id) — BIGINT — Foreign key → Interface master.Interface master ID — NOT NULL — Interface Master Id
  • Interface date and time (intrfc_dt) — DATETIME — NOT NULL — Interface date and time
  • Interface status (intrfc_stts) — VARCHAR(3) — interface status code
  • Interface result (intrfc_rslt) — VARCHAR(3) — Interface result
  • SiGunGu — VARCHAR(256) — NOT NULL — OMH Hotel Address Name
  • Check-in (chk_in) — DATE — Check In date - YYYYMMDD
  • Check out (chk_out) — DATE — Check out date - YYYYMMDD
  • Number of rooms (room_cnt) — INTEGER — NOT NULL
  • OMH Revision date and time (res_updtd_dt) — DATETIME — OMH Response date and time
  • OMH Result code (res_rslt_cd) — VARCHAR(4) — Response Fail /Success Result Code from OMH

API Requesting Cancellation Fees (tb_11st_cncl_plcy_log)

  • Interface serial number (intrfc_log_id) — BIGINT — Primary key — NOT NULL
  • Interface sequence (intrfc_mst_seq) — BIGINT — Foreign key → Interface master.Interface master ID — NOT NULL
  • Interface date and time (intrfc_dt) — DATETIME — NOT NULL
  • Interface status (intrfc_stts) — VARCHAR(3) — NOT NULL
  • Interface result (intrfc_rslt) — VARCHAR(3) — NOT NULL
  • Booking number (rsrv_no_11st) — Long — NOT NULL — 11st Reservation Number
  • Seller Product Code (prd_cd) — VARCHAR(256) — NOT NULL — Seller Product Code(OMH Hotel Code)
  • Item number (itm_no) — VARCHAR(100) — NOT NULL — Room Code
  • Item start date (bgn_dt) — DATE — Check In Date
  • Item end date (end_dt) — DATE — Check Out Date
  • Number of rooms (room_cnt) — INTEGER — Room Count
  • Number of adults (adlt_cnt) — INTEGER — Adult Count
  • Seller number (sllr_no) — Long — NOT NULL — Seller Number from 11st
  • Final cancellation fee (fnl_cncl_fee) — INTEGER — NOT NULL — Final Cancel Fee Amount
  • Alternative text (altrntv_txt) — VARCHAR(500) — Cancel Fee Alternative Text
  • OMH Revision date (res_updtd_dt) — DATETIME — OMH updated date for final cancel fee and alternative text
  • RES Result code (res_rslt_cd) — VARCHAR(4) — Response Fail /Success Result Code
  • RES Result message (res_rslt_msg) — VARCHAR(500) — Response Fail /Success Message from OMH

API Reservation Payment Completion (tb_11st_rsrvtn_log)

  • Interface serial number (intrfc_log_id) — BIGINT — Primary key — NOT NULL
  • Interface sequence (intrfc_mst_seq) — BIGINT — Foreign key → Interface master.Interface master ID — NOT NULL
  • Interface date and time (intrfc_dt) — DATETIME — NOT NULL
  • Interface status (intrfc_stts) — VARCHAR(3) — NOT NULL
  • Interface result (intrfc_rslt) — VARCHAR(3) — NOT NULL
  • Booking number (rsrv_no_11st) — Long — NOT NULL — 11st Reservation Number
  • Reservation date and time (rsrvtn_dt_11st) — VARCHAR(14) — NOT NULL — Reservation Date and Time - YYYYMMDDHH24MISS
  • Purchase member number (buy_mbr_no) — VARCHAR(20) — NOT NULL — 11st Member Number(buyMemNo)
  • Purchase member name (buy_mbr_nm) — VARCHAR(30) — NOT NULL — 11st Member Name(buyMemNm)
  • 11th Street Item Number (prdct_no_11st) — VARCHAR(20) — NOT NULL — 11st Product Id
  • Immediate payment (drct_sttlmnt_yn) — enum('Y', 'N') — NOT NULL
  • Item start date (bgn_dt) — DATE — Check In Date
  • Item end date (end_dt) — DATE — Check Out Date
  • Seller Product Code (prdct_cd) — VARCHAR(256) — NOT NULL — Seller Product Code(OMH Hotel Code)
  • Item number (itm_no) — VARCHAR(100) — NOT NULL — Room Code
  • Number of rooms (rsrv_room_cnt) — INTEGER — Reserved Room Count
  • Room name (rsrv_room_nm) — VARCHAR(256) — NOT NULL — Reserved Room Name
  • Reservation email address (rsrv_mem_email) — VARCHAR(100) — NOT NULL — Reserved member email address
  • Reservation phone number (rsrv_mem_mbl_no) — VARCHAR(20) — NOT NULL — Reserved member mobile number
  • Reservation phone number (rsrv_mem_tel_no) — VARCHAR(20) — NOT NULL — Reserved Member Telephone Number
  • Booker's Gender (rsrv_mem_sex) — ENUM('F', 'M') — NOT NULL — Female - F, Male - M
  • Birthday of the person making the reservation (rsrv_mem_brth_dt) — DATE — NOT NULL — Reserved Member birth date
  • Customer requirements (rsrv_cstmr_rmrk) — VARCHAR(500) — Customer Remark
  • 11th Street order number (ordr_no) — Long — NOT NULL — Order Number 11st
  • Seller number (sllr_no) — Long — NOT NULL — Seller Number from 11st
  • OMH Revision date and time (res_updtd_dt) — DATETIME — OMH updated date
  • OMH Reservation number (res_rsrv_no_omh) — VARCHAR(200) — OMH booking number
  • OMH Reservation number 2 (res_rsrv_no_02_omh) — VARCHAR(200) — OMH booking number 2
  • RES Result code (res_rslt_cd) — VARCHAR(4) — Response Fail /Success Result Code from OMH
  • RES Message (res_rslt_msg) — VARCHAR(500) — Response Fail /Sucess Message from OMH

API Room Information Inquiry (tb_11st_rmtyp_log)

  • Interface serial number (intrfc_req_id) — BIGINT — Primary key — NOT NULL — Interface Request Id
  • Interface master ID (intrfc_mst_id) — BIGINT — Foreign key → Interface master.Interface master ID — NOT NULL — Interface Master Id
  • Interface date and time (intrfc_dt) — DATETIME — NOT NULL — Interface date and time
  • Interface status (intrfc_stts) — VARCHAR(3) — interface status code
  • Interface result (intrfc_rslt) — VARCHAR(3) — Interface result
  • Product number (prd_cd) — VARCHAR(256) — NOT NULL — OMH Hotel Code
  • Check-in (chk_in) — DATE — Check In date - YYYYMMDD
  • Check out (chk_out) — DATE — Check out date - YYYYMMDD
  • Number of rooms (room_cnt) — INTEGER — NOT NULL
  • OMH Result code (res_rslt_cd) — VARCHAR(4) — Response Fail/Success Result Code from OMH
  • OMH Revision date and time (res_updtd_dt) — DATETIME — OMH Response date and time

API for sending payment cancellation completion details (tb_11st_cncl_pymnt_log)

  • Interface serial number (intrfc_log_id) — BIGINT — Primary key — NOT NULL
  • Interface sequence (intrfc_mst_seq) — BIGINT — Foreign key → Interface master.Interface master ID — NOT NULL
  • Interface date and time (intrfc_dt) — DATETIME — NOT NULL
  • Interface status (intrfc_stts) — VARCHAR(3) — NOT NULL
  • Interface result (intrfc_rslt) — VARCHAR(3) — NOT NULL
  • Booking number (rsrv_no_11st) — Long — NOT NULL — 11st Reservation Number
  • Reservation serial number (rsrv_seq_11st) — Long — NOT NULL — Reservation Sequence from 11st
  • Order Number (ordr_no_11st) — Long — NOT NULL — Order Number
  • Order product order (ordr_prd_seq_11st) — Long — NOT NULL — Order Number Sequence
  • Product number (prd_no_11st) — VARCHAR(20) — NOT NULL — 11st Production number
  • Product details (rsrv_dtl_nm) — VARCHAR(256) — NOT NULL — Reservation detail name
  • Price (sel_prc) — INTEGER — NOT NULL — Selling Price
  • Cancellation penalty (fnl_cncl_fee) — INTEGER — NOT NULL — Final Cancel Fee Amount
  • Seller Product Code (prd_cd) — VARCHAR(256) — NOT NULL — Seller Product Code(OMH Hotel Code)
  • OMH Reservation number (rsrv_no01_omh) — VARCHAR(200) — NOT NULL — Booking number 01 from OMH
  • OMH Reservation number 2 (rsrv_no02_omh) — VARCHAR(200)
  • OMH Revision date (res_updtd_dt) — DATETIME — OMH updated date for final cancel fee and alternative text
  • RES Result code (res_rslt_cd) — VARCHAR(4) — OMH Response Fail/Success Result Code
  • RES Message (res_rslt_msg) — VARCHAR(500) — Response Fail/Success Message from OMH

Add reservation payment completion (tb_11st_rsrvtn_addnf_log)

  • Interface serial number (intrfc_log_id) — BIGINT — Foreign key → API Reservation Payment Completion.Interface serial number — NOT NULL
  • Additional information Serial number (infrmtn_seq) — Long — NOT NULL
  • Number of adults (adlt_cnt) — INTEGER — NOT NULL — Adult Count
  • Number of children (chld_cnt) — INTEGER — NOT NULL — Child Count
  • Number of infants (baby_cnt) — INTEGER — NOT NULL — Baby Count
  • Bed type code (bed_typ_cd) — VARCHAR(1) — Bed Type Code
  • Bed type name (bed_typ_nm) — VARCHAR(10) — Bed Type Name

Category Group (tb_ctgry_grp)

  • Category Group ID (ctgry_grp_id) — VARCHAR(18) — Primary key — NOT NULL — categroy group id
  • Channel code (chnnl_cd) — VARCHAR(18) — NOT NULL
  • Category group name (ctgry_grp_nm) — VARCHAR(50) — NOT NULL
  • Category level (ctgry_lvl) — INT — NOT NULL
  • Category Group ID (up_lvl_ctgry_grp_id) — VARCHAR(18) — Foreign key → Category Group.Category Group ID — NOT NULL — upper level category group id
  • Use or not (use_yn) — enum('Y', 'N') — NOT NULL
  • Registrant (reg_id) — VARCHAR(18) — NOT NULL
  • Registration date and time (reg_dt) — DATETIME — NOT NULL
  • Modifier (chg_id) — VARCHAR(18) — NOT NULL
  • Date of change (chg_dt) — DATETIME — NOT NULL

Common code group (tb_cmmn_cd_grp)

  • Public code group (cmmn_grp_cd) — VARCHAR(18) — Primary key — NOT NULL — common code
  • Channel code (chnnl_cd) — VARCHAR(18) — Primary key — NOT NULL — Vendor/Channel/OTA/Supplier Code
  • Public code group name (cd_grp_nm) — VARCHAR(50) — NOT NULL
  • Common code group level (cmmn_cd_grp_lvl) — INT — NOT NULL
  • Use or not (use_yn) — enum('Y', 'N') — NOT NULL
  • Registrant (reg_id) — VARCHAR(18) — NOT NULL
  • Registration date and time (reg_dt) — DATETIME — NOT NULL
  • Modifier (chg_id) — VARCHAR(18) — NOT NULL
  • Date of change (chg_dt) — DATETIME — NOT NULL

Common group details (tb_cmmn_cd_dtl)

  • Public code (cmmn_cd) — VARCHAR(18) — Primary key — NOT NULL
  • Public code group (cmmn_grp_cd) — VARCHAR(18) — Foreign key → Common code group.Public code group — NOT NULL — common code
  • Channel code (chnnl_cd) — VARCHAR(18) — Foreign key → Common code group.Channel code — NOT NULL — Vendor/Channel/OTA/Supplier Code
  • Public code name (cd_nm) — VARCHAR(50) — NOT NULL
  • Use or not (use_yn) — enum('Y', 'N') — NOT NULL
  • Registrant (reg_id) — VARCHAR(18) — NOT NULL
  • Registration date and time (reg_dt) — DATETIME — NOT NULL
  • Modifier (chg_id) — VARCHAR(18) — NOT NULL
  • Date of change (chg_dt) — DATETIME — NOT NULL

Guest information (tb_11st_rsrvtn_mmbr_log)

  • Interface serial number (intrfc_log_id) — BIGINT — Foreign key → Add reservation payment completion.Interface serial number — NOT NULL
  • Guest serial number (mem_seq) — Long — NOT NULL — Member sequence
  • Korean name (kr_nm) — VARCHAR(50) — NOT NULL — Korean Name
  • Gender (sex) — ENUM('F', 'M') — Sex
  • English passport (eng_lst_nm) — VARCHAR(50) — English Last Name
  • Passport English name (eng_frst_nm) — VARCHAR(50) — English First Name
  • Mobile Phone Number (mbl_no) — VARCHAR(20) — NOT NULL — Mobile Phone Number
  • Phone number (phn_no) — VARCHAR(20) — NOT NULL — Phone Number
  • E-mail (email) — VARCHAR(100) — Email
  • Adult or not (pax_typ) — VARCHAR(2) — Passenger Type - Adult:01, Child:02
  • Child age (chld_age) — VARCHAR(2) — Child Age : 1~16 years old
  • Date of birth (brth_dt) — DATE — Birth Date - YYYYMMDD
  • Passport (pssprt_yn) — enum('Y', 'N') — Passport exists or not

Interface master (tb_intrfc_mst)

  • Interface master ID (intrfc_mst_id) — BIGINT — Primary key — NOT NULL — Interface Master Id
  • Interface channel (intrfc_chnnl) — VARCHAR(18) — NOT NULL — Interface Master Channel OMH code
  • Interface channel code (intrfc_chnnl_cd) — VARCHAR(18) — channel using interface code, refer to tb_cmmn_cd_dtl table
  • Interface method (intrfc_srt) — VARCHAR(3) — NOT NULL — '101' - XML, '102'- JSON, '103' - MTF, '104'-DB, Refer to tb_cmmn_cd_dtl
  • Interface cycle (intrfc_cycl) — VARCHAR(2) — NOT NULL — '101' - Real time, '103'- Minutely, '104' - Hourly, '105'-Daily, '106'-Weekly, '107'- Monthly, '108'-Yearly, '109' - Et…
  • Other cycle description (etc_cycl_dsc) — VARCHAR(50) — When cycle code is '109', description the special cycle
  • Log deletion cycle (del_log_days) — INTEGER
  • Start date (strt_dt) — DATE — NOT NULL — interface start date
  • End date (end_dt) — DATE — NOT NULL — Interface End Date
  • Use or not (use_yn) — enum('Y', 'N')
  • Registrant (reg_id) — VARCHAR(18) — NOT NULL
  • Registration date and time (reg_dt) — DATETIME — NOT NULL
  • Modifier (chg_id) — VARCHAR(18) — NOT NULL
  • Date of change (chg_dt) — DATETIME — NOT NULL

Option information (tb_11st_rsrvtn_optn_log)

  • Interface serial number (intrfc_log_id2) — BIGINT — Foreign key → API Reservation Payment Completion.Interface serial number — NOT NULL
  • Option serial number (optn_seq) — Long — NOT NULL — Option Sequence
  • Option code (optn_cd) — VARCHAR(20) — NOT NULL — Option code
  • Option date (optn_date) — DATE — Option date
  • Option name (optn_nm) — VARCHAR(50) — Option Name
  • Option quantity (optn_qty) — INTEGER — Option Quantity
  • Option amount (optn_prc) — INTEGER — Option price with quantity

Reservation payment completion details (tb_11st_rsrvtn_dtl_log)

  • Interface serial number (intrfc_log_id) — BIGINT — Foreign key → API Reservation Payment Completion.Interface serial number — NOT NULL
  • Reservation serial number (rsrv_seq) — Long — NOT NULL — Reservation Sequence from 11st
  • Reservation status (rsrv_stts) — VARCHAR(3) — NOT NULL — Reservation status from 11st
  • Price (sel_prc) — INTEGER — NOT NULL — Sell Price
  • Payment deadline (stlmnt_trm) — VARCHAR(14) — settlement term - YYYYMMDDHH24MISS
  • Order detail number (ordr_prd_seq) — Long