jc2006 Posted January 5, 2007 Share Posted January 5, 2007 HiI have the following situation: user |m | |m car ----------wax m m The user has a many to many relationship to the "many to many relationship" of car and wax. I have tables of car, wax and user. I have a car_to_wax table that shows which waxes can be used for a given car. Is it possible to create another table, a user_car_wax table, that shows which waxes the user has actually used for certain cars? Wouldn't this entail a table with three primary keys? Is there another solution? Thanks a bunch in advance. Quote Link to comment Share on other sites More sharing options...
Barand Posted January 5, 2007 Share Posted January 5, 2007 It would be a table with 3 foreign keys. Its primary key could be (userid, carid, waxid) unless you wanted, say, dates on which the waxes were used by the user on the cars, in which case have an auto-incrementing record id. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.