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