Social Network Database
I'm building the database for my Social Networking Site project. My database has to hold informatio开发者_如何学Pythonn of many user accounts. Each user has a profile and the profile contains various information. The account owner should be able to set the privacy of each profile information (either private or public). I'm wondering how I should keep track of those privacy option for each profile detail. Is it a good design to have a table called Privacy whose columns are the details and the values are privacy options? Anyone could give me an idea on this? Thanks
User(ID, Name)
ProfileInfo(ID, Name, CanSetPrivate)
Profile(User_ID, Profile_ID, Value, IsPrivate)
精彩评论