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