Tuesday, January 29, 2008
One of the open source packages we have used for custom development work in the past is OSCommerce. Being a visual learner it helps me to be able to "see" the schema. Here's a graphic I made with the help of DB Designer 4. I took a stab at filling in some of the relations, though they aren't complete nor are they completely accurate. Also ignore the tables in the upper left starting with fg, those are some views we wrote that got included in the schema. DB Designer 4 seems to no longer be developed or supported. MySQL workbench provides similar functionality, but the free version doesn't let you print or save the schema as an image. Unfortunately db designer 4 doesn't export at super high resolution, so if you want higher resolution I suggest downloading mysql workbench and giving it a go.
We routinely come across things that we have to figure out (unfortunately omniscience wasn't in stock when we were ordering office supplies) and we often say, we should really post that somewhere that google could index it so other people don't have to duplicate work. This is a first shot at doing that. Using a blog for this was inspired by a friend whose dev blog is here: dev.notoptimal.net (and his iphoto2gmail project here: iphoto2gmail.notoptimal.net)