[ts-gen] database table relationships

[Bill Pippin]

An anonymous OSX user asks about the inter-relationships among the various
database tables:

> I am still trying to figure it out, and now working on a web  
> interface to the database. Do you have a diagram that explains how  
> the tables relate?

There is an out of data foreign key dependency graph figure in the
documentation.  If you want to look at it the doc sources, it's in part 2,
ch 8 or 9, caption "Database table foreign key dependencies", and produced
from doc/dot/foreign.dot; you can produce it separately by running, e.g.:

    dot -Tps doc/dot/foreign.dot > foreign.ps

It is, as I said, somewhat out of date, and I will be updating it later,
after some fixes to help mode, and order status updates.  When I say that
is out of date, I mean that it is not so much wrong as incomplete, so I'm
also including a copy of the figure as an attachment to this posting.

For now, note that most of the tables in sql/req, the required as-is tables,
are simple finite domains, what amounts to labelled enumerated types.  The
tables in sql/mod are core to the process of defining symbol relationships,
as I noted in a post earlier this month, while the order tables are best
understood by way of example, via the regression tests, and the insert
statements in sql/risk.sql .
 
Thanks,

Bill 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pdf
Size: 4051 bytes
Desc: foreign.pdf
Url : http://www.trading-shim.org/pipermail/ts-general/attachments/20070920/0f26c5ef/attachment.pdf