Cohi-Chat
Tables (4)
chat_room
- id — UUID — Primary key — NOT NULL
- host_id — UUID — NOT NULL
- guest_id — UUID — NOT NULL
- last_reservation_id — UUID
- last_reservation_end_at — TIMESTAMPTZ
- deleted_at — TIMESTAMPTZ
- updated_at — TIMESTAMPTZ — NOT NULL
event_stream
- event_id — UUID — Primary key — NOT NULL
- room_id — UUID — Foreign key → chat_room.id — NOT NULL
- event_type — VARCHAR(30) — NOT NULL
- payload — JSONB
message
- id — UUID — Primary key — NOT NULL
- room_id — UUID — Foreign key → chat_room.id — NOT NULL
- sender_id — UUID
- message_type — VARCHAR(30) — NOT NULL
- content — TEXT
- payload — JSONB
room_member
- id — UUID — Primary key — NOT NULL
- room_id — UUID — Foreign key → chat_room.id — NOT NULL
- member_id — UUID — NOT NULL
- role — VARCHAR(20) — NOT NULL
- last_read_message_id — UUID — Foreign key → message.id