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