discodeit

Tables (7)

Copy Of Copy Of Untitled (read_statuses)

  • Key (id) — uuid — Primary key — NOT NULL
  • Key (user_id) — uuid — Foreign key → Untitled.Key — NOT NULL — UK(user_id, channel_id), ON DELETE CASCADE
  • Key (channel_id) — uuid — Foreign key → Untitled.Key — NOT NULL — UK(user_id, channel_id), ON DELETE CASCADE
  • Field (created_at) — timestamptz — NOT NULL
  • Field2 (updated_at) — timestamptz
  • Field (last_active_at) — timestamptz — NOT NULL

Copy Of Untitled (user_statuses)

  • Key (id) — uuid — Primary key — NOT NULL
  • Key (user_id) — uuid — Foreign key → Untitled.Key — NOT NULL — UK, ON DELETE CASCADE
  • Field (created_at) — timestamptz — NOT NULL
  • Field2 (updated_at) — timestamptz

Untitled (users)

  • Key (id) — uuid — Primary key — NOT NULL
  • Key (profile_id) — uuid — Foreign key → Untitled.Key — ON DELETE SET NULL
  • Field (created_at) — timestampz — NOT NULL
  • Field (updated_at) — timestampz
  • Field (username) — varchar(50) — NOT NULL — UK
  • Field (email) — varchar(100) — NOT NULL — UK
  • Field (password) — varchar(60) — NOT NULL

Untitled (channels)

  • Key (id) — uuid — Primary key — NOT NULL
  • Field (created_at) — timestampz — NOT NULL
  • Field (updated_at) — timestampz
  • Field (name) — varchar(100)
  • Field (description) — varchar(500)
  • Field (type) — varchar(10) — NOT NULL — ENUM(PUBLIC, PRIVATE)

Untitled (binary_contents)

  • Key (id) — uuid — Primary key — NOT NULL
  • Field (created_at) — timestamptz — NOT NULL
  • Field (file_name) — varchar(255) — NOT NULL
  • Field (size) — bigint — NOT NULL
  • Field (content_type) — varchar(100) — NOT NULL
  • Field (bytes) — bytea — NOT NULL

Untitled (message_attachments)

  • Key (message_id) — uuid — Foreign key → Untitled2.Key — ON DELETE CASCADE
  • Key (attachment_id) — uuid — Foreign key → Untitled.Key — ON DELETE CASCADE

Untitled2 (messages)

  • Key (id) — uuid — Primary key — NOT NULL
  • Key (channel_id) — uuid — Foreign key → Untitled.Key — NOT NULL — ON DELETE CASCADE
  • Key (author_id) — uuid — Foreign key → Untitled.Key — ON DELETE SET NULL
  • Field (created_at) — timestampz — NOT NULL
  • Field (updated_at) — timestampz
  • Field (content) — text