[Babase] Storing male mature dates in the database

Karl O. Pinc babase@www.eco.princeton.edu
Sat, 20 Nov 2004 12:38:41 -0600


On 2004.11.20 02:31 Susan Alberts wrote:
> Works for me. The two columns would be called something like 
> "matured" and "mature by", right? I am not attached to any particular 
> name as long as it's clear. Thanks,

Uh, we want _one_ column, and a second 'type" column.  The
type would indicate 'matured-natal' or 'matured by'.

> 
> Susan
> 
>> Susan,
>> 
>> After meeting with folks here the concensus is that
>> it's a bad idea to store "we're sure they're mature
>> by this date" male maturity dates in a different
>> table from the "we watched these males reach
>> maturity" mature dates.  For lots of reasons,
>> mostly having to do with difficulty writing
>> queries to find all the adults if we have 2 tables, we think they
>> should go in the same table and be distinguished
>> by a 'kind of maturity date' flag.
>> 
>> However, we have to convince you before going forward.
>> 
>> Karl <kop@meme.com>
>> Free Software:  "You don't pay back, you pay forward."
>>                  -- Robert A. Heinlein
>> _______________________________________________
>> Babase mailing list
>> Babase@www.eco.princeton.edu
>> http://www.eco.princeton.edu/mailman/listinfo/babase
> 
> 
>-- 
> --------------------------------------------------------------------------------------------------------------------------------------
> Susan Alberts, Department of Biology, Duke University, Box 90338, 
> Durham NC 27708
> 919-660-7272 (phone), 919-660-7293 (FAX)
> _______________________________________________
> Babase mailing list
> Babase@www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase

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