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)