Search code examples
databasetagsschemabookmarks

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 users 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
}
Solution

  • 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.