board

Tables (4)

Board (board)

  • Key (id) — BIG INT — Primary key — NOT NULL
  • Key (user_id) — BIG INT — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — VARCHAR — NOT NULL
  • Field (description) — VARCHAR — NOT NULL
  • Field (like_count) — BIG INT — NOT NULL

Untitled (comment)

  • Key (id) — BIG INT — Primary key — NOT NULL
  • Key (board_id) — BIG INT — Foreign key → Board.Key — NOT NULL
  • Key (user_id) — BIG INT — Foreign key → Untitled.Key — NOT NULL
  • Field (description) — VARCHAR — NOT NULL

Untitled (user)

  • Key (id) — BIG INT — Primary key — NOT NULL
  • Field (username) — VARCHAR — NOT NULL
  • Field (password) — VARCHAR — NOT NULL

Untitled (role)

  • Key (id) — BIG INT — Foreign key → Untitled.Key — NOT NULL
  • Field (role) — VARCHAR — NOT NULL