[Babase] MPI tables for experimentation
Karl O. Pinc
kop at meme.com
Thu Nov 8 16:05:38 EST 2007
Lacey,
I've got the MPI tables in a new schema, the devel
schema. It'll be easier for me to work with them
there as they change than in the sandbox.
So, the next thing is to get a little data into them
and try writing some queries. Then we maybe make
some views so the common queries are easier.
Note that in MPI_DATA the Decided, Helped, and Active
columns should be NULL when MPI_ACTS.Request is TRUE.
I've not got code in the db to enforce this yet,
just don't do it.
I'm starting to think that MPI_DATA.Decided should not
exist because according to what you've told me it's
entirely dependent upon the MPI_ACTS used. Let me
know if that's true.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list