chat
Tables (4)
Chat_room (채팅방)
- room_id (pk) — BIGINT — Primary key — NOT NULL
- update_at (마지막 활동 시간) — DATETIME
Chat_room_member (채팅방 사람)
- user_id (FK) — BIGINT — Primary key — NOT NULL
- room_id (pk) — BIGINT — Foreign key → Chat_room.room_id — NOT NULL
- joined_at (입장 시간) — DATETIME
- last_read_message_id (마지막으로 읽은 메세지) — BIGINT
MESSAAGE_READ (다인 채팅 대비)
- read_at (읽은 시간) — DATETIME
- message_id (PK) — BIGINT — Foreign key → MESSAGE.message_id — NOT NULL
- sender_id (user_id(fk)) — BIGINT — Foreign key → MESSAGE.sender_id — NOT NULL
- room_id (pk) — BIGINT — Foreign key → MESSAGE.room_id — NOT NULL
MESSAGE (메세지)
- message_id (PK) — BIGINT — Primary key — NOT NULL
- sender_id (user_id(fk)) — BIGINT — Primary key — NOT NULL
- room_id (pk) — BIGINT — Foreign key → Chat_room.room_id — NOT NULL
- content (내용) — TEXT
- created_at (보낸 시간) — DATETIME
- is_deleted (삭제 여부) — BOOLEAN