Team6

Tables (4)

Comment

  • id (commentId) — Long — Primary key — NOT NULL
  • id (postId) — Long — Foreign key → Post.id — NOT NULL
  • id (userId) — Long — Foreign key → User.id — NOT NULL
  • comments (comment_comments) — String — NOT NULL

Like

  • id (likeId) — Long — Primary key — NOT NULL
  • id (userId) — Long — Foreign key → User.id — NOT NULL
  • id (postId) — Long — Foreign key → Post.id
  • id (commentId) — Long — Foreign key → Comment.id

Post

  • id (postId) — Long — Primary key — NOT NULL
  • id (userId) — Long — Foreign key → User.id — NOT NULL
  • author (post_author) — String — NOT NULL
  • contents (post_contents) — String — NOT NULL
  • imageurl (post_imageurl) — String

User

  • id (userId) — Long — Primary key — NOT NULL
  • username (user_username) — String — NOT NULL
  • password (user_password) — String — NOT NULL
  • profile (user_profileurl) — String