DEPth-Board

Tables (3)

Untitled (user)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (username) — varchar(50)
  • Field (password) — varchar(50)
  • Field (display_name) — varchar(50)
  • Field (role) — enum

Untitled (board)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (title) — varchar(255)
  • Field (contents) — varchar(255)
  • Field (create_date) — datetime

Untitled (user-board)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (board_id) — bigint — Foreign key → Untitled.Key — NOT NULL