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