notion
Tables (6)
ChatMessage (채팅메시지)
- id (Key) — Long — Primary key — NOT NULL
- member_id (아이디) — Long — Foreign key → member.id — NOT NULL
- chat_room_id (채팅방 아이디) — Long — Foreign key → ChatRoom.id — NOT NULL
- Field
ChatParticipant (참여자)
- Key — Primary key — NOT NULL
- member_id (아이디) — Long — Foreign key → member.id — NOT NULL
- chat_room_id (Key2) — 채팅방 아이디 — Foreign key → ChatRoom.id — NOT NULL
ChatRoom (채팅방)
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- isGroupChat (Field2) — String
Content (내용)
- id (Key) — Long — Primary key — NOT NULL
- Chat_message_id (Key2) — Long — Foreign key → ChatMessage.id — NOT NULL
- textBody (Field) — String
ReadStatus (읽음 상태 엔티티)
- id (Key) — Long — Primary key — NOT NULL
- member_id (아이디) — Long — Foreign key → member.id — NOT NULL
- chat_room_id (채팅방아이디) — Long — Foreign key → ChatRoom.id — NOT NULL
- chat_message_id (Key2) — Long — Foreign key → ChatMessage.id — NOT NULL
- isRead (Field) — boolean
member (맴버)
- id (아이디) — Long — Primary key — NOT NULL
- name (이름) — String
- password (비밀번호) — String
- role (역할) — Role