AI_Chatbot_old

Tables (6)

tb_anal_info (분석내역)

  • latestId (latest_id) — int — Primary key — NOT NULL
  • analId (anal_id) — int — Foreign key → tb_anal_record.analId — NOT NULL
  • dialId (dial_id2) — int — Foreign key → tb_anal_record.dialId — NOT NULL
  • dialId (dial_id3) — int — Foreign key → tb_dialog_record.dialId — NOT NULL
  • msgId (msg_id2) — int — Foreign key → tb_anal_record.msgId — NOT NULL
  • dialId (dial_id22) — int — Foreign key → tb_anal_record.dialId — NOT NULL
  • msgId (msg_id) — int
  • text — varchar(3000)
  • category — varchar(50)
  • keywords — varchar(100)
  • slang — varchar(100)
  • sumary (summary) — varchar(100)
  • date — datetime

tb_anal_record (분석이력)

  • analId (anal_id) — int — Primary key — NOT NULL
  • dialId (dial_id) — int — Foreign key → tb_dialog_record.dialId — NOT NULL
  • msgId (msg_id2) — int — Foreign key → tb_msg_info.msgId — NOT NULL
  • dialId (dial_id2) — int — Foreign key → tb_msg_info.dialId — NOT NULL
  • msgId (msg_id) — int
  • text — varchar(3000)
  • category — varchar(50)
  • keywords — varchar(100)
  • slang — varchar(100)
  • summary — varchar(100)
  • date — datetime

tb_dialog_record (대화이력)

  • dialId (dial_id) — int — Primary key — NOT NULL
  • userId (user_id) — int
  • csId (cs_id) — int
  • divQa (div_qa) — char(1)
  • divAc (div_ac) — char(2)

tb_kdic_q (Untitled)

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

tb_msg_info (메세지내역)

  • msgId (msg_id) — int — Primary key — NOT NULL
  • dialId (dial_id) — int — Foreign key → tb_dialog_record.dialId — NOT NULL
  • msgText (msg_text) — varchar(500)
  • dialFlow (dial_flow) — int
  • divQa (div_qa) — char(1)
  • date — datetime

tb_nia_qa (Untitled2)

  • 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)