Board

Tables (5)

Untitled (post)

  • post_id — NOT NULL — Primary key — NOT NULL
  • category_id — NOT NULL — Foreign key → Untitled.category_id — NOT NULL
  • Key (user_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Key (content_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — NOT NULL
  • Field (created_date) — NULL
  • Field (updated_date) — NULL
  • Field (deleted_date) — NULL
  • Field (likes) — 0
  • Field (hates) — 0
  • Field (views) — 0
  • Field (enabled) — NOT NULL

Untitled (user)

  • Key (user_id) — NOT NULL — Primary key — NOT NULL
  • Field (email) — NOT NULL
  • Field (password) — NOT NULL
  • Field (profile_picture) — NOT NULL
  • Field (name) — NOT NULL
  • Field (role) — NOT NULL
  • Field (created_date) — NOT NULL
  • Field (last_modified_date)
  • Field (deleted_date)
  • Field (enabled) — NOT NULL

Untitled (category)

  • category_id — NOT NULL — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (enabled) — NOT NULL

Untitled (reply)

  • Key (reply_id) — NOT NULL — Primary key — NOT NULL
  • post_id — NOT NULL — Foreign key → Untitled.post_id — NOT NULL
  • Key (user_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
  • Field (comment) — NOT NULL
  • Field (created_date) — NOT NULL
  • Field (updated_date) — NULL
  • Field (deleted_date) — NULL
  • Field (likes) — 0
  • Field (hates) — 0
  • Field (enabled) — NOT NULL

Untitled (content)

  • Key (content_id) — NOT NULL — Primary key — NOT NULL
  • Field (content) — NOT NULL