webminiproject

Tables (4)

Comment (댓글)

  • Long (Id) — Primary key — NOT NULL
  • String (nickname)
  • String (content)
  • Long (post_id) — Foreign key → Post.Long — NOT NULL

Post (게시글)

  • Long (Id) — Primary key — NOT NULL
  • String (title)
  • String (content)
  • int (price)
  • String (category)
  • Boolean (isSold)
  • String (location)
  • Long (user_Id) — Foreign key → User.Long — NOT NULL

User (회원)

  • Long (Id) — Primary key — NOT NULL
  • String (username)
  • String (password)
  • String (nickname)
  • String (userCategory)

image (사진)

  • Long (Id) — Primary key — NOT NULL
  • String (image)
  • Long (post_Id) — Foreign key → Post.Long — NOT NULL