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