test
Tables (12)
TB_RMS_MBS_ACCT_SUBSCRT
- PRD_CODE — VARCHAR2(10) — Primary key — NOT NULL
- ACCOUNT_TYPE — VARCHAR2(3) — Primary key — NOT NULL
- SUBSCR_SEQ — VARCHAR2(20) — Foreign key → TB_RMS_MBS_SUBSCRT.SUBSCR_SEQ — NOT NULL
- TRANS_NUM — VARCHAR2(20) — Foreign key → Untitled.tid — NOT NULL
- SUBSCR_DTIME — CHAR(8)
- AMT — NUMBER(12,2)
- AMT_VAT — NUMBER(12,2)
- GUEST_AMT — NUMBER(12,2)
- CURR — CHAR(3)
- E_CARD_AMT — NUMBER(12,2)
- IF_DATE — CHAR(8)
- IF_FLAG — CHAR(1)
- CREATE_ID — VARCHAR2(15)
- CREATE_DATE — DATE
- UPDATE_ID — VARCHAR2(15)
- UPDATE_DATE — DATE
TB_RMS_MBS_ISSUE_ECARD
- ECARD_SEQ — VARCHAR2(20) — Primary key — NOT NULL — e카드
- SUBSCR_SEQ — VARCHAR2(20) — Foreign key → TB_RMS_MBS_SUBSCRT.SUBSCR_SEQ — NOT NULL — 구독
- CREATE_ID — VARCHAR2(15) — 생성자
- CREATE_DATE — DATE — 생성일
- UPDATE_ID — VARCHAR2(15) — 수정자
- UPDATE_DATE — DATE — 수정일
TB_RMS_MBS_SUBSCRT
- SUBSCR_SEQ — VARCHAR2(20) — Primary key — NOT NULL — 구독
- PRD_CODE — VARCHAR2(10) — 상품
- REGION_CODE — CHAR(2) — 구독
- SUBSCR_STATUS — CHAR(2) — 구독
- SUBSCR_START_DATE — CHAR(8) — 구독기간
- SUBSCR_END_DATE — CHAR(8) — 구독기간
- SUBSCR_EXTN_YN — CHAR(1) — 구독
- GUEST_BNF_YN — CHAR(1) — 동반인
- CURR — CHAR(3) — 화폐
- PRD_AMT — NUMBER(12,2) — 상품
- GUEST_AMT — NUMBER(12,2) — 동반인
- SUBSCR_AMT — NUMBER(12,2) — 구독
- PENALTY — NUMBER(12,2) — 위약금
- SYSTEM_USAGE_FEE — NUMBER(12,2) — 시스템
- DAILY_FEE — NUMBER(12,2) — 월사용료
- E_CARD_AMT — NUMBER(12,2) — e카드
- SUBSCR_DTIME — DATE — 구독
- CREATE_ID — VARCHAR2(15) — 생성자
- CREATE_DATE — DATE — 생성일
- UPDATE_ID — VARCHAR2(15) — 수정자
- UPDATE_DATE — DATE — 수정일
TB_RMS_MBS_SUBSCRT_CANCEL
- SUBSCR_SEQ — VARCHAR2(20) — Foreign key → TB_RMS_MBS_SUBSCRT.SUBSCR_SEQ — NOT NULL — 구독
- CXL_REQ_DTIME — DATE — 구독
- CXL_REASON_CODE — VARCHAR2(10) — 구독
- CXL_REASON_DETAIL — VARCHAR2(200) — 구독
- USAGE_DAYS — INTEGER — 이용
- CURR — CHAR(3) — 화폐
- PENALTY — NUMBER(12,2) — 위약금
- SYSTEM_USAGE_FEE — NUMBER(12,2) — 시스템
- DAILY_FEE — NUMBER(12,2) — 일사용료
- USAGE_FEE — NUMBER(12,2) — 이용
- REFUND_EST_AMT — NUMBER(12,2) — 환불
- REFUND_AMT — NUMBER(12,2) — 환불
- AUTO_REFUND_AVAIL_YN — CHAR(1) — 자동
- REFUND_AMT_MODIFY_REASON — VARCHAR2(200) — 환불
- CXL_DTIME — DATE — 구독
- CREATE_ID — VARCHAR2(15) — 생성자
- CREATE_DATE — DATE — 생성일
- UPDATE_ID — VARCHAR2(15) — 수정자
- UPDATE_DATE — DATE — 수정일
TB_RMS_MBS_SUBSCRT_PAYMENT
- PAYMENT_SEQ — INTEGER — Primary key — NOT NULL — 결제
- SUBSCR_SEQ — VARCHAR2(20) — NOT NULL — 구독
- TRANS_DIV — CHAR(2) — 결제
- PAYMENT_CODE — CHAR(4) — 결제
- TRANS_NUM — VARCHAR2(20) — 거래
- CURR — CHAR(3) — 화폐
- TRANS_AMT — NUMBER(12,2) — 거래
- TRANS_DTIME — DATE — 거래
- CREATE_ID — VARCHAR2(15) — 생성자
- CREATE_DATE — DATE — 생성일
- UPDATE_ID — VARCHAR2(15) — 수정자
- UPDATE_DATE — DATE — 수정일
TB_RMS_TEC_ECARD_ISSUE
- ECARD_SEQ — VARCHAR2(20) — Primary key — NOT NULL — e카드
- ECARD_DIV — CHAR(3) — e카드
- GC_TYPE — VARCHAR2(8) — GC
- ECARD_STATUS — CHAR(2) — e카드
- ROUTE_DIV — CHAR(1) — 적용
- CURR — CHAR(3) — 화폐
- ISSUE_AMT — NUMBER(12,2) — 발행
- ECARD_USE_LIMIT_YN — CHAR(1) — 1회
- ECARD_USE_LIMIT_AMT — NUMBER(12,2) — 1회
- EXP_DATE — CHAR(8) — 만료
- USE_YN — CHAR(1) — 사용
- CREATE_ID — VARCHAR2(15) — 생성자
- CREATE_DATE — DATE — 생성일
- UPDATE_ID — VARCHAR2(15) — 수정자
- UPDATE_DATE — DATE — 수정일
Untitled
- tid — VARCHAR2(20) — Primary key — NOT NULL
- tran_type — VARCHAR2(2)
- amt — NUMBER(12,2)
tb_rms_tp_acc_subscription
- product_cd — VARCHAR2(10) — Foreign key → TB_RMS_MBS_ACCT_SUBSCRT.PRD_CODE — NOT NULL
- account_type — VARCHAR2(3) — Foreign key → TB_RMS_MBS_ACCT_SUBSCRT.ACCOUNT_TYPE — NOT NULL
- subscription_number — VARCHAR2(20) — Foreign key → TB_RMS_MBS_ACCT_SUBSCRT.SUBSCR_SEQ — NOT NULL
- tid — VARCHAR2(20) — Foreign key → TB_RMS_MBS_ACCT_SUBSCRT.TRANS_NUM — NOT NULL
- status — CHAR(2)
- belnr — VARCHAR2(10)
- message — VARCHAR(255)
- amt — NUMBER(12,2)
- currency — CHAR(3)
- create_id — VARCHAR2(15)
- create_date — DATE
- update_id — VARCHAR2(15)
- Field4 — DATE
tb_rms_tp_cancel_subscription
- product_cd — VARCHAR2(10)
- cancel_date — CHAR(8)
- amt — NUMBER(12,2)
- currency — CHAR(3)
- Field5 — NUMBER(12,2)
- Field — NUMBER(12,2)
- Field2 — NUMBER(12,2)
- Field6 — NUMBER(12,2)
- Field7 — NUMBER(12,2)
- create_id — VARCHAR2(15)
- create_date — DATE
- update_id — VARCHAR2(15)
- update_date — DATE
tb_rms_tp_ecard_details
- ticket_number — VARCHAR2(13) — Primary key — NOT NULL
- ecard_number — VARCHAR2(20) — NOT NULL
- trasaction_date — CHAR(8)
- gc_type — VARCHAR2(8)
- status — CHAR(2)
- expired_date — CHAR(8)
- tran_type — VARCHAR2(2)
- amt — NUMBER(12,2)
- currency — CHAR(3)
- pnr — VARCHAR2(13)
- create_id — VARCHAR2(15)
- create_date — DATE
- update_id — VARCHAR2(15)
- update_date — DATE
- Field — VARCHAR(255)
- old_ticket — VARCHAR(255)
tb_rms_tp_ecard_summary
- report_date — CHAR(8) — Primary key — NOT NULL
- seq — INTEGER — Primary key — NOT NULL
- ecard_number — VARCHAR2(20) — Foreign key → TB_RMS_TEC_ECARD_ISSUE.ECARD_SEQ — NOT NULL
- gc_type — VARCHAR2(8)
- balance_amt — NUMBER(12,2)
- issue_amt — NUMBER(12,2)
- use_amt — NUMBER(12,2)
- refund_amt — NUMBER(12,2)
- currency — CHAR(3)
- create_id — VARCHAR2(15)
- create_date — DATE
- update_id — VARCHAR2(15)
- update_date — DATE
tb_rms_tp_expired_subscription
- product_cd — VARCHAR2(20)