Bookmark Saving Database Design
I am trying to come up with a database design that will be suitable for users to be able to save bookmarks along with tags (different tags for different users).
I'm also pretty unsure how I am going to let use开发者_如何学JAVArs have different titles for the same bookmark. Any good way of doing this?
This is what I have so far:
Bookmark {
BookmarkID
Title
URL
Source
}
BookmarkSaves {
BookmarkID
UserID
}
Tag {
TagID
Title
}
BookmarkTag {
BookmarkID
TagID
UserID
}
I'm also pretty unsure how I am going to let users have different titles for the same bookmark.
You do so by making the title part of your BookmarkSaves table.
精彩评论