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