Steve Maddison wrote:
Richard wrote:
Well, I don't have time to invest in reverse
engineering someone's
schema in order to do something with it. ?The bar for contributing is
pretty high right now. ?I'm happy to collaborate with someone who has
put in the time to figure out the schema and now can explain it to me
so we can collaborate on some code for a community site that allows
expansion without central authority.
I'll have a stab at this over the next few days. Picking out the
foreign keys shouldn't be too difficult, but I'm not planning to go
into great detail, just enough to understand the current situation.
Here's what I make of it, based purely on the table definitions as yet.
http://sources.cosam.org/svn/manx/manx_dm_orig.pdf
There's a Visio file in the same directory. A lot of it is pretty
self-explanatory, but that PUBHISTORY table could use some
deciphering. I'll look into that next.
I don't want to bore the entire list with the gory details. If this
starts getting much more involved, it may be appreciated if the
discussion were to continue elsewhere...
--
Steve Maddison
http://www.cosam.org/