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