chat

Tables (5)

Member (회원)

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

chat_message (채팅메시지)

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

chat_participant (채팅참여자)

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

chat_room (채팅방)

  • Key (id) — Primary key — NOT NULL
  • isGroupChat (오픈채팅여부) — NOT NULL
  • Field

message_read_status (메시지읽음)

  • id — Primary key — NOT NULL
  • member_id (회원ID) — Foreign key → Member.id — NOT NULL
  • chart_room_id (채팅방ID) — Foreign key → chat_room.Key — NOT NULL
  • message_id (메시지ID) — Foreign key → chat_message.id — NOT NULL
  • id (id2) — Foreign key → chat_message.member_id — NOT NULL
  • Key (id22) — Foreign key → chat_message.chat_room_id — NOT NULL
  • isRead (읽음여부) — NOT NULL