SimpleBoard

Tables (3)

Untitled (board)

  • Key (id) — BIGINT(32) — Primary key — NOT NULL
  • Field (board_name) — VARCHAR(100)
  • Field2 (status) — VARCHAR(100)

Untitled (post)

  • Key (id) — BIGINT(32) — Primary key — NOT NULL
  • Key (board_id) — BIGINT(32) — Foreign key → Untitled.Key — NOT NULL
  • Field (user_name) — VARCHAR(50)
  • Field (password) — VARCHAR(4)
  • Field (email) — VARCHAR(100)
  • Field (status) — VARCHAR(50)
  • Field (title) — VARCHAR(100)
  • Field (content) — TEXT
  • Field (posted_at) — DATETIME

Untitled (reply)

  • Key (id) — BIGINT(32) — Primary key — NOT NULL
  • Key (post_id) — BIGINT(32) — Foreign key → Untitled.Key — NOT NULL
  • Field (user_name) — VARCHAR(50)
  • Field (password) — VARCHAR(50)
  • Field (title) — VARCHAR(100)
  • Field (content) — TEXT
  • Field (replied_at) — DATETIME