Christie Walker wrote:
> I printed a mysqldump of the database and used it to draw up a
> diagram of the tables...
> http://www.vcandrews.org/freetrade.jpg
I guess expectations are really important. I laughed
when I went to your URL because I had my expectations
set on an MS-Access-like ER diagram. It'd be cool if
you plan on getting to that eventually.
Here's my contribution to the effort:
1. invoice has a link to user
2. invoice's link to fee is via invoice_fee
3. invoice_sku has a link to shipping
4. There's also a seed table, not connected anywhere
Also, I thought that I could make a point about the
organization that might help if you hadn't already
noticed. The only connection between the catalog tables
(department, department_item, item_item, relationship, sku,
sku_variation, variation, attribute, inventory) and the
rest of the diagram is through "sku" so that might help to
uncross some lines.
--
Paul Chamberlain, [EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
