chat
Tables (4)
chat_room
- id — UUID — Primary key — NOT NULL
- type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- external_ref_type — VARCHAR(50)
- external_ref_id — UUID
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ
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 — VARCHAR(2000)
- payload — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
notification
- id — UUID — Primary key — NOT NULL
- receiver_id — UUID — NOT NULL
- notification_type — VARCHAR(50) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — VARCHAR(500) — NOT NULL
- payload — JSONB
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
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
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- deleted_at — TIMESTAMPTZ