[Babase] Documentation and validation of GROUPS table
Karl O. Pinc
kop at meme.com
Tue Jan 30 12:04:25 EST 2007
Hi,
While working on the psion load program I got distracted
and finished the design and documentation and implementation
of the GROUPS table. Please review:
http://papio.biology.duke.edu/babase_system_html/ch03s01.html
http://papio.biology.duke.edu/babase_system_html/apds01.html
The ER diagrams have also had new columns added but that
doesn't really need review.
There are a couple of implications for the conversion
that should be worked out before we run another conversion.
Group 10.0 (Alone) has a Start column of 2000-07-01 but
there's data in CENSUS going back to 1976-02-12. The
Start column for this group should probably be adjusted
backwards to allow for the dates in CENSUS, otherwise
the conversion will reject the CENSUS rows.
Group 13.0 has no Start column but there are rows
in CENSUS. The problems are similar to the 10.0 group
so the solution likely is too.
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