Kezul

Tables (11)

Untitled (users)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field (username) — varchar — NOT NULL
  • Field2 (password) — varchar — NOT NULL
  • Field (email) — varchar — NOT NULL
  • Field (phone_number) — varchar — NOT NULL
  • Field2 (role) — varchar — NOT NULL

Untitled (attachments)

  • Key (id) — uuid — Primary key — NOT NULL
  • Key (user_id) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field (origin_filename) — varchar — NOT NULL
  • Field (saved_filename) — varchar — NOT NULL
  • Field (volume) — varchar — NOT NULL
  • Field (extension) — varchar — NOT NULL

Untitled (informations)

  • Key (id) — uuid — Primary key — NOT NULL
  • Key (user_id) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field (contents) — varchar — NOT NULL

Untitled (certifications)

  • Key (id) — uuid — Primary key — NOT NULL
  • Key (user_id) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar — NOT NULL

Untitled (programs)

  • Key (id) — uuid — Primary key — NOT NULL
  • Key (user_id) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar — NOT NULL
  • Field (contents) — varchar — NOT NULL

Untitled (posts)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (user_id) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field (age) — SMALLINT
  • Field (type) — varchar
  • Field (days) — varchar
  • Field (time) — varchar
  • Field (period) — varchar
  • Field (contents) — varchar
  • Field (athletic_career) — varchar

Untitled (types)

  • Key (id) — UUID — Primary key — NOT NULL
  • Field (name) — VARCHAR — NOT NULL

Untitled (post_types)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (post_id) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Key (type_id) — UUID — Foreign key → Untitled.Key — NOT NULL

Untitled (chat_rooms)

  • Key (id) — UUID — Primary key — NOT NULL

Untitled (participants)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (user_id) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Key (chatroom_id) — UUID — Foreign key → Untitled.Key — NOT NULL

Untitled (chat_messages)

  • Key (id) — UUID — Primary key — NOT NULL
  • Key (chatroom_id) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Key (sender) — UUID — Foreign key → Untitled.Key — NOT NULL
  • Field (read) — boolean — NOT NULL
  • Field2 (content) — varchar — NOT NULL