post

Tables (4)

Comment (comment)

  • ID (id) — Long — Primary key — NOT NULL
  • Content (content) — String
  • Likes (likes) — Long
  • Author (author) — String
  • Nickname (nickname) — String — Foreign key → User.Nickname
  • PostId (postId) — Long — Foreign key → Post.ID — NOT NULL

Copy Of Comment (CopyOfcomment)

  • ID (id) — Long — Primary key — NOT NULL
  • Likes (likes) — Long
  • Author (author) — String
  • Nickname (nickname) — String — Foreign key → User.Nickname
  • CommentId (commentId) — Long — Foreign key → Comment.ID — NOT NULL

Post (post)

  • ID (id) — Long — Primary key — NOT NULL
  • Title (title) — String
  • Content (content) — String
  • Author (author) — String
  • ImgUrl (imgUrl) — String
  • Likes (likes) — Long
  • Nickname (nickname) — String — Foreign key → User.Nickname

User (user)

  • Nickname (nickname) — String — Primary key
  • Password (password) — String
  • ID (id) — Long