Chat

Tables (8)

ChatMessage

  • id — INT — Primary key
  • sender — ENUM('user', 'bot') — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — DATETIME
  • session_id — INT — Foreign key → ChatSession.id

ChatSession

  • id — INT — Primary key
  • session_title — VARCHAR(100)
  • created_at — DATETIME
  • user_id — INT — Foreign key → User.id

CounselingPost

  • id — INT — Primary key
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • category — ENUM('심리', '관계', '중독', '위험') — NOT NULL
  • created_at — DATETIME
  • user_id — INT — Foreign key → User.id

CounselingPostAttachment

  • id — INT — Primary key
  • file_name — VARCHAR(255) — NOT NULL
  • file_path — VARCHAR(500) — NOT NULL
  • uploaded_at — DATETIME
  • post_id — INT — Foreign key → CounselingPost.id

Document

  • id — INT — Primary key
  • title — VARCHAR(255)
  • content — TEXT
  • uploaded_at — DATETIME
  • user_id — INT — Foreign key → User.id

Feedback

  • id — INT — Primary key
  • rating — TINYINT
  • comment — TEXT — EX
  • created_at — DATETIME
  • message_id — INT — Foreign key → ChatMessage.id

PostComment

  • id — INT — Primary key
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • post_id — INT — Foreign key → CounselingPost.id
  • user_id — INT — Foreign key → User.id

User

  • id — INT — Primary key
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50)
  • created_at — DATETIME