Mypost

Tables (4)

Comment (comment)

  • ReplyId (replyId) — Long — Primary key — NOT NULL
  • PostId (postId) — Long — Foreign key → Post.PostId — NOT NULL
  • Id (id) — Long — Foreign key → User.Id — NOT NULL
  • Reply (reply) — String — NOT NULL

Like (like)

  • LikeId (likeId) — Long — Primary key — NOT NULL

Post (post)

  • PostId (postId) — Long — Primary key — NOT NULL
  • Id (id) — Long — Foreign key → User.Id — NOT NULL
  • Title (title) — String — NOT NULL
  • Contents (contents) — String — NOT NULL
  • 작성날짜 (created_at) — datetime — NOT NULL
  • 수정날짜 (modified_at) — datetime — NOT NULL

User (user)

  • Id (id) — Long — Primary key — NOT NULL
  • Username (username) — String — NOT NULL
  • Password (password) — String — NOT NULL
  • Admin (role) — boolean — NOT NULL