chat

Tables (4)

chat_room (채팅방)

  • chat_room_id (채팅방 ID) — Primary key — NOT NULL
  • chat_room_name (채팅방 이름)
  • type (채티방 타입)
  • is_active (활성화 여부)
  • max-members (인원수)
  • create_by (생성일)

chat_room_members (채팅방 참여 회원)

  • chat_room-members_id (채팅방 참여 회원 ID) — Primary key — NOT NULL
  • member_id (회원 ID) — Foreign key → member.member_id — NOT NULL
  • chat_room_id (채팅방 ID) — Foreign key → chat_room.chat_room_id — NOT NULL
  • role (채팅방 내 역할) — ADMIN, MEMBER
  • last_read_message_id (이 채팅방에서 마지막으로 읽은 메시지 ID)

member (회원)

  • member_id (회원 ID) — Primary key — NOT NULL
  • email (이메일)
  • password (비밀번호)
  • name (이름)

message (메시지)

  • message_id (메시지 ID) — Primary key — NOT NULL
  • member_id (회원 ID) — Foreign key → member.member_id — NOT NULL
  • chat_room_id (채팅방 ID) — Foreign key → chat_room.chat_room_id — NOT NULL
  • content (내용)
  • sequence_number (순서 보장 번호)