I've got a table of, let's say, widgets. Each has a unique id (primary key) and a few other attributes such as
widgetid (unique, number)
BUT, for each widget, I also want to list other widgets (that are listed in the same table) that are similar to each widget, and list them by their unique id.
So, would I create a foreign key to another table of related widgets, or just have additional fields in this table for
and have the widgetids listed in those fields?
Seems their must be a better way to do this.