졸프(심리상담 챗봇)

테이블 (6)

BotMessage (Untitled4)

  • message_id (Key) — int — 기본 키 — NOT NULL
  • message_id (Key2) — int — 외래 키 → UserMessage.message_id — NOT NULL
  • session_id (Field) — int
  • response_content (Field2) — String
  • timestamp (Field4) — Date

ChatSession (Untitled2)

  • session_id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → User.user_id — NOT NULL
  • start_time (Field2) — int
  • end_time (Field3) — int

Content (Untitled5)

  • content_id (Key) — int — 기본 키 — NOT NULL
  • content_list_id (Key2) — int — 외래 키 → ContentList.content_list_id — NOT NULL
  • emotion (Field) — String
  • url (Field2) — String
  • image (Field3) — Image

ContentList (Untitled6)

  • content_list_id (Key) — int — 기본 키 — NOT NULL
  • emotion (Field) — String
  • content_id (Field2) — int

User (Untitled)

  • user_id (Key) — int — 기본 키 — NOT NULL
  • token (user_id)

UserMessage (Untitled3)

  • message_id (Key) — int — 기본 키 — NOT NULL
  • session_id (Key2) — int — 외래 키 → ChatSession.session_id — NOT NULL
  • message_content (Field2) — String
  • emotion (Field3) — String
  • timestamp (Field4) — Date