I've handled similar cases in the past by using another table, but I notice postgres has arrays and thought this might be a better way to handle it.
I've never had much luck getting an array (with or without foreign keys) to work in Postgres, but to be honest I haven't tried that hard as my above flowchart might imply.--Vive le Montréal libre.
... google returns no results for "gallery of bad database design" or "museum of bad database design" and "bad database design" returns too many results, but "worst database design" provide a few nice gripes. It is a shame that "evil database design" is also empty, so all I could do was return to the Fabian Pascal Vociferous Ignorance Hall of Shame.
Great technique and superb execution!!!
"Are Linux chicks worth it?" fencepost