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