ai chatbot
Tables (5)
CHAT_FEEDBACKS (답변 피드백)
- FEEDBACK_ID (피드백 ID) — VARCHAR — Primary key — NOT NULL
- CHAT_ID (채팅 ID) — VARCHAR — Foreign key → CHAT_LOGS.CHAT_ID — NOT NULL
- SESSION_ID (세션 ID) — VARCHAR — Foreign key → CHAT_LOGS.SESSION_ID — NOT NULL
- USER_ID (ID2) — VARCHAR — Foreign key → CHAT_LOGS.USER_ID
- RATING (점수(좋아요/안좋아요)) — VARCHAR
- SUGGESTION (건의사항) — TEXT
- CREATED_DT (생성시간) — TIMESTAMP
CHAT_LOGS (채팅기록(히스토리))
- CHAT_ID (채팅 ID) — VARCHAR — Primary key — NOT NULL
- SESSION_ID (세션 ID) — VARCHAR — Foreign key → SESSIONS.SESSION_ID — NOT NULL
- USER_ID (ID) — VARCHAR — Foreign key → SESSIONS.USER_ID
- ROLE (발신자(USER OR AI)) — VARCHAR
- MESSAGE (TEXT) — TEXT
- TOKEN_COUNT (사용된 토큰 수) — INT
- REQ_CHAT_ID (질문 채팅ID (어떤 질문에 대한 답변인지)) — VARCHAR
- CREATED_DT (생성시간) — TIMESTAMP
SESSIONS (사용자 세션)
- SESSION_ID (세션 ID) — VARCHAR — Primary key — NOT NULL
- USER_ID (ID) — VARCHAR — Foreign key → USER.USER_ID
- SESSION_NM (세션명) — VARCHAR
- CREATED_DT (생성시간) — TIMESTAMP
- EXPIRED_DT (만료시간) — TIMESTAMP
USER (사용자)
- USER_ID (ID) — VARCHAR — Primary key
- USER_NM (이름) — VARCHAR
- CREATED_DT (생성시간) — TIMESTAMP
USER_LIMITS (사용자 채팅 제한)
- USER_ID (ID) — VARCHAR — Foreign key → USER.USER_ID
- BLOCKED_UNTIL (제한 해제 시간) — TIMESTAMP