chat-erd
Tables (5)
chat_message (Untitled)
- id — Primary key — NOT NULL
- chat_room_id (채팅방ID) — Foreign key → chat_room.id — NOT NULL
- member_id (보낸사람) — Foreign key → member.id — NOT NULL
- content (내용)
chat_participant (채팅참여자)
- id — Primary key — NOT NULL
- member_id (회원ID) — Foreign key → member.id — NOT NULL
- chat_room_id (채팅방ID) — Foreign key → chat_room.id — NOT NULL
chat_room (채팅방)
- id — Primary key — NOT NULL
- isGroupChat (오픈방여부)
- name (채팅방이름)
member (회원)
- id — Primary key — NOT NULL
- name (이름)
- email (이메일)
- password (비밀번호)
- role (역할)
message_read_status (메시지읽음)
- id — Primary key — NOT NULL
- member_id (회원ID) — Foreign key → member.id — NOT NULL
- message_id (메시지ID) — Foreign key → chat_message.id — NOT NULL
- chat_room_id (채팅방ID) — Foreign key → chat_room.id — NOT NULL
- isRead (읽음여부)