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)