I would build it like this: - tbl_users (userID etc) - tbl_user_things (thing id so you can add extra "things" without changing the DB) - tbl_user_join_thing (userID, thingID, setting (boolean 1/0) and a optional toShareWithUserID)
Hope this helps 2014-03-21 1:46 GMT+01:00 Jerry Milo Johnson <jmi...@gmail.com>: > > 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:358058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
