대출상담원 운영현황

테이블 (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