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