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