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) — ?