Online Community

Tables (3)

Board (board)

  • Board Id (id) — BIGINT — Primary key — NOT NULL
  • Board Name (name) — VARCHAR(50)
  • Board Description (description) — VARCHAR(255)

Post (post)

  • Post Id (id) — BIGINT — Primary key — NOT NULL
  • Post Title (title) — VARCHAR(50)
  • Post Content (content) — VARCHAR(255)
  • Post Create Date (created_at) — DATETIME
  • Post Update Date (updated_at) — DATETIME
  • Post Delete Date (deleted_at) — DATETIME
  • Post Views (view_count) — BIGINT
  • Post Like (like_count) — BIGINT

Untitled