Blog
Sample Blog ERD
Tables (5)
Comment (comment)
- Comment Id (comment_id) — Long — Primary key — NOT NULL
- Post Id (post_id) — Long — Foreign key → Post.Post Id — NOT NULL
- User Id (user_id) — Long — Foreign key → PostUser.User Id — NOT NULL
- Content (content) — String
- Like (like) — int
- Reply (reply) — List<Reply>
- CreatedAt (createdAt) — String
- ModifiedAt (modifiedAt) — String
Post (post)
- Post Id (post_id) — Long — Primary key — NOT NULL
- User Id (user_id) — Long — Foreign key → PostUser.User Id — NOT NULL
- Title (title) — String
- Content (content) — String
- Like (like) — int
- Comment (comment) — List<Comment>
- CreateAt (createAt) — String
- ModifiedAt (modifiedAt) — String
PostImage (postImage)
- ImageId (Key) — Long — Primary key — NOT NULL
- Post Id (post_id) — Long — Foreign key → Post.Post Id — NOT NULL
- Url (url) — String
PostUser (postUser)
- User Id (user_id) — Long — Primary key — NOT NULL
- User Name (username) — String
- Nick Name (nickname) — String
- Password (password) — String
- Created At (createdAt) — String
Reply (reply)
- Reply Id (reply_id) — Long — Primary key — NOT NULL
- User Id (user_id) — Long — Foreign key → PostUser.User Id — NOT NULL
- Comment Id (comment_id) — Long — Foreign key → Comment.Comment Id — NOT NULL
- Content (content) — String
- Like (like) — int
- CreatedAt (createdAt) — String
- ModifiedAt (modifiedAt) — String