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