Entity
Tables (9)
Category (category)
- categoryId (cotegory_id) — Long — Primary key — NOT NULL
- postCategoryList (post_category_list) — List<PostCategory>
- name — String
Chatroom (chatroom)
- chatroomId (chatroom_id) — Long — Primary key — NOT NULL
- createChatroomId (create_chatroom_id) — Long — Foreign key → CreateChatroom.createChatroomId — NOT NULL
- postId (post_id) — Long
- writeUserId (write_user_id) — Long
- replyUserId (reply_user_id) — Long
Comment (comment)
- commentId (comment_id) — Long — Primary key — NOT NULL
- postId (post_id) — Long — Foreign key → Post.postId — NOT NULL
- userId (user_id) — Long — Foreign key → User.userId — NOT NULL
- commentReplyList (comment_reply_list) — List<CommentReply>
- content — String
- likeNumber (like_number) — int
CommentReply (comment_reply)
- replyId (reply_id) — Long — Primary key — NOT NULL
- commentId (comment_id) — Long — Foreign key → Comment.commentId — NOT NULL
- userId (user_id) — Long — Foreign key → User.userId — NOT NULL
- content — String
- likeNumber (like_number) — int
CreateChatroom (create_chatroom)
- createChatroomId (create_chatroom_id) — Long — Primary key — NOT NULL
- postId (post_id2) — Long — Foreign key → Post.postId — NOT NULL
- replyUserId (reply_user_id) — Long — Foreign key → User.userId — NOT NULL
- writeUserId (write_user_id) — Long
Message (message)
- messageId (message_id) — Long — Primary key — NOT NULL
- chatroomId (chatroom_id) — Long — Foreign key → Chatroom.chatroomId — NOT NULL
- sendUserId (send_user_id) — Long
- content — String
Post (post)
- postId (post_id) — Long — Primary key — NOT NULL
- userId (user_id) — Long — Foreign key → User.userId — NOT NULL
- comments (coment_list) — List<Comment>
- title — String
- context — String
- likeNumber (like_number) — int
- hits — int
- tag (tag1~5) — String
- image (image1~5) — ?
PostCategory (post_category)
- postCategoryId (post_category_id) — Long — Primary key — NOT NULL
- postId (post_id) — Long
- categoryId (category_id) — Long
- postId (post_id2) — Long — Foreign key → Post.postId — NOT NULL
- categoryId (cotegory_id) — Long — Foreign key → Category.categoryId — NOT NULL
User (user)
- userId (user_id) — Long — Primary key — NOT NULL
- email — String
- passwor (password) — String
- name — String
- phoneNumber (phone_number) — Long
- age — int
- school — String
- gender — Gender(ENUM)
- proflieImage (proflie_image) — ?