chat
Tables (4)
chat_room (채팅방)
- chat_room_id (채팅방 ID) — Primary key — NOT NULL
- chat_room_name (채팅방 이름)
- type (채티방 타입)
- is_active (활성화 여부)
- max-members (인원수)
- create_by (생성일)
chat_room_members (채팅방 참여 회원)
- chat_room-members_id (채팅방 참여 회원 ID) — Primary key — NOT NULL
- member_id (회원 ID) — Foreign key → member.member_id — NOT NULL
- chat_room_id (채팅방 ID) — Foreign key → chat_room.chat_room_id — NOT NULL
- role (채팅방 내 역할) — ADMIN, MEMBER
- last_read_message_id (이 채팅방에서 마지막으로 읽은 메시지 ID)
member (회원)
- member_id (회원 ID) — Primary key — NOT NULL
- email (이메일)
- password (비밀번호)
- name (이름)
message (메시지)
- message_id (메시지 ID) — Primary key — NOT NULL
- member_id (회원 ID) — Foreign key → member.member_id — NOT NULL
- chat_room_id (채팅방 ID) — Foreign key → chat_room.chat_room_id — NOT NULL
- content (내용)
- sequence_number (순서 보장 번호)