first

Tables (3)

Comment (comment)

  • Comment Id (comment_id) — INT(11) — Primary key — NOT NULL
  • Post Id (post_id) — INT(11) — Foreign key → Post.Post Id — NOT NULL
  • User Id (user_id) — INT(11) — Foreign key → Post.User Id — NOT NULL
  • User Id (user_id2) — INT(11) — Foreign key → Users.User Id — NOT NULL
  • Content (content) — VARCHAR(255)
  • Create At (createdAt) — CHAR(8)
  • Modified At (modifiedAt) — CHAR(8)

Post (post)

  • Post Id (post_id) — INT(11) — Primary key — NOT NULL
  • User Id (user_id) — INT(11) — Foreign key → Users.User Id — NOT NULL
  • Title (title) — VARCHAR(255)
  • Content (content) — VARCHAR(255)
  • Create At (createdAt) — CHAR(8)
  • Modified At (modifiedAt) — CHAR(8)

Users (users)

  • User Id (user_id) — INT(11) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Password (password) — VARCHAR(255)