discodeit

Tables (7)

binary_contents

  • id — SERIAL
  • 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 — SERIAL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz
  • name — varchar(100)
  • description — varchar(500)
  • type — varchar(10) — NOT NULL

message_attachments

  • id — SERIAL
  • message_id — INTEGER
  • attachment_id — INTEGER

messages

  • id — SERIAL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz
  • content — text
  • author_id — INTEGER — NOT NULL
  • channel_id — INTEGER

read_statuses

  • id — SERIAL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz
  • user_id — INTEGER — NOT NULL
  • channel_id — INTEGER — NOT NULL
  • last_read_at — timestamptz — NOT NULL

user_statuses

  • id — SERIAL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz
  • user_id — INTEGER — NOT NULL
  • last_active_at — timestamptz — NOT NULL

users

  • id — SERIAL
  • 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 — INTEGER