Thanks for the info....I was too lazy to get it typed in, but I do plan
to eventually. As for the format I just wrote tables as I got to
them...when I do get it into access or some other program I will
rearrange the tables more cleanly. This was more of a brainstorm
exercise, so it was faster/easier to write than type. :)
After I get more feedback I will put it in a more conventional display
and add it to the FAQ.
On 23 Jul 2000, at 12:30, Paul Chamberlain wrote:
> 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]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
