Re: Xaraya database

Marcel van der Boom wrote in news:bh00v1$5s6$1-111RdWWlOxkOkXtL6OYfHgC/[email protected]:

> index.php?module=dynamicdata&type=util&func=meta
> 
> This will generate the bulk of the data for you.

Ah, useful as well, but it doesn't actually have much more than the 
table definitions themselves. (I just looked at them through a MySQL 
client to deduce some of the data I have.) Only really extra thing I see 
is some kind of form control definition.

And apart from table names, it doesn't seem to have anything that I have 
in my doc actually, most importantly not the purpose of each table, and 
relationships between tables. Both of which are the things you need to 
know when deciding whether to share tables between sites, or keep them 
separate.

Put differently, it's not so much the fields themselves that are 
important, but what conclusions can be drawn from them (and from 
Xaraya's behavior in maintaining the database).

> Might be a tad easier to maintain than manual documentation.

What I have is different information though. And organized not 
alphabetically by table name, but by purpose, which makes it easier to 
see the relationships.

> The sql file is basically on its way out. I was considering including
> a build target in our distribution program to automatically generate
> the sql file, but that is less than trivial.

Could you add that as a comment, please?


-- 
Marjolein Katsma
* Help with HomeSite/Studio: http://hshelp.com/
* Books for webmasters and webrookies: http://books.hshelp.com/
* Java Woman: http://javawoman.com/