원자력
테이블 (11)
APL_COURSE
- TRN_REQ_SEQ — NUMBER — NOT NULL — ????????
- ORDER_NO2 — VARCHAR2(32) — NOT NULL
- GRP_SEQ — NUMBER — NOT NULL — ?????
- ORDER_NO — VARCHAR2(32) — NOT NULL — ????
- ORDER_DTL_SN — NUMBER(4, 0) — NOT NULL — ??????
- MBR_ID — VARCHAR2(32) — NOT NULL — ??ID
- MBR_NM — VARCHAR2(64) — NOT NULL — ???
- REQ_STAT_CD — VARCHAR2(32) — NOT NULL — ??????(CATE_CD=SC056)
- REG_DTM — DATE — NOT NULL — ????
- REQ_STAT_RSN — VARCHAR2(1024) — ??????
- REQ_STAT_RSN_CD — VARCHAR2(32) — ????????
- MOD_DTM — DATE — ????
ITIS_ISSU_MSTR
- ISSU_SEQNO — VARCHAR2(24 CHAR) — NOT NULL
- ISSU_ID — VARCHAR2(24 CHAR)
- SELR_MGR_ID1 — VARCHAR2(10 CHAR)
- SELR_MGR_ID2 — VARCHAR2(5 CHAR)
- SELR_MGR_ID3 — VARCHAR2(20 CHAR)
- REGS_DATE — CHAR(8 CHAR) — NOT NULL
- TAX_TYPE — CHAR(4 CHAR) — NOT NULL
- POPS_CODE — CHAR(2 CHAR) — NOT NULL
- MODY_CODE — CHAR(2 CHAR)
- NOTE1 — VARCHAR2(150 CHAR)
- NOTE2 — VARCHAR2(150 CHAR)
- NOTE3 — VARCHAR2(150 CHAR)
- IMPT_NO — CHAR(15 CHAR)
- ACEP_STAT_DATE — CHAR(8 CHAR)
- ACEP_END_DATE — CHAR(8 CHAR)
- ITEM_QUANT — VARCHAR2(6 CHAR)
- SELR_CORP_NO — VARCHAR2(13 CHAR) — NOT NULL
- SELR_CODE — CHAR(4 CHAR)
- SELR_CORP_NM — VARCHAR2(70 CHAR) — NOT NULL
- SELR_CEO — VARCHAR2(30 CHAR) — NOT NULL
- SELR_ADDR — VARCHAR2(150 CHAR) — NOT NULL
- SELR_BUSS_CONS — VARCHAR2(40 CHAR)
- SELR_BUSS_TYPE — VARCHAR2(40 CHAR)
- SELR_CHRG_POST — VARCHAR2(40 CHAR)
- SELR_CHRG_NM — VARCHAR2(64)
- SELR_CHRG_TEL — VARCHAR2(20 CHAR)
- SELR_CHRG_EMAIL — VARCHAR2(40 CHAR)
- SELR_CHRG_MOBL — VARCHAR2(20 CHAR)
- SELR_CHRG_FAX — VARCHAR2(20 CHAR)
- BUYR_GB — CHAR(2 CHAR)
- BUYR_CORP_NO — VARCHAR2(13 CHAR) — NOT NULL
- BUYR_CODE — CHAR(4 CHAR)
- BUYR_CORP_NM — VARCHAR2(70 CHAR) — NOT NULL
- BUYR_CEO — VARCHAR2(30 CHAR) — NOT NULL
- BUYR_ADDR — VARCHAR2(150 CHAR) — NOT NULL
- BUYR_BUSS_CONS — VARCHAR2(40 CHAR)
- BUYR_BUSS_TYPE — VARCHAR2(40 CHAR)
- BUYR_CHRG_FAX — VARCHAR2(20 CHAR)
- BUYR_CHRG_POST1 — VARCHAR2(40 CHAR)
- BUYR_CHRG_NM1 — VARCHAR2(64)
- BUYR_CHRG_TEL1 — VARCHAR2(20 CHAR)
- BUYR_CHRG_EMAIL1 — VARCHAR2(40 CHAR)
- BUYR_CHRG_MOBL1 — VARCHAR2(20 CHAR)
- BUYR_CHRG_POST2 — VARCHAR2(40 CHAR)
- BUYR_CHRG_NM2 — VARCHAR2(64)
- BUYR_CHRG_TEL2 — VARCHAR2(20 CHAR)
- BUYR_CHRG_EMAIL2 — VARCHAR2(40 CHAR)
- BUYR_CHRG_MOBL2 — VARCHAR2(20 CHAR)
- BROK_CORP_NO — VARCHAR2(13 CHAR)
- BROK_CODE — CHAR(4 CHAR)
- BROK_CORP_NM — VARCHAR2(70 CHAR)
- BROK_CEO — VARCHAR2(30 CHAR)
- BROK_ADDR — VARCHAR2(150 CHAR)
- BROK_BUSS_CONS — VARCHAR2(40 CHAR)
- BROK_BUSS_TYPE — VARCHAR2(40 CHAR)
- BROK_CHRG_POST — VARCHAR2(40 CHAR)
- BROK_CHRG_NM — VARCHAR2(64)
- BROK_CHRG_TEL — VARCHAR2(20 CHAR)
- BROK_CHRG_EMAIL — VARCHAR2(40 CHAR)
- PYMT_TYPE1 — CHAR(2 CHAR)
- … +35
MBR_DEC_FAIL
- NUM — varchar(50) — NOT NULL
- TABLE_NM — varchar(50)
- MBR_ID — varchar(100)
- MBR_JUMIN — varchar(100)
ON_ORD_PAY_REL
- ORD_SEQ — NUMBER — NOT NULL — ??
- PAY_SEQ — NUMBER — NOT NULL — ??
- GRP_SEQ — NUMBER(4, 0) — NOT NULL — ?????
ORD_ORDER
- ORDER_NO — VARCHAR2(32) — NOT NULL
- ORD_SEQ — NUMBER — NOT NULL — ??
- GRP_SEQ — NUMBER — NOT NULL — ?????
- MBR_ID — VARCHAR2(32) — ??ID
- MBR_NM — VARCHAR2(64) — ????
- ORDER_STAT_CD — VARCHAR2(32) — ??????(CATE_CD=SC050)
- STAT_MOD_DTM — DATE — ??????
- STAT_MOD_ID — VARCHAR2(32) — ????ID
- PAY_CD — VARCHAR2(32) — ????(CATE_CD=SC051)
- GOODS_BUY_PRICE_TOT — NUMBER(8, 0) — ????????
- DLV_PRICE_TOT — NUMBER(8, 0) — ?????
- USE_PT_TOT — NUMBER(8, 0) — ???????
- ORD_USR_TEL_NO — VARCHAR2(16) — ???????
- ORD_USR_MBL_NO — VARCHAR2(16) — ????????
- ORD_USR_EML — VARCHAR2(64) — ??????
- ORD_USR_ZIP — VARCHAR2(6) — ???????
- ORD_USR_ADDR1 — VARCHAR2(512) — ???????
- ORD_USR_ADDR2 — VARCHAR2(512) — ???????
- RCV_USR_NM — VARCHAR2(64) — ????
- RCV_USR_TEL_NO — VARCHAR2(16) — ???????
- RCV_USR_MBL_NO — VARCHAR2(16) — ????????
- RCV_USR_ZIP — VARCHAR2(6) — ???????
- RCV_USR_ADDR1 — VARCHAR2(512) — ???????
- RCV_USR_ADDR2 — VARCHAR2(512) — ???????
- DLV_MEMO — VARCHAR2(1024) — ????
- ATNLC_REQ_PATH_CD — VARCHAR2(32) — ????????(CATE_CD=SC052)
- ATNLC_REQ_PATH_ETC — VARCHAR2(512) — ????????
- CARD_APPR_NO — VARCHAR2(32) — ??????
- CARD_PAY_CNTN — VARCHAR2(32) — ??????
- CARD_PAY_CD — VARCHAR2(32) — ??????
- CARD_PAY_DTM — DATE — ??????
- RCT_BANK_CD — VARCHAR2(32) — ??????(CATE_CD=SC007)
- RCT_ACT — VARCHAR2(32) — ????
- RCT_USR_NM — VARCHAR2(64) — ????
- REG_DTM — DATE — ????
- STAT_MOD_IP — VARCHAR2(32) — ???
- DEPOSITDATE — DATE — ???
- DEPOSITMEMO — VARCHAR2(100) — ????(??)
- ACC_MBR_ID — VARCHAR2(32)
- FORCE_MOD_ID — VARCHAR2(32)
- FORCE_MOD_DTM — DATE
ORD_ORDER_COMPLETE
- ORD_SEQ — NUMBER(22) — NOT NULL
- SMS_STATUS — CHAR(1)
- REG_DTM — DATE
- MOD_DTM — DATE
ORD_PAY
- PAY_SEQ — NUMBER — NOT NULL — ??
- GRP_SEQ — NUMBER(4, 0) — NOT NULL — ?????
- PAY_AMT — NUMBER(12, 0) — ????
- ORD_AMT — NUMBER(12, 0) — ????
- PAY_METHOD — VARCHAR2(32)
- PAY_STATUS — VARCHAR2(4) — S001:???
- KCP_NO — VARCHAR2(40) — KCP
- KCP_TNO — NUMBER(14, 0) — KCP
- PART_CANCL_AMT — NUMBER(12, 0) — ??????
- PART_CANCL_POSBL_AMT — NUMBER(12, 0) — ????????
- CARD_TYPE_01 — VARCHAR2(5) — ????1(SP003)
- CARD_TYPE_02 — VARCHAR2(5) — ????2(SP004)
- CARD_APPR_NO — VARCHAR2(32) — ??????
- CARD_PART_CANCL_POSBL_FLG — CHAR(1) — ??????????
- CARD_CD — VARCHAR2(5) — ????(SP005)(??
- CARD_NO — VARCHAR2(128) — ????
- CARD_INST — NUMBER(2, 0) — ??????
- CARD_NO_INST_FLG — CHAR(1) — ???????
- CASH_RCIPT_NO — VARCHAR2(30) — ?????????
- CASH_RCIPT_APPR_FLG — CHAR(1) — ?????????
- CASH_RCIPT_REG_FLG — CHAR(1) — ?????????
- CASH_RCIPT_PBLICTE_FLG — CHAR(1) — ?????????
- TAX_BILL_FLG — CHAR(1) — ?????
- TAX_BILL_NO — VARCHAR2(30) — ?????
- VIT_BANK_CD — VARCHAR2(5) — ?????????
- VIT_ACC_NO — VARCHAR2(128) — ???????????
- VIT_ACC_TIME — VARCHAR2(14) — ????????
- VIT_APPR_TIME — VARCHAR2(14) — ????
- BANK_ACC_CD — VARCHAR2(5) — ???????
- BANK_ACC_NO — VARCHAR2(20) — ???????
- VIT_BANK_ACC_NM — VARCHAR2(64) — ????????????
- PAY_DTM — DATE — ??????
- PAY_ETC — VARCHAR2(500) — ??
- CASH_ID_INFO — VARCHAR2(30) — ?????
- CASH_TR_CODE — CHAR(1) — ?????
- CASH_AUTHNO — VARCHAR2(9) — ?????
- CASH_YN — CHAR(1) — ?????
- CASH_NO — VARCHAR2(14) — ?????
- VIT_RT_REMITTER — VARCHAR2(14) — ????????
- VIT_RT_IPGM_MNYX — NUMBER(12, 0) — ????????
- VIT_RT_BANK_CODE — VARCHAR2(5) — ????????
- VIT_RT_ACCOUNT — VARCHAR2(20) — ????????
- VIT_RT_OP_CD — VARCHAR2(2) — ????????
- VIT_RT_NOTI_ID — VARCHAR2(20) — ????????
ORD_PAY_COMPLETE
- KCP_NO — VARCHAR(255) — NOT NULL
- KCP_TNO — VARCHAR(255) — NOT NULL
- SMS_STATUS — CHAR(1)
- REG_DTM — DATE
- MOD_DTM — DATE
ORD_PAY_RFD
- Key — NUMBER — NOT NULL
- GRP_SEQ — NUMBER(4,0)
- APL_MBR_ID — VARCHAR2(32)
- MBR_IDS — VARCHAR2(4000)
- RFD_FLG — VARCHAR2(4)
- ACC_BANK_CD — VARCHAR2(5)
- ACC_NO — VARCHAR2(20)
- ACC_NM — VARCHAR2(64)
- ACC_TEL — VARCHAR2(14)
- ACC_MAIL — VARCHAR2(50)
- CARD_NO — VARCHAR2(128)
- RFD_CNT — NUMBER(4,0)
- RFD_AMT — NUMBER(12,0)
- RFD_REASON — VARCHAR2(200)
- RFD_ETC — VARCHAR2(255)
- REG_USR_ID — VARCHAR2(32)
- REG_USR_NM — VARCHAR2(64)
- REG_DTM — DATE
- CARD_CD — VARCHAR2(5)
- RFD_PHONE — VARCHAR2(20)
- RFD_JUMIN — VARCHAR2(200)
- ACC_MBR_ID — VARCHAR2(32)
- BNKBK_IMG_SEQ — NUMBER
- DPSTSP_IMG_SEQ — NUMBER
- RFD_NAME — VARCHAR2(32)
- RFD_STATUS — VARCHAR2(32)
- EDU_TYPE — VARCHAR2(5)
ORD_PAY_RFD_REL
- PAY_SEQ — NUMBER — NOT NULL — ??
- GRP_SEQ — NUMBER(4, 0) — NOT NULL — ?????
- RFD_SEQ — NUMBER — NOT NULL
TAX_SIN
- PAY_IDX — NUMBER(10, 0) — NOT NULL — ??
- IDX — NUMBER(10, 0) — NOT NULL
- SID — NUMBER(10, 0) — NOT NULL
- SNM — VARCHAR2(70 CHAR) — NOT NULL
- DNM — VARCHAR2(64) — NOT NULL
- SNUM — VARCHAR2(20 CHAR) — NOT NULL
- HDATE — VARCHAR2(20 CHAR) — NOT NULL
- IND — VARCHAR2(10 CHAR) — NOT NULL
- IND_STATUS — VARCHAR2(30 CHAR) — NOT NULL
- EDU_NM — VARCHAR2(70 CHAR) — NOT NULL
- PRICE — VARCHAR2(20 CHAR) — NOT NULL
- EMAIL — VARCHAR2(100 CHAR) — NOT NULL
- HP — VARCHAR2(20 CHAR) — NOT NULL
- REGDATE — VARCHAR2(10 CHAR) — NOT NULL
- STATE — VARCHAR2(10 CHAR) — NOT NULL
- NM — VARCHAR2(64) — NOT NULL
- CUP — VARCHAR2(30 CHAR)
- CJONG — VARCHAR2(30 CHAR)
- CZIP1 — VARCHAR2(10 CHAR)
- CZIP2 — VARCHAR2(10 CHAR)
- CADDR1 — VARCHAR2(150 CHAR)
- CADDR2 — VARCHAR2(150 CHAR)
- CADDR3 — VARCHAR2(150 CHAR)
- ITEM — VARCHAR2(512 CHAR) — NOT NULL
- ETC — VARCHAR2(100 CHAR)
- BILL_CONF_NUM — VARCHAR2(50 CHAR)
- MOD_BILL_INFO — VARCHAR2(50 CHAR)
- PUBLISH_DATE — VARCHAR2(20 CHAR)
- TB_STATE — CHAR(2 CHAR)
- TB_CODE — VARCHAR2(255 CHAR)
- TB_MSG — VARCHAR2(500 CHAR)
- TB_ISSU_ID — VARCHAR2(24 CHAR)
- MB_NAME — VARCHAR2(200 CHAR)
- MB_EMAIL — VARCHAR2(200 CHAR)
- MB_HP — VARCHAR2(200 CHAR)
- MINUS_NAME — VARCHAR2(200)
- MINUS_HP — VARCHAR2(200)
- MINUS_EMAIL — VARCHAR2(200)
- REG_USR_ID — VARCHAR2(200)
- MOD_REG_DTM — VARCHAR2(10)
- MOD_USR_ID — VARCHAR2(64)
- COM_BUSI_NO2 — VARCHAR2(200)
- CGUBUN — VARCHAR2(200)