I have a design issue I can't seem to get my head around. Say I have a table full of users with certain fields containing information they can share with or hide from other users.
users_table ---------- userid thing_to_share_or_not_1 thing_to_share_or_not_2 thing_to_share_or_not_3 ... There are a lot of "things" The default is to hide. What is the most efficient way to denote that a user is sharing specific info with another user? I immediately thought about a joining table sharing_table ---------- userid_of_sharer userid_of_user_being_shared_with I can't figure out how to join what specific piece of information is being shared. I thought about including a varchar in the share table with the name of the shared field in it, but, while doable, seems a clumsy hack. What obvious thing am I overlooking? Todd Ashworth Janty Networks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
