third field, id of item to be shared. (id in this case being a unique column name)?
On Thu, Mar 20, 2014 at 8:33 PM, PT <cft...@gmail.com> wrote: > > 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:358057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm