test

Tables (8)

Copy Of user_statuses (CopyOfuser_statuses)

  • id — UUID — Primary key
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • last_active_at — TIMESTAMPTZ — NOT NULL

binary_contents

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • size — BIGINT — NOT NULL
  • content_type — VARCHAR(100) — NOT NULL
  • bytes — BYTEA — NOT NULL

channels

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ
  • name — VARCHAR(100)
  • description — VARCHAR(500)
  • type — VARCHAR(10) — NOT NULL

message_attachments

  • message_id — UUID — Foreign key → messages.id — NOT NULL
  • attachment_id — UUID — Foreign key → binary_contents.id — NOT NULL

messages

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ
  • content — TEXT
  • channel_id — UUID — Foreign key → channels.id — NOT NULL
  • author_id — UUID — Foreign key → users.id

read_statuses

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • channel_id — UUID — Foreign key → channels.id — NOT NULL
  • last_read_at — TIMESTAMPTZ — NOT NULL

user_statuses

  • id — UUID — Primary key
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • last_active_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(60) — NOT NULL
  • profile_id — UUID — Foreign key → binary_contents.id