AI_Chatbot_new

Tables (6)

tb_conv_analysis_his (분석이력)

  • hisId (his_id) — int — Primary key — NOT NULL
  • anInfoId (an_info_id) — int — Foreign key → tb_conv_analysis_info.anInfoId — NOT NULL
  • lineId (line_id) — int
  • convId (conv_id) — int
  • convTextHis (conv_text_his) — text
  • categoryText (category_text) — varchar(100)
  • keywordsText (keywords_text) — varchar(4000)
  • slangText (slang_text) — varchar(4000)
  • summaryText (summary_text) — varchar(2000)
  • createDt (create_dt) — datetime

tb_conv_analysis_info (분석내역)

  • anInfoId (an_info_id) — int — Primary key — NOT NULL
  • lineId (line_id) — int — Foreign key → tb_conv_line_info.lineId — NOT NULL
  • convId (conv_id) — int
  • convTextHis (conv_text_his) — text
  • categoryText (category_text) — varchar(100)
  • keywordsText (keywords_text) — varchar(4000)
  • slangText (slang_text) — varchar(4000)
  • summaryText (summary_text) — varchar(2000)
  • createDt (create_dt) — datetime

tb_conv_line_info (메세지내역)

  • lineId (line_id) — int — Primary key — NOT NULL
  • convId (conv_id) — int — Foreign key → tb_conv_mst.convId — NOT NULL
  • convKind (conv_kind) — char(10)
  • convText (conv_text) — text
  • convChnl (conv_chnl) — char(10)
  • convSeq (conv_seq) — int
  • createDt (create_dt) — datetime

tb_conv_mst (대화이력)

  • convId (conv_id) — int — Primary key — NOT NULL
  • coustId (count_id) — varchar(200)
  • senderId (sender_id) — varchar(200)
  • csReqId (cs_req_id) — varchar(200)
  • answerYn (answer_yn) — char(1)
  • answerCsId (answer_cs_id) — varchar(200)
  • createDt (create_dt) — datetime

tb_kdic_q (예금보호공사 질문 데이터)

  • qSeq (q_seq) — int — Primary key — NOT NULL
  • qText (q_text) — varchar(500)

tb_nia_qa (NIA 대화데이터)

  • msgId (msg_id) — int — Primary key — NOT NULL
  • dialId (dial_id) — int — Primary key — NOT NULL
  • dialFlow (dial_flow) — int — Primary key — NOT NULL
  • divQa (div_qa) — char(1)
  • text — varchar(200)