[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