I'm setting up a little database to allow multiple users
to track their online auctions.
One of my requirements is that each user be able to
create their own "groups" to classify their auctions.
My problem is that one way of planning this creates
a "triangle". Here are the tables (in brief) as an example
so you can see the relations
What you can see is that both auction tables
are related to the user table, and the two auction
tables are related.
This seems somehow wrong, but I am unclear as
to how I go about fixing this. Actually I do have
an idea... perhaps the right idea so what do you
think about this:
In this way, I can relate the auction to the user through
the auction_group. Seems reasonable...
Well, I'd appreciate any comments on this.