discodeit
Tables (7)
BinaryContent (Untitled4)
- id (Key) — UUID — Primary key — NOT NULL — PK
- file_name (Field) — VARCHAR(255) — NOT NULL
- size (Field2) — BIGINT — NOT NULL
- content_type (Field3) — VARCHAR(100) — NOT NULL
- status (Field4) — VARCHAR(20) — NOT NULL
- created_at (Field5) — TIMESTAMP — NOT NULL
- updated_at (Field6) — TIMESTAMP
Channel (Untitled2)
- id (Key) — UUID — Primary key — NOT NULL — PK
- type (Field) — VARCHAR(10) — NOT NULL
- name (Field2) — VARCHAR(100)
- description (Field3) — VARCHAR(500)
- created_at (Field4) — TIMESTAMP — NOT NULL
- updated_at (Field5) — TIMESTAMP
Message (Untitled3)
- id (Key) — UUID — Primary key — NOT NULL — PK
- channel_id (Key2) — UUID — Foreign key → Channel.id — NOT NULL — FK
- user_id (Key3) — UUID — Foreign key → User.id — FK
- content (Field) — TEXT
- created_at (Field2) — TIMESTAMP — NOT NULL
- updated_at (Field3) — TIMESTAMP
MessageAttachment (Untitled5)
- message_id (Key) — UUID — Foreign key → Message.id — NOT NULL — PK, FK
- attachment_id (Key2) — UUID — Foreign key → BinaryContent.id — NOT NULL — PK, FK
- order_index (Field) — INT — NOT NULL — UNIQUE(message_id, order_index)
Notification (Untitled7)
- id (Key) — UUID — Primary key — NOT NULL — PK
- receiver_id (Key2) — UUID — Foreign key → User.id — NOT NULL — FK
- title (Field) — VARCHAR(100) — NOT NULL
- content (Field2) — VARCHAR(500) — NOT NULL
- checked (Field3) — BOOLEAN — NOT NULL
- created_at (Field4) — TIMESTAMP — NOT NULL
ReadStatus (Untitled6)
- id (Key) — UUID — Primary key — NOT NULL — PK
- user_id (Key2) — UUID — Foreign key → User.id — NOT NULL — FK
- channel_id (Key3) — UUID — Foreign key → Channel.id — NOT NULL — FK
- last_read_at (Field) — TIMESTAMP — NOT NULL
- notification_enabled (Field2) — BOOLEAN — NOT NULL
- created_at (Field3) — TIMESTAMP — NOT NULL
- updated_at (Field4) — TIMESTAMP
User (Untitled)
- id (Key) — UUID — Primary key — NOT NULL — PK
- username (Field) — VARCHAR(50) — NOT NULL — UNIQUE
- email (Field2) — VARCHAR(100) — NOT NULL — UNIQUE
- password (Field3) — VARCHAR(60) — NOT NULL
- role (Field4) — VARCHAR(20) — NOT NULL
- created_at (Field5) — TIMESTAMP — NOT NULL
- updated_at (Field6) — TIMESTAMP