실시간채팅

테이블 (6)

chat_room

  • room_id — BIGINT — NOT NULL
  • room_name — VARCHAR(100)
  • room_type — VARCHAR(10) — NOT NULL
  • created_by — BIGINT — NOT NULL
  • is_active — BOOLEAN
  • last_message_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME
  • INDEX — idx_room_type
  • INDEX — idx_last_message_at

chat_room_member

  • member_id — BIGINT — NOT NULL
  • room_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • joined_at — DATETIME
  • last_read_at — DATETIME
  • unread_count — INT
  • is_active — BOOLEAN
  • role — VARCHAR(10)
  • INDEX — idx_user_id
  • INDEX — idx_room_id

message

  • message_id — BIGINT — NOT NULL
  • room_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • message_type — VARCHAR(10)
  • is_deleted — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME
  • INDEX — idx_room_id
  • INDEX — idx_sender_id
  • INDEX — idx_created_at

message_read_status

  • read_id — BIGINT — NOT NULL
  • message_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • read_at — DATETIME
  • INDEX — idx_message_id
  • INDEX — idx_user_id

typing_status

  • typing_id — BIGINT — NOT NULL
  • room_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • is_typing — BOOLEAN
  • started_at — DATETIME

user

  • user_id — BIGINT — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • avatar_url — VARCHAR(500)
  • status — VARCHAR(10)
  • last_active_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME
  • INDEX — idx_email
  • INDEX — idx_status