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