study_erd
Tables (5)
chat_message (채팅메시지)
- 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
- chat_room_id (채팅방id) — Foreign key → chat_room.id — NOT NULL
- member_id (회원id) — Foreign key → member.id — NOT NULL
chat_room (채팅방)
- id (아이디) — Primary key — NOT NULL
- isGroupChat (오픈방여부)
- name (채팅방이름)
member (회원)
- id — Primary key — NOT NULL
- name (이름)
- email (이메일) — NOT NULL
- password (패스워드) — NOT NULL
- role (역할)
message_read_status (메시지읽음)
- id — Primary key — NOT NULL
- message_id (메시지id) — Foreign key → chat_message.id — NOT NULL
- member_id (회원id) — Foreign key → member.id — NOT NULL
- chat_room_id (채팅방id) — Foreign key → chat_room.id — NOT NULL
- isRead (읽음여부) — NOT NULL