chat

Tables (4)

Chat_room (채팅방)

  • room_id (pk) — BIGINT — Primary key — NOT NULL
  • update_at (마지막 활동 시간) — DATETIME

Chat_room_member (채팅방 사람)

  • user_id (FK) — BIGINT — Primary key — NOT NULL
  • room_id (pk) — BIGINT — Foreign key → Chat_room.room_id — NOT NULL
  • joined_at (입장 시간) — DATETIME
  • last_read_message_id (마지막으로 읽은 메세지) — BIGINT

MESSAAGE_READ (다인 채팅 대비)

  • read_at (읽은 시간) — DATETIME
  • message_id (PK) — BIGINT — Foreign key → MESSAGE.message_id — NOT NULL
  • sender_id (user_id(fk)) — BIGINT — Foreign key → MESSAGE.sender_id — NOT NULL
  • room_id (pk) — BIGINT — Foreign key → MESSAGE.room_id — NOT NULL

MESSAGE (메세지)

  • message_id (PK) — BIGINT — Primary key — NOT NULL
  • sender_id (user_id(fk)) — BIGINT — Primary key — NOT NULL
  • room_id (pk) — BIGINT — Foreign key → Chat_room.room_id — NOT NULL
  • content (내용) — TEXT
  • created_at (보낸 시간) — DATETIME
  • is_deleted (삭제 여부) — BOOLEAN