chat
Tables (5)
Member (회원)
- id — Primary key — NOT NULL
- name (이름)
- email (이메일)
- password (패스워드) — NOT NULL
- role (역할)
chat_message (채팅메시지)
- id — Primary key — NOT NULL
- member_id (보낸사람) — Foreign key → Member.id — NOT NULL
- chat_room_id (채팅방ID) — Foreign key → chat_room.Key — NOT NULL
- content (내용)
chat_participant (채팅참여자)
- id — Primary key — NOT NULL
- chat_room_id (채팅방ID) — Foreign key → chat_room.Key — NOT NULL
- member_id (회원ID) — Foreign key → Member.id — NOT NULL
chat_room (채팅방)
- Key (id) — Primary key — NOT NULL
- isGroupChat (오픈채팅여부) — NOT NULL
- Field
message_read_status (메시지읽음)
- id — Primary key — NOT NULL
- member_id (회원ID) — Foreign key → Member.id — NOT NULL
- chart_room_id (채팅방ID) — Foreign key → chat_room.Key — NOT NULL
- message_id (메시지ID) — Foreign key → chat_message.id — NOT NULL
- id (id2) — Foreign key → chat_message.member_id — NOT NULL
- Key (id22) — Foreign key → chat_message.chat_room_id — NOT NULL
- isRead (읽음여부) — NOT NULL