[Babase] Merging JPSAMPS with FPSAMPS (and JPNEIGHBORS with FPNEIGHBORS)

Karl O. Pinc babase@www.eco.princeton.edu
Sat, 9 Oct 2004 00:14:19 -0500


I've long been unhappy with JPSAMPS and FPSAMPS and think
they should be merged as follows:

The new merged table is POINTS
Pntid  (to take place of Jpid and Fpid)
Type   (Kind of data collection, 'J' for juvenile or 'F' for female)
        (Honestly, I don't know this is necessary because it's obvious
         depending on whether there's a related FPOINTS row.
         I suppose it could sort of make queries easier, as you can
         do a AND points.type='F' in a WHERE instead of a AND EXISTS 
(SELECT
         1 FROM fpoints WHERE fpoints.pntid = points.pntid)  or do
         a AND points.type='J' in a WHERE instead of a AND NOT EXISTS
         (SELECT 1 FROM fpoints WHERE fpoints.pntid = points.pntid).
         Comment?)
Activity
Posture
Foodcode
Datetime  (subsumes Time)


New table with extra female stuff is FPOINTS.
(Exists if and only if data collection is on female.)
Pntid (same as on POINTS)
Kidcontact
Kidsuckle


New merged table is NEIGHBORS (to replace JPNEIGHBORS and
FPNEIGHBORS)
Pntid
Sname
Code
Unkid

Whaddya think?


Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein