notion

Tables (6)

ChatMessage (채팅메시지)

  • id (Key) — Long — Primary key — NOT NULL
  • member_id (아이디) — Long — Foreign key → member.id — NOT NULL
  • chat_room_id (채팅방 아이디) — Long — Foreign key → ChatRoom.id — NOT NULL
  • Field

ChatParticipant (참여자)

  • Key — Primary key — NOT NULL
  • member_id (아이디) — Long — Foreign key → member.id — NOT NULL
  • chat_room_id (Key2) — 채팅방 아이디 — Foreign key → ChatRoom.id — NOT NULL

ChatRoom (채팅방)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • isGroupChat (Field2) — String

Content (내용)

  • id (Key) — Long — Primary key — NOT NULL
  • Chat_message_id (Key2) — Long — Foreign key → ChatMessage.id — NOT NULL
  • textBody (Field) — String

ReadStatus (읽음 상태 엔티티)

  • id (Key) — Long — Primary key — NOT NULL
  • member_id (아이디) — Long — Foreign key → member.id — NOT NULL
  • chat_room_id (채팅방아이디) — Long — Foreign key → ChatRoom.id — NOT NULL
  • chat_message_id (Key2) — Long — Foreign key → ChatMessage.id — NOT NULL
  • isRead (Field) — boolean

member (맴버)

  • id (아이디) — Long — Primary key — NOT NULL
  • name (이름) — String
  • password (비밀번호) — String
  • role (역할) — Role