[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