대출상담원 운영현황
테이블 (3)
Untitled
- SESSION_ID (KEY) — VERCHAR — 외래 키 → tbl_nwn_engine_users.SESSION_ID — NOT NULL
- ITG_SESS_ID (KEY2) — VERCHAR — 외래 키 → tbl_nwn_engine_users.ITG_SESS_ID — NOT NULL
- PRODUCT_NAME (Field)
- QUESTION (Field2)
- ANSWER (Field3)
- DOC_CONTENT (Field4)
- NLU_INTENT_ID (Field5)
- REG_TIME (Field6)
- FAB_DATA (Field7)
tbl_nwn_chat_history (뉴원 통합상담 챗봇 대화이력)
- SESSION_ID (Key) — VERCHAR — 기본 키 — NOT NULL
- ITG_SESS_ID (Key2) — VERSHAR — 기본 키 — NOT NULL
- MESSAGE_SEQ (Key3) — INT — 기본 키 — NOT NULL
- ITCSNO (Field) — VERCHAR — NOT NULL
- USER_ID (Field2) — VERCHAR — NOT NULL
- QA_TYPE (Field3) — VERCHAR
- CHAT_MESSAGE (Field4) — TEXT
- NLU_INTEN T_ID (Field5) — VERCHAR
- NLU_SCORE (Field6) — VERCHAR
- REG_TIME (Field7) — VERCHAR
tbl_nwn_engine_users (뉴원 통합상담)
- SESSION_ID (세션ID) — VERCHAR — 기본 키 — NOT NULL
- ITG_SESS_ID (통합상담세션ID) — VERCHAR — 기본 키 — NOT NULL
- ITCSNO (통고번호) — VERCHAR
- USER_ID (사용자ID) — VERCHAR
- CHANNEL_ID (화면ID) — VERCHAR
- VISIT_TIME (방문시간) — VERCHAR — NOT NULL
- EVALUATE_FLAG (만족도평가) — VERCHAR
- EVALUATE_MESSAGE (만족도평가 의견) — VERCHAR
- EVALUATE_TIME (만족도평가 기재 시간) — VERCHAR
- SP_CUS_TN (간편 회원 여부) — VERCHAR
- CHATBOT_ID (챗봇 ID) — VERCHAR
- FAB_DATA (상품코드값) — VERCHAR