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