chat
Tables (4)
chat_member (Untitled3)
- room_id (Key) — Foreign key → chat_room.room_id — NOT NULL
- user_id (Key2) — Foreign key → user.user_id — NOT NULL
- joined_at (Field)
- last_read_at (Field2)
chat_message (Untitled4)
- message_id (Key) — Primary key — NOT NULL
- room_id (Key3) — Foreign key → chat_member.room_id — NOT NULL
- user_id (Key22) — Foreign key → chat_member.user_id — NOT NULL
- content (Field)
- sent_at (Field2)
- is_deleted (Field3)
chat_room (Untitled2)
- room_id (Key) — Primary key — NOT NULL
- is_group (Field)
- title (Field2)
- created_at (Field3)
user (Untitled)
- user_id (Key) — Primary key — NOT NULL