chatbot_erd
Tables (5)
characters
- id — INT
- name — VARCHAR(255) — NOT NULL
- personality — TEXT
- backstory — TEXT
- appearance — TEXT
- speech_style — TEXT
- user_relationship — TEXT
- system_prompt — TEXT
- example_dialogue — TEXT
- opening_message — TEXT
- created_at — DATETIME
chat_sessions
- id — INT
- character_id — INT — Foreign key → characters.id — NOT NULL
- user_persona_id — INT — Foreign key → user_personas.id
- session_name — VARCHAR(255)
- created_at — DATETIME
conversation_summaries
- id — INT
- session_id — INT — Foreign key → chat_sessions.id — NOT NULL
- summary_text — TEXT — NOT NULL
- from_message_id — INT — NOT NULL
- to_message_id — INT — NOT NULL
- turn_count — INT — NOT NULL
- created_at — DATETIME
messages
- id — INT
- session_id — INT — Foreign key → chat_sessions.id — NOT NULL
- role — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- feedback_score — INT
- model_name — VARCHAR(255)
- generation_time_ms — INT
- is_edited — INT
- created_at — DATETIME
user_personas
- id — INT
- name — VARCHAR(255) — NOT NULL
- personality — TEXT
- backstory — TEXT
- appearance — TEXT
- speech_style — TEXT
- created_at — DATETIME