RCPT
Tables (21)
TB_MSGSEND
- SEQNO — NUMBER — Primary key — NOT NULL
- INTIME — VARCHAR2(21) — NOT NULL
- USERCODE — VARCHAR2(45) — NOT NULL
- DEPTCODE — VARCHAR2(45)
- BIZTYPE — VARCHAR2(3)
- YELLOWID_KEY — VARCHAR2(60)
- REQNAME — VARCHAR2(48)
- REQPHONE — VARCHAR2(30) — NOT NULL
- CALLNAME — VARCHAR2(75)
- COUNTRY — VARCHAR2(15)
- CALLPHONE — VARCHAR2(30) — NOT NULL
- SUBJECT — VARCHAR2(180)
- MSG — VARCHAR2(6000) — NOT NULL
- REQTIME — VARCHAR2(21) — NOT NULL
- SENTTIME — VARCHAR2(21)
- RECVTIME — VARCHAR2(21)
- RESULT — VARCHAR2(2) — NOT NULL
- ERRCODE — NUMBER(22)
- KIND — VARCHAR2(2) — NOT NULL
- FKCONTENT — NUMBER(22)
- IMAGE_URL — VARCHAR2(1500)
- BATCHFLAG — NUMBER(22) — NOT NULL
- RETRY — NUMBER(22) — NOT NULL
- RESEND — VARCHAR2(2)
- BUTTON_NAME — VARCHAR2(1500)
- BUTTON_URL — VARCHAR2(1500)
- TEMPLATECODE — VARCHAR2(60)
- RETEXT — VARCHAR2(3000)
- RESENTFLAG — VARCHAR2(2)
- SENTMEDIA — VARCHAR2(2)
- MEDIATYPE — VARCHAR2(2)
- BOOKTIME — VARCHAR2(21) — NOT NULL
- RESIDENT_DATE — VARCHAR2(9) — NOT NULL
- URL — VARCHAR2(120)
- JOB_TYPE — VARCHAR2(3)
- ENTRY_PLACE — VARCHAR2(3)
- ENTRY_DATE — VARCHAR2(12) — NOT NULL
- ENTRY_TIME — VARCHAR2(9) — NOT NULL
- ENTRY_NAME — VARCHAR2(30) — NOT NULL
- ERRCODE_ULS — VARCHAR2(15)
TL_DL_AM_RFND_INFO_LOG
- RFND_SN — NUMBER — Primary key — NOT NULL
- RFND_SE — CHAR(1)
- APYEXM_YMD — VARCHAR2(8)
- APYEXM_SBJT_CD — VARCHAR2(1)
- APYEXM_ASRT — VARCHAR2(2)
- RDRG_SN — NUMBER(10)
- CHG_PRCS_LCEXCT_CD — VARCHAR2(2)
- RFND_BANK_CD — VARCHAR2(2)
- RFND_BANO — VARCHAR2(44)
- AMT — NUMBER
- DMND_YMD — CHAR(8)
- DMND_NM — VARCHAR2(10)
- RSLT_CD — VARCHAR2(1)
- RSLT_RSN — VARCHAR2(150)
- NEW_RFND_BANK_CD — VARCHAR2(2)
- NEW_RFND_BANO — VARCHAR2(44)
- NEW_AMT — NUMBER
- NEW_DMND_YMD — CHAR(8)
- NEW_DMND_NM — VARCHAR2(10)
- NEW_RSLT_CD — VARCHAR2(1)
- NEW_RSLT_RSN — VARCHAR2(150)
- RCPT_LCEXCT_CD — VARCHAR2(2)
- RCPT_YR — VARCHAR2(4)
- RCPT_SN — NUMBER(7)
- PRCS_LCEXCT_CD — VARCHAR2(2)
- RCPT_YMD — CHAR(8)
- RCPT_HMS — CHAR(6)
- APYEXM_LCEXCT_CD — VARCHAR2(2)
- ORDR_NO — VARCHAR2(30)
- RFND_PRCS_PIC_NM — VARCHAR2(30)
- RFND_PRCS_YMD — VARCHAR2(8)
- RFND_PRCS_HMS — VARCHAR2(6)
- DMND_TYPE — CHAR(1)
- REG_LCEXCT_CD — VARCHAR2(2)
- FILE_NO — NUMBER(22)
- MDFCN_LCEXCT_CD — VARCHAR2(2)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TL_DL_LM_LCNS_NEW_HSTRY
- LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- LCNS_NO — CHAR(24) — Primary key — NOT NULL
- LCNS_ASRT_CD — VARCHAR2(2) — Primary key — NOT NULL
- CRT_YMD — CHAR(8) — Primary key — NOT NULL
- CRT_TM — CHAR(6) — Primary key — NOT NULL
- REISSU_NO — CHAR(1)
- LCNS_CND_CD — VARCHAR2(2)
- RDRG_SN — NUMBER(10)
- RDRG_ADDR — VARCHAR2(300)
- NTNLTY_CD — VARCHAR2(6)
- ADDR_PLC_POLSTA_CD — VARCHAR2(4)
- PASS_YMD — CHAR(8)
- VLD_YMD — CHAR(8)
- APLY_CN_CD — VARCHAR2(2)
- FRNTN_ADMC_CD — VARCHAR2(6)
- DTBN_RGN_CD — VARCHAR2(2)
- DTBN_NO — NUMBER
- DTBN_YMD — CHAR(8)
- DAT_SE_CD — VARCHAR2(2)
- INSTUT_CD — VARCHAR2(5)
- INSTUT_MTCLTN_YMD — CHAR(8)
- INSTUT_FNSH_YMD — CHAR(8)
- INSTUT_GRDTN_YMD — CHAR(8)
- WACD_7_YR_TRGT_YN — CHAR(1)
- BWNTD_TRPR_YN — CHAR(1)
- DISQ_TRPR_YN — CHAR(1)
- PASS_TAKEX_NO — NUMBER(6)
- NEW_APFRM_RCPT_NO — NUMBER
- LCCRT_OTPT_YN — CHAR(1)
- ENG_LCCRT_OTPT_SE_CD — VARCHAR2(1)
- TASK_DESK_SE_CD — VARCHAR2(2)
- APYEXM_RCPT_NO — VARCHAR2(11)
- ASIMNG_RCPT_YN — CHAR(1)
- SN — NUMBER
- AGT_NM — VARCHAR2(75)
- CTDY_LCEXCT_CD — VARCHAR2(2)
- APTS_BGNG_YMD — CHAR(8)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TL_SD_DT_ONLINE_LCNS_TEST_RCPT_LOG
- SEQ — NUMBER — Primary key — NOT NULL
- RCPT_LCEXCT_CD — VARCHAR2(2) — NOT NULL
- RCPT_YR — VARCHAR2(4) — NOT NULL
- RCPT_SN — NUMBER(7) — NOT NULL
- APLY_YMD — VARCHAR2(8)
- APLY_TM — VARCHAR2(6)
- PRCS_LCEXCT_CD — VARCHAR2(2)
- APYEXM_TRGT — VARCHAR2(1)
- APYEXM_ASRT — VARCHAR2(2)
- APYEXM_YMD — VARCHAR2(8)
- APYEXM_PERD — NUMBER(2)
- TAKEX_NO — NUMBER(5)
- ENG_HMPG_RCPT_YN — CHAR(1)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TM_DL_AM_APYEXM_MASTR
- RCPT_LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- RCPT_YR — VARCHAR2(4) — Primary key — NOT NULL
- RCPT_SN — NUMBER(7) — Primary key — NOT NULL
- RDRG_SN — NUMBER(10)
- NTNLTY_SE_CD — VARCHAR2(6)
- ADDR_PLC_LCEXCT_CD — VARCHAR2(3)
- FRST_RCPT_YMD — CHAR(8)
- APYEXM_ASRT — VARCHAR2(2)
- LCNS_CND_CD — VARCHAR2(2)
- APLY_CN_CD — VARCHAR2(2)
- EXMPTN_SBJT_CD — VARCHAR2(2)
- TELGM_INSTUT_CD — VARCHAR2(7)
- INSTUT_MTCLTN_YMD — CHAR(8)
- INSTUT_FNSH_YMD — CHAR(8)
- INSTUT_GRDTN_YMD — CHAR(8)
- DGRD_SE_CD — VARCHAR2(1)
- OLD_APYEXM_ASRT — VARCHAR2(2)
- OLD_LCNS_CND_CD — VARCHAR2(2)
- CBT_CND_CD — VARCHAR2(2)
- APYEXM_SBJT_CD — VARCHAR2(1)
- PDLN — CHAR(24)
- LCNS_NO — CHAR(24)
- REISSU_CNT — NUMBER(2)
- VLD_YMD — CHAR(8)
- TP1L_PSN_YN_CD — VARCHAR2(1) — NOT NULL
- TP1N_PSN_YN_CD — VARCHAR2(1) — NOT NULL
- TP1S_PSN_YN_CD — VARCHAR2(1) — NOT NULL
- TP1LTW_PSN_YN_CD — VARCHAR2(1) — NOT NULL
- TP1RC_PSN_YN_CD — VARCHAR2(1) — NOT NULL
- TP1STW_PSN_YN_CD — VARCHAR2(1) — NOT NULL
- TP2N_PSN_YN_CD — VARCHAR2(1) — NOT NULL
- TP2S_PSN_YN_CD — VARCHAR2(1) — NOT NULL
- TP2_SCL_PSN_YN_CD — VARCHAR2(1) — NOT NULL
- TP2MB_PSN_YN_CD — VARCHAR2(1) — NOT NULL
- DISQ_IDNTY_YN_CD — VARCHAR2(1)
- DISQ_CD — VARCHAR2(3)
- DISQ_BGNG_YMD — CHAR(8)
- DISQ_END_YMD — CHAR(8)
- APYEXM_STTS_CD — VARCHAR2(1)
- APYEXM_STTS_YMD — CHAR(8)
- APYEXM_VLD_YMD — CHAR(8)
- PHEX_YMD — CHAR(8)
- DSBLTY_MSRMT_TRGT_YN_CD — VARCHAR2(1)
- DSBLTY_MSRMT_CD — VARCHAR2(1)
- TELNO — VARCHAR2(22)
- EML — VARCHAR2(100)
- LAST_QLFC_CD — VARCHAR2(1)
- TBDY_ABV_YN_CD — VARCHAR2(1)
- HEARAB_CD — VARCHAR2(1)
- VSPR_BOAN_CD — VARCHAR2(1)
- VSPR_LEFT_CD — VARCHAR2(1)
- VSPR_RGHT_CD — VARCHAR2(1)
- DS_HSTRY_YN_CD — VARCHAR2(1)
- FRST_RCPT_YN_CD — VARCHAR2(1)
- HRZTY_SIHT_STBLT_YN_CD — VARCHAR2(1)
- VRTC_SIHT_STBLT_YN_CD — VARCHAR2(1)
- SCTM_HMNS_YN_CD — VARCHAR2(1)
- OEYD_DSBLTY_YN — VARCHAR2(1)
- STAY_BGNG_YMD — CHAR(8)
- STAY_END_YMD — CHAR(8)
- … +12
TM_DL_AM_RFND_INFO
- RFND_SE — CHAR(1) — Primary key — NOT NULL
- APYEXM_YMD — VARCHAR2(8) — Primary key — NOT NULL
- APYEXM_SBJT_CD — VARCHAR2(1) — Primary key — NOT NULL
- APYEXM_ASRT — VARCHAR2(2) — Primary key — NOT NULL
- CRT_LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- CRT_YMD — CHAR(8) — Primary key — NOT NULL
- CRT_HMS — CHAR(6) — Primary key — NOT NULL
- RDRG_SN — NUMBER(10) — Primary key — NOT NULL
- RFND_BANK_CD — VARCHAR2(2)
- RFND_BANO — VARCHAR2(44)
- DMND_YMD — CHAR(8)
- DMND_NM — VARCHAR2(10)
- AMT — NUMBER
- RSLT_CD — VARCHAR2(1)
- RSLT_RSN — VARCHAR2(150)
- RCPT_LCEXCT_CD — VARCHAR2(2)
- RCPT_YR — VARCHAR2(4)
- RCPT_SN — NUMBER(7)
- PRCS_LCEXCT_CD — VARCHAR2(2)
- RCPT_YMD — CHAR(8)
- RCPT_HMS — CHAR(6)
- APYEXM_LCEXCT_CD — VARCHAR2(2)
- ORDR_NO — VARCHAR2(30)
- RFND_PRCS_PIC_NM — VARCHAR2(30)
- RFND_PRCS_YMD — VARCHAR2(8)
- RFND_PRCS_HMS — VARCHAR2(6)
- FILE_NO — NUMBER(22)
- REG_LCEXCT_CD — VARCHAR2(2)
- MDFCN_LCEXCT_CD — VARCHAR2(2)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TR_DL_CM_CM_CD
- CD_SE — VARCHAR2(6) — Primary key — NOT NULL
- CD — VARCHAR2(10) — Primary key — NOT NULL
- CD_NM — VARCHAR2(150)
- DTL_CD — VARCHAR2(6)
- DTL_CD_NM — VARCHAR2(90)
- USE_YN — CHAR(1)
- REG_LCEXCT_CD — VARCHAR2(2)
- MDFCN_LCEXCT_CD — VARCHAR2(2)
- COL_SORD — VARCHAR2(4)
- ONLINE_YN — CHAR(1)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TR_DL_LM_STATS_FEE
- TASK_CD — VARCHAR2(5) — Primary key — NOT NULL
- LCNS_ASRT_CD — VARCHAR2(2) — Primary key — NOT NULL
- PRC_CD — VARCHAR2(2) — Primary key — NOT NULL
- FEE — NUMBER
- BGNG_YMD — CHAR(8)
- END_YMD — CHAR(8)
- TASK_NM — VARCHAR2(75)
- USE_YN — CHAR(1)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TR_SD_CF_CM_CD
- CM_CD_SN — NUMBER(22) — Primary key — NOT NULL
- CM_CD — VARCHAR2(20) — NOT NULL
- CM_CD_NM — VARCHAR2(150) — NOT NULL
- LEVL — NUMBER(22) — NOT NULL
- UPR_CM_CD — VARCHAR2(20) — NOT NULL
- USE_STTS_CD — VARCHAR2(20) — NOT NULL
- SORD — NUMBER
- CD_EXPLN — VARCHAR2(1500)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TT_DL_AM_APYEXM_DTL
- RCPT_LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- RCPT_YR — VARCHAR2(4) — Primary key — NOT NULL
- RCPT_SN — NUMBER(7) — Primary key — NOT NULL
- PRCS_LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- RCPT_YMD — CHAR(8) — Primary key — NOT NULL
- RCPT_HMS — CHAR(6) — Primary key — NOT NULL
- APYEXM_SBJT_CD — VARCHAR2(1) — NOT NULL
- RCPT_KND_CD — VARCHAR2(2)
- PDLN — CHAR(24)
- APYEXM_ASRT — VARCHAR2(2)
- LCNS_CND_CD — VARCHAR2(2)
- APYEXM_LCEXCT_CD — VARCHAR2(2)
- BP_LCEXCT_CD — VARCHAR2(2)
- LANG_CD — VARCHAR2(2)
- APYEXM_YMD — VARCHAR2(8)
- APYEXM_PERD — NUMBER(2)
- APYEXM_PERD_BGNG_TM — CHAR(4)
- TAKEX_NO — NUMBER(5)
- JGMT_CD — VARCHAR2(1)
- SCR — NUMBER(4)
- APYEXM_STTS_CD — VARCHAR2(1)
- TSFL_RSN_CD — VARCHAR2(3)
- INTNET_RCPT_YN_CD — VARCHAR2(1)
- DISQ_IDNTY_YN_CD — VARCHAR2(1)
- DISQ_CD — VARCHAR2(3)
- DISQ_BGNG_YMD — CHAR(8)
- DISQ_END_YMD — CHAR(8)
- SCRE_TRSM_CD — VARCHAR2(1)
- POLSTA_CD — VARCHAR2(4)
- BWNTD_IDNTY_YN_CD — VARCHAR2(1)
- CHGHY_CN — VARCHAR2(4000)
- MAT_CD — VARCHAR2(4)
- APYEXM_APFRM_OTPT_YN_CD — VARCHAR2(1)
- ORDR_NO — VARCHAR2(30)
- BRCD — VARCHAR2(45)
- VRYD_RFND_PSBLTY_YN — CHAR(1)
- RSLT_REG_YMD — CHAR(8)
- RSLT_REG_PIC_ID — VARCHAR2(30)
- RSLT_REG_PIC_NM — VARCHAR2(30)
- REG_LCEXCT_CD — VARCHAR2(2)
- MDFCN_LCEXCT_CD — VARCHAR2(2)
- MVMN_YN — CHAR(1)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TT_DL_AM_APYEXM_SCHDL
- LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- BP_LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- APYEXM_SBJT_CD — VARCHAR2(1) — Primary key — NOT NULL
- APYEXM_ASRT — VARCHAR2(2) — Primary key — NOT NULL
- LCNS_CND_CD — VARCHAR2(2) — Primary key — NOT NULL
- APYEXM_YMD — VARCHAR2(8) — Primary key — NOT NULL
- APYEXM_PERD — NUMBER(2) — Primary key — NOT NULL
- APYEXM_BGNG_TM — CHAR(4)
- REG_PRNU_CNT — NUMBER(6)
- BGNG_TAKEX_NO — NUMBER(5)
- APYEXM_PSBLTY_PRNU_CNT — NUMBER(6)
- RCPT_PSBLTY_SEAT_INFO — VARCHAR2(2000)
- TMPR_RCPT_CMPTN_SEAT_INFO — VARCHAR2(2000)
- ONLINE_SCHDL_YN_CD — VARCHAR2(1)
- RCPT_CMPTN_SEAT_INFO — VARCHAR2(2000)
- APYEXM_END_TM — CHAR(4)
- DSBSTR_CD — NUMBER
- REG_LCEXCT_CD — VARCHAR2(2)
- MDFCN_LCEXCT_CD — VARCHAR2(2)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TT_DL_AM_CRCD_USE_DSCTN
- APRV_NO — VARCHAR2(20) — Primary key — NOT NULL
- LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- APRV_YMD — CHAR(8) — Primary key — NOT NULL
- APRV_HMS — CHAR(6) — Primary key — NOT NULL
- RDRG_SN — NUMBER(10) — Primary key — NOT NULL
- DLNG_ID — VARCHAR2(50)
- APRV_SE — CHAR(1) — NOT NULL
- PRCHS_CLM_SE_CD — CHAR(1) — NOT NULL
- APRV_MTHD_CD — VARCHAR2(1)
- BNDUNT_SE — VARCHAR2(50)
- CARD_EXDT_YM — VARCHAR2(4)
- MINP_MM_CNT — NUMBER
- INPT_SE — CHAR(1)
- NTSL_AMT — NUMBER
- SVCHRG_AMT — NUMBER
- RTRCN_YMD — CHAR(8)
- RTRCN_HMS — CHAR(6)
- TELGM_SN — CHAR(9)
- RTRCN_TELGM_SN — CHAR(9)
- SNDBK_YMD — CHAR(8)
- RSPNS_CD — VARCHAR2(2)
- PRCHS_CLM_YMD — CHAR(8)
- PRCHS_CLM_HMS — CHAR(6)
- DPST_PRNMNT_YMD — CHAR(8)
- DPST_CFMTN_YMD — CHAR(8)
- CARD_ISCMP_CD — VARCHAR2(4)
- PRCHS_CMP_CD — VARCHAR2(4)
- CARD_ISCMP_NM — VARCHAR2(60)
- FRCS_NO — CHAR(15)
- TRMNL_NO — CHAR(10)
- DDLN_YN_CD — VARCHAR2(1)
- SNDBK_SE — CHAR(2)
- SNDBK_RSN_CD — VARCHAR2(4)
- STD_SNDBK_RSN_CD — VARCHAR2(2)
- CARD_INFO — VARCHAR2(75)
- TELGM_CN — VARCHAR2(1000)
- CNVNC_STLM_CMP_CD — VARCHAR2(2)
- CBT_YN_CD — VARCHAR2(1)
- CBT_CNT — NUMBER
- TP1N_TP2N_FNC_YN_CD — VARCHAR2(1)
- TP1N_TP2N_FNC_CNT — NUMBER
- TP1L_FNC_YN_CD — VARCHAR2(1)
- TP1L_FNC_CNT — NUMBER
- PRCT_DRLI_YN_CD — VARCHAR2(1)
- PRCT_DRLI_CNT — NUMBER
- ROAD_DVRN_YN_CD — VARCHAR2(1)
- ROAD_DVRN_CNT — NUMBER(5)
- LCNS_ISSU_YN_CD — VARCHAR2(1)
- LCNS_ISSU_CNT — NUMBER
- PRMMVR_CBT_YN_CD — VARCHAR2(1)
- PRMMVR_CBT_CNT — NUMBER
- PRMMVR_FNC_YN_CD — VARCHAR2(1)
- PRMMVR_FNC_CNT — NUMBER
- APTS_REISSU_TP1N_YN_CD — VARCHAR2(1)
- APTS_REISSU_TP1N_CNT — NUMBER
- APTS_REISSU_TP2N_YN_CD — VARCHAR2(1)
- APTS_REISSU_TP2N_CNT — NUMBER
- APTS_PTMT_YN_CD — VARCHAR2(1)
- APTS_PTMT_CNT — NUMBER
- LOS_REISSU_YN_CD — VARCHAR2(1)
- … +21
TT_DL_AM_IDCRD_UCFM_APYEXM
- KY_CD — VARCHAR2(24) — Primary key — NOT NULL
- APYEXM_LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- APYEXM_YMD — VARCHAR2(8) — Primary key — NOT NULL
- APYEXM_SBJT_CD — VARCHAR2(1) — Primary key — NOT NULL
- APYEXM_ASRT — VARCHAR2(2) — Primary key — NOT NULL
- BP_LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- APYEXM_PERD — NUMBER(2) — Primary key — NOT NULL
- TAKEX_NO — NUMBER(5) — Primary key — NOT NULL
- REG_YMD — CHAR(8) — Primary key — NOT NULL
- REG_HMS — CHAR(6) — Primary key — NOT NULL
- RDRG_SN — NUMBER(10)
- DEL_YN — CHAR(1) — NOT NULL
- REG_LCEXCT_CD — VARCHAR2(2)
- MDFCN_LCEXCT_CD — VARCHAR2(2)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TT_DL_AM_ONLINE_RCT_COET
- APYEXM_SE — CHAR(1) — Primary key — NOT NULL
- RCPT_LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- APYEXM_YMD — VARCHAR2(8) — Primary key — NOT NULL
- APYEXM_RCPT_NO — VARCHAR2(11) — Primary key — NOT NULL
- RCPT_SE_CD — VARCHAR2(2) — Primary key — NOT NULL
- RCPT_ASRT_CD — VARCHAR2(2) — Primary key — NOT NULL
- APYEXM_PERD — NUMBER(2) — Primary key — NOT NULL
- TAKEX_NO — NUMBER(5) — Primary key — NOT NULL
- RCPT_YMD — CHAR(8)
- RDRG_SN — NUMBER(10)
- BGNG_TM — CHAR(4)
- FEE_AMT — NUMBER
- TELNO — VARCHAR2(20)
- CLPHN_1_NO — VARCHAR2(3)
- CLPHN_2_NO — VARCHAR2(4)
- CLPHN_3_NO — VARCHAR2(4)
- DTBN_YN_CD — VARCHAR2(1)
- ETC_RSN — VARCHAR2(75)
- JGMT_RSLT_CD — VARCHAR2(1)
- BP_LCEXCT_CD — VARCHAR2(2)
- RCPT_KND_CD — VARCHAR2(2)
- ORDR_NO — VARCHAR2(30)
- REG_LCEXCT_CD — VARCHAR2(2)
- MDFCN_LCEXCT_CD — VARCHAR2(2)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TT_DL_API_ENCPT_KY_VER
- ENCPT_KY_VER — VARCHAR2(10) — Primary key — NOT NULL
- ENCPT_KY — VARCHAR2(500)
- USE_YN — VARCHAR2(1)
- REG_DT — DATE
- REG_ID — VARCHAR2(50)
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(30)
TT_DL_API_INST_CD
- INST_CD — VARCHAR2(10) — Primary key — NOT NULL
- INST_NM — VARCHAR2(300)
- INST_INFO_SE — VARCHAR2(1) — NOT NULL
- USE_YN — VARCHAR2(1) — NOT NULL
- REG_DT — DATE
- REG_ID — VARCHAR2(50)
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(30)
TT_DL_API_TRNSC_ID
- SN — NUMBER — Primary key — NOT NULL
- TRNSC_ID — VARCHAR2(28)
- DMND_INST_CD — VARCHAR2(10)
- APTS_TYPE — VARCHAR2(1) — NOT NULL
- RDRG_BRTYMD — VARCHAR2(6)
- RDRG_IDNTF_NO — VARCHAR2(7)
- RDRG_NM — VARCHAR2(50)
- RDRG_SN — NUMBER(10) — NOT NULL
- TMPR_PHOTO_PATH — VARCHAR2(40) — NOT NULL
- REG_DT — DATE
- REG_ID — VARCHAR2(50)
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(30)
TT_DL_CM_CVLPR_CTPL
- RDRG_SN — NUMBER(10) — Primary key — NOT NULL
- FAH_TELNO — VARCHAR2(24)
- MDDL_TELNO — VARCHAR2(24)
- RR_TELNO — VARCHAR2(24)
- RCPTN_AGRE_YN — CHAR(1)
- CPNO_INPT_PLC — VARCHAR2(4)
- CPNO_INPT_YMD — CHAR(8)
- CPNO_INPT_HMS — CHAR(6)
- CPNO_INPT_OPRTR_NM — VARCHAR2(75)
- CPNO_MDFCN_PLC — VARCHAR2(4)
- CPNO_MDFYMD — CHAR(8)
- CPNO_MDFCN_HMS — CHAR(6)
- CPNO_MDFR — VARCHAR2(30)
- EML_ADDR — VARCHAR2(300)
- EML_DMIN_NM — VARCHAR2(30)
- EML_RCPTN_AGRE_YN — CHAR(1)
- EML_INPT_PLC — VARCHAR2(4)
- EML_INPT_YMD — CHAR(8)
- EML_INPT_HMS — CHAR(6)
- EML_INPT_OPRTR_NM — VARCHAR2(30)
- EML_MDFCN_PLC — VARCHAR2(4)
- EML_MDFYMD — CHAR(8)
- EML_MDFCN_HMS — CHAR(6)
- EML_MDFR — VARCHAR2(75)
- TASK_SE — VARCHAR2(2)
- DEL_YN — CHAR(1)
- DEL_PLC — CHAR(4)
- DEL_YMD — CHAR(8)
- DEL_HMS — CHAR(6)
- DEL_OPRTR_NM — VARCHAR2(30)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TT_DL_CM_LCEXCT_ASRT_RCPT
- LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- LCNS_ASRT_CD — VARCHAR2(2) — Primary key — NOT NULL
- APYEXM_SE_CD — VARCHAR2(1) — Primary key — NOT NULL
- APYEXM_PSBLTY_YN — CHAR(1)
- REG_LCEXCT_CD — VARCHAR2(2)
- MDFCN_LCEXCT_CD — VARCHAR2(2)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TT_DL_CM_LCEXCT_CM
- LCEXCT_CD — VARCHAR2(2) — Primary key — NOT NULL
- LCEXCT_NM — VARCHAR2(45)
- CTPV_CD — VARCHAR2(2)
- PSAML_1_NO — VARCHAR2(3)
- PSAML_2_NO — VARCHAR2(3)
- LCEXCT_ADDR — VARCHAR2(300)
- TELNO — VARCHAR2(20)
- FAX_NO — VARCHAR2(15)
- HMPG_ADDR — VARCHAR2(30)
- PLCH_NM — VARCHAR2(30)
- SCSBJT_APYEXM_MIN_PSBLTY_DCNT — NUMBER(2)
- FNC_TEST_MIN_PSBLTY_DCNT — NUMBER(2)
- ROAD_DVRN_MIN_PSBLTY_DCNT — NUMBER(2)
- LCEXCT_ID — VARCHAR2(30)
- LCEXCT_PSWD — VARCHAR2(88)
- FTINS_EXMPTN_TM — CHAR(4)
- SCSBJT_INSTR_EXMPTN_TM — CHAR(4)
- FNC_INSTR_EXMPTN_TM — CHAR(4)
- FST_SAT_TEST_YN — CHAR(1)
- FST_SUND_TEST_YN — CHAR(1)
- SCD_SAT_TEST_YN — CHAR(1)
- SCD_SUND_TEST_YN — CHAR(1)
- TD_SAT_TEST_YN — CHAR(1)
- TD_SUND_TEST_YN — CHAR(1)
- FRTH_SAT_TEST_YN — CHAR(1)
- FRTH_SUND_TEST_YN — CHAR(1)
- REG_LCEXCT_CD — VARCHAR2(2)
- MDFCN_LCEXCT_CD — VARCHAR2(2)
- ATMC_TRSMS_FNC_PSBLTY_YN — CHAR(1)
- ATMC_TRSMS_ROAD_DVRN_PSBLTY_YN — CHAR(1)
- SCSBJT_TEST_CKI_TM — CHAR(2)
- FNC_TEST_CKI_TM — CHAR(2)
- ROAD_DVRN_TEST_CKI_TM — CHAR(2)
- TEST_RTRCN_PSBLTY_TM — NUMBER(22,3)
- GNR_SFT_EDU_PSNCPA — NUMBER(22,3)
- TWOWHL_SFT_EDU_PSNCPA — NUMBER(22,3)
- EML_SNDNG_MSG — VARCHAR2(6000)
- LCEXCT_ALTM_IP — VARCHAR2(20)
- STPRS_TKCG_CTPL — VARCHAR2(13)
- MLTWHL_PRMMVR_FNC_PSBLTY_YN — CHAR(1)
- LCEXCT_ENG_ADDR — VARCHAR2(300)
- LCEXCT_ENG_NM — VARCHAR2(30)
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)
TT_DL_CM_RDRG_SN
- RDRG_SN — NUMBER(10) — Primary key — NOT NULL
- BRTYMD — CHAR(8) — NOT NULL
- SXDSTN — VARCHAR2(1) — NOT NULL
- RDRG_BRTYMD — CHAR(6) — NOT NULL
- RDRG_IDNTF_NO — CHAR(24) — NOT NULL
- RDRG_NM — VARCHAR2(75) — NOT NULL
- REG_DT — DATE — NOT NULL
- REG_ID — VARCHAR2(50) — NOT NULL
- MDFCN_DT — DATE
- MDFCN_ID — VARCHAR2(50)