chat-room

Tables (5)

chat_message (채팅메시지)

  • id — Primary key — NOT NULL
  • member_id (보낸사람) — Foreign key → member.id — NOT NULL
  • chat_room_id (채팅방 ID) — Foreign key → chat_room.id — NOT NULL
  • content (내용)

chat_participant (채팅 참여자)

  • id — Primary key — NOT NULL
  • chatroom_id (채팅방 ID) — Foreign key → chat_room.id — NOT NULL
  • member_id (회원ID) — Foreign key → member.id — NOT NULL

chat_room (채팅방)

  • id — Primary key — NOT NULL
  • isGroupChat (오픈방여부)
  • name (채팅방이름)

member (회원)

  • id — Primary key — NOT NULL
  • name (이름)
  • email (이메일) — NOT NULL
  • password (패스워드) — NOT NULL
  • role (역할)

message_read_status (메시지 읽음)

  • id — Primary key — NOT NULL
  • id (id2) — Foreign key → chat_message.id — NOT NULL
  • member_id (보낸사람) — Foreign key → chat_message.member_id — NOT NULL
  • chat_room_id (채팅방 ID) — Foreign key → chat_message.chat_room_id — NOT NULL
  • isRead (읽음여부) — NOT NULL