Blog

Sample Blog ERD

Tables (5)

Comment (comment)

  • Comment Id (comment_id) — Long — Primary key — NOT NULL
  • Post Id (post_id) — Long — Foreign key → Post.Post Id — NOT NULL
  • User Id (user_id) — Long — Foreign key → PostUser.User Id — NOT NULL
  • Content (content) — String
  • Like (like) — int
  • Reply (reply) — List<Reply>
  • CreatedAt (createdAt) — String
  • ModifiedAt (modifiedAt) — String

Post (post)

  • Post Id (post_id) — Long — Primary key — NOT NULL
  • User Id (user_id) — Long — Foreign key → PostUser.User Id — NOT NULL
  • Title (title) — String
  • Content (content) — String
  • Like (like) — int
  • Comment (comment) — List<Comment>
  • CreateAt (createAt) — String
  • ModifiedAt (modifiedAt) — String

PostImage (postImage)

  • ImageId (Key) — Long — Primary key — NOT NULL
  • Post Id (post_id) — Long — Foreign key → Post.Post Id — NOT NULL
  • Url (url) — String

PostUser (postUser)

  • User Id (user_id) — Long — Primary key — NOT NULL
  • User Name (username) — String
  • Nick Name (nickname) — String
  • Password (password) — String
  • Created At (createdAt) — String

Reply (reply)

  • Reply Id (reply_id) — Long — Primary key — NOT NULL
  • User Id (user_id) — Long — Foreign key → PostUser.User Id — NOT NULL
  • Comment Id (comment_id) — Long — Foreign key → Comment.Comment Id — NOT NULL
  • Content (content) — String
  • Like (like) — int
  • CreatedAt (createdAt) — String
  • ModifiedAt (modifiedAt) — String