CHATTING-PRACTICE

Tables (5)

chat_message (채팅 메시지)

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

chat_participant (채팅방 참여자)

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

chat_room (채팅방)

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

member (회원)

  • id — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(255) — NOT NULL
  • email (이메일) — VARCHAR(255) — NOT NULL
  • password (비밀번호) — VARCHAR(255) — NOT NULL
  • role (역할) — VARCHAR(255)

message_read_status (메시지 읽음)

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