开发者

Bookmark Saving Database Design

开发者 https://www.devze.com 2023-03-12 19:37 出处:网络
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 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.

0

精彩评论

暂无评论...
验证码 换一张
取 消