sprint-mission

Tables (7)

binary_content

  • id — uuid — Primary key — NOT NULL
  • 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

channel

  • id — uuid — Primary key — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz
  • name — varchar(100)
  • description — varchar(500)
  • type — varchar(10) — NOT NULL

message

  • id — uuid — Primary key — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz
  • content — text
  • author_id — uuid — Foreign key → user.id
  • channel_id — uuid — Foreign key → channel.id — NOT NULL

message_attachment

  • attachment_id — uuid — Foreign key → binary_content.id — NOT NULL
  • message_id — uuid — Foreign key → message.id — NOT NULL

read_status

  • id — uuid — Primary key — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz
  • last_read_at — timestamptz — NOT NULL
  • channel_id — uuid — Foreign key → channel.id — NOT NULL
  • user_id — uuid — Foreign key → user.id — NOT NULL

user

  • id — uuid — Primary key — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • username — varchar(50) — NOT NULL — unique
  • email — varchar(50) — NOT NULL — unique
  • password — varchar(60) — NOT NULL
  • profile_id — uuid — Foreign key → binary_content.id — NOT NULL

user_status

  • id — uuid — Primary key — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz
  • last_active_at — timestamptz — NOT NULL
  • user_id — uuid — Foreign key → user.id — NOT NULL