chat_service
Tables (6)
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 (역할)
member (CopyOf회원)
- id — Primary key — NOT NULL
- name (이름)
- email (이메일) — NOT NULL
- password (패스워드) — NOT NULL
- role (역할)
- socialType (소셜로그인종류)
- socialId (소셜로그인ID)
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