졸프(심리상담 챗봇)
테이블 (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