테스트제목
테이블 (4)
PNR_COMMON_DATA
- PCD_ID — NUMBER — 기본 키 — NOT NULL — 시퀀스
- PCD_MASTER_YN — CHAR — MASTER
- PCD_TRL_HREV_CODE — CHAR — NOT NULL — H예약코드
- PCD_SS_CODE — VARCHAR2 — NOT NULL — 판매사이트코드
- PCD_HANA_SS_CODE — VARCHAR2 — 하나투어
- PCD_PKG_TYPE — CHAR — NOT NULL — 예약속성
- PCD_SVC_TYPE — CHAR — 서비스
- PCD_RV_IND — CHAR — NOT NULL — 인벤토리
- PCD_PASSAVE_IND — CHAR — 패시브
- PCD_DOM_IND — CHAR — 국내선
- PCD_INH_ID — VARCHAR2 — 공급
- PCD_INV_L_FARE_ID — NUMBER — 인벤토리
- PCD_REV_CRE_SRC — CHAR — NOT NULL — 예약생성방법
- PCD_FAREQQ_KEY — NUMBER — 요금문의로
- PCD_REV_FARE_TYPE — CHAR — NOT NULL — 사용운임종류(C:공통MSP
- PCD_BPGI_ID — NUMBER — 출장요청인경우
- PCD_BZ_KIND — CHAR — 출장타입
- PCD_INCENTIVE_L_FARE_ID — NUMBER — 인센티브예약일
- PCD_PATTERN_ID — VARCHAR2 — 패턴정보
- PCD_SKD_CHANGE_IND — CHAR — 스케줄변경
- PCD_CU_NATY — CHAR — 예약자
- PCD_CUS_TYPE — CHAR — NOT NULL — 예약고객구분
- PCD_NON_MBR — CHAR — 비회원예약인지여부
- PCD_CU_ID — VARCHAR2 — 예약자ID
- PCD_CU_LCL_NAME — VARCHAR2 — 예약자이름
- PCD_CU_LCL_ID — VARCHAR2 — 예약자
- PCD_CU_SEQ — VARCHAR2 — 예약자
- PCD_REV_CU_GRADE — VARCHAR2 — 예약자회원등급
- PCD_PHONE_HOME — VARCHAR2 — 예약자
- PCD_PHONE_OFFICE — VARCHAR2 — 예약자
- PCD_MOBILE — VARCHAR2 — 예약자
- PCD_EMAIL_CTC1 — VARCHAR2 — 예약자
- PCD_AUTH_IND — CHAR — AUTH
- PCD_AUTH_STATUS — CHAR — AUTH신청상태
- PCD_AUTH_REQ_DATE — DATE — AUTH
- PCD_AUTH_REQ_ID — VARCHAR2 — AUTH신청자
- PCD_AUTH_NO — VARCHAR2 — AUTH
- PCD_1ST_SEG_MK_CAR_FLT_NO — VARCHAR2
- PCD_CRS_PNR1_LOC — CHAR — CRS
- PCD_CRS_PNR1_ADDR — VARCHAR2 — CRS
- PCD_CRS_PNR2_LOC — CHAR — CRS
- PCD_CRS_PNR2_ADDR — VARCHAR2 — CRS
- PCD_CRS_PNR3_LOC — CHAR — CRS
- PCD_CRS_PNR3_ADDR — VARCHAR2 — CRS
- PCD_CRE_TIME — DATE — NOT NULL — 예약일시
- PCD_TRIP_TYPE — CHAR — 여정타입
- PCD_TKT_CAR — VARCHAR2 — Ticketing
- PCD_TKT_DEP — CHAR — Ticketing
- PCD_TKT_ARR — CHAR — Ticketing
- PCD_DEP_DATE — CHAR — 출발일
- PCD_RET_DATE — VARCHAR2 — 리턴일
- PCD_VALIDITY — VARCHAR2 — 항공권유효기간
- PCD_COMPARTMENT — CHAR — 좌석등급
- PCD_ITINERARY — VARCHAR2 — 여정요약
- PCD_TKTG_TYPE — VARCHAR2 — 공급사의
- PCD_CURRENCY_LCL — CHAR — NOT NULL — 로컬
- PCD_CURRENCY_ORG — CHAR — NOT NULL — 공급
- PCD_CURRENCY_RATE — NUMBER — NOT NULL — 예약
- PCD_TKT_TIME_LIMIT_DATE — CHAR — 고객결제시한(날짜)
- PCD_TKT_TIME_LIMIT_TIME — CHAR — 고객결제시한(시간)
- … +129
PNR_CRE_LOG
- PCL_ID — NUMBER — NOT NULL
- PCL_PSL_ID — NUMBER — NOT NULL
- PCL_QUERY — VARCHAR2
- PCL_PNR_ADDR — VARCHAR2
- PCL_RESPONSE — VARCHAR2
- PCL_LAST_DATE — DATE
PNR_FARE_DATA
- PFD_ID — NUMBER — NOT NULL — 시퀀스ID
- PFD_PND_ID — NUMBER — NOT NULL — PND
- PFD_PCD_ID — NUMBER
- PFD_H_CODE — VARCHAR2 — NOT NULL — H_CODE
- PFD_S_AGT_CODE — VARCHAR2 — 공급사
- PFD_L_AGT_CODE — VARCHAR2 — 판매사
- PFD_IDT_CODE — VARCHAR2 — NOT NULL — 운임조건
- PFD_REV_FARE_TYPE — CHAR — 사용운임종류(C:공통MSP
- PFD_AUTH_REQ_IND — CHAR — AUTH
- PFD_MANUAL_ADD_IND — CHAR — 관리자
- PFD_PUB_FARE — NUMBER — 성인
- PFD_MSP_FARE — NUMBER — 성인
- PFD_SALES_FARE — NUMBER — NOT NULL — 공급사
- PFD_FARE_APPLY_RATE — NUMBER — NOT NULL — SALES
- PFD_HIDDEN_SALES_FARE — NUMBER — 히든판매가
- PFD_COMM_STD — CHAR — NOT NULL — 원천
- PFD_COMM_RATE — NUMBER — 원천
- PFD_COMM_AMOUNT — NUMBER — 원천
- PFD_TAX — NUMBER — Tax
- PFD_Q — NUMBER — Q
- PFD_SL_COMM_STD — CHAR — NOT NULL — 공급사
- PFD_SL_COMM_RATE — NUMBER — 공급사
- PFD_SL_COMM_AMOUNT — NUMBER — 공급사
- PFD_SL_AMOUNT — NUMBER — 공급사
- PFD_SL_AMOUNT_NET — NUMBER — 공급사
- PFD_L_MKUP_STD — CHAR — NOT NULL — 판매사L1
- PFD_L_MKUP_RATE — NUMBER — 판매사L1
- PFD_L_MKUP_AMOUNT — NUMBER — 판매사L1
- PFD_LM_COMM_STD — CHAR — NOT NULL — 판매사L1
- PFD_LM_COMM_RATE — NUMBER — 판매사L1
- PFD_LM_COMM_AMOUNT — NUMBER — 판매사L1
- PFD_LM_DSC_STD — CHAR — NOT NULL — 판매사L1
- PFD_LM_DSC_RATE — NUMBER — 판매사L1
- PFD_LM_DSC_AMOUNT — NUMBER — 판매사L1
- PFD_LM_AMOUNT — NUMBER — 판매사
- PFD_LM_AMOUNT_NET — NUMBER — 판매사
- PFD_MC_MKUP_STD — CHAR — NOT NULL — 판매사L2
- PFD_MC_MKUP_RATE — NUMBER — 판매사L2
- PFD_MC_MKUP_AMOUNT — NUMBER — 판매사L2
- PFD_C_DSC_STD — CHAR — NOT NULL — 고객할인
- PFD_C_DSC_RATE — NUMBER — 고객할인율(%)
- PFD_C_DSC_AMOUNT — NUMBER — 고객할인금액
- PFD_PAY_AMOUNT — NUMBER — 결제대상금액
- PFD_PAY_AMOUNT_NET — NUMBER
- PFD_S_RSU_PANELTY — NUMBER — 원천공급사에
- PFD_CERTI_IND — CHAR — 증빙핑요유무
- PFD_CERTI_CHECK — CHAR — 증빙확인상태
- PFD_PUR_CONFIRM_TYPE — CHAR — 구매확정타입
- PFD_PUR_CONFIRM — CHAR — 구매확정상태
- PFD_PUR_CONFIRM_ID — VARCHAR2 — 구매확정상태변경자ID
- PFD_PUR_CONFIRM_NAME — VARCHAR2 — 구매확정상태변경자이름
- PFD_PUR_CONFIRM_DATE — DATE — 구매확정일
- PFD_ALL_CC_IND — CHAR
- PFD_TRL_ID — NUMBER — 발권요청마스터키
- PFD_REISSUE_IND — CHAR — 리이슈여부
- PFD_ORG_PFD_ID — NUMBER — 리이슈
- PFD_TKTG_STATUS — CHAR
- PFD_TKTG_STATUS_AGT_CODE — VARCHAR2 — 발권진행상태변경자
- PFD_TKTG_STATUS_ID — VARCHAR2 — 발권진행상태변경자ID
- PFD_TKTG_STATUS_NAME — VARCHAR2 — 발권진행상태변경자이름
- … +76
PNR_NAME_DATA
- PND_ID — NUMBER — 기본 키 — NOT NULL — 시퀀스
- PND_PCD_ID — NUMBER — NOT NULL — PCD
- PND_NAME_SEQ — NUMBER — NOT NULL — Name
- PND_REV_NAME_SEQ — NUMBER — NOT NULL — 순번
- PND_H_CODE — VARCHAR2 — NOT NULL — H_CODE
- PND_S_AGT_CODE — VARCHAR2 — 공급사
- PND_L_AGT_CODE — VARCHAR2 — 판매사
- PND_LCL_ID — VARCHAR2 — 주민번호
- PND_LCL_NAME — VARCHAR2 — 현지이름
- PND_LAST_NAME_EN — VARCHAR2 — NOT NULL — 영문성
- PND_FIRST_NAME_EN — VARCHAR2 — NOT NULL — 영문이름
- PND_TITLE — VARCHAR2 — TITLE
- PND_IDT_CODE — CHAR — 나이구분
- PND_BIRTH_DATE — VARCHAR2 — 생년월일
- PND_GENDER — CHAR — 성별:M/F
- PND_NATIONALITY_CODE — CHAR — 국적
- PND_ISSUE_NATIONALITY_CODE — CHAR — 여권발행국
- PND_PASSPORT_NO — VARCHAR2 — 여권번호
- PND_PASSPORT_EXPIR — CHAR — 여권만료일
- PND_WITH_PASS_IND — CHAR — 동반여권(소아
- PND_MOBILE — VARCHAR2 — 핸드폰
- PND_PHONE — VARCHAR2 — 연락처
- PND_EMAIL — VARCHAR2 — 이메일
- PND_SPCMEAL_TITLE — VARCHAR2 — 스페셜밀
- PND_SPCMEAL_TYPE — VARCHAR2 — 스페셜밀
- PND_SPCMEAL_DETAIL — VARCHAR2 — 스페셜밀
- PND_MILAGE_CRD_NUM1 — VARCHAR2 — 항공사
- PND_MILAGE_CRD_NUM2 — VARCHAR2 — 항공사
- PND_MILAGE_CRD_NUM3 — VARCHAR2 — 항공사
- PND_MILAGE_OP_CAR1 — CHAR — 마일리지
- PND_MILAGE_SAVE_CAR1 — CHAR — 마일리지
- PND_MILAGE_OP_CAR2 — CHAR — 마일리지
- PND_MILAGE_SAVE_CAR2 — CHAR — 마일리지
- PND_MILAGE_OP_CAR3 — CHAR — 마일리지
- PND_MILAGE_SAVE_CAR3 — CHAR — 마일리지
- PND_UPGRADE_MILAGE_NUM — VARCHAR2 — 업그레이드
- PND_UPGRADE_SEG — VARCHAR2 — 업그레이드
- PND_UPGRADE_DETAIL — VARCHAR2 — 업그레이드
- PND_CURRENT_NAT_CODE — CHAR — 현거주지
- PND_CURRENT_ADDRESS — VARCHAR2 — 현거주지
- PND_CURRENT_PHONE — VARCHAR2 — 현거주지연락처
- PND_ADDRESS_TO_STAY_CITY — VARCHAR2 — 체류
- PND_ADDRESS_TO_STAY_ZIP — VARCHAR2 — 체류지
- PND_ADDRESS_TO_STAY_STATE — VARCHAR2 — 체류
- PND_ADDRESS_TO_STAY — VARCHAR2
- PND_PHONE_TO_STAY — VARCHAR2 — 체류지
- PND_STAY_NATIONALITY_CODE — CHAR — 체류국가코드
- PND_DEP_CHECK_IND — CHAR — NOT NULL — 상용
- PND_DEP_CHECK_ID — VARCHAR2 — 상용
- PND_DEP_CHECK_DATE — DATE — 상용
- PND_RMI_ID — VARCHAR2 — 상용
- PND_TEAM_CODE — VARCHAR2 — 상용
- PND_TEAM_DESC — VARCHAR2 — 상용
- PND_RANK_CODE — VARCHAR2 — 상용
- PND_RANK_DESC — VARCHAR2 — 상용
- PND_REGULATION — CHAR — 규정위반여부
- PND_REGULATION_DESC — VARCHAR2 — 규정위반내용
- PND_CU_MAPPING_ID — VARCHAR2 — 하나투어
- PND_INPUT_DV — VARCHAR2 — INPUT
- PND_SR_NO — VARCHAR2 — 하나투어
- … +22