Mypost
Tables (4)
Comment (comment)
- ReplyId (replyId) — Long — Primary key — NOT NULL
- PostId (postId) — Long — Foreign key → Post.PostId — NOT NULL
- Id (id) — Long — Foreign key → User.Id — NOT NULL
- Reply (reply) — String — NOT NULL
Like (like)
- LikeId (likeId) — Long — Primary key — NOT NULL
Post (post)
- PostId (postId) — Long — Primary key — NOT NULL
- Id (id) — Long — Foreign key → User.Id — NOT NULL
- Title (title) — String — NOT NULL
- Contents (contents) — String — NOT NULL
- 작성날짜 (created_at) — datetime — NOT NULL
- 수정날짜 (modified_at) — datetime — NOT NULL
User (user)
- Id (id) — Long — Primary key — NOT NULL
- Username (username) — String — NOT NULL
- Password (password) — String — NOT NULL
- Admin (role) — boolean — NOT NULL