>I have been going through the data model as I have been putting together the
>dialogs.
>
>One thing I am confused about. Why are dates seperated in the DB into
>day,month,year? Why not just have a date field? DB level queries would be
>easier with just a date field and many DBs support dates are field types.
>
>One other thing (and I may just be missing something), 'state' and
>'continent' do not appear to be used anywhere. And I am not sure of the need
>for 'City', 'County' and 'Country'. Can we not dynamically build these from a
>'unique' query on the 'place' table at startup? Then use auto-completion in
the input boxes to avoid the need for abbreviations?
In genealogy, one often needs to use alternate calenders --
gregorian, julian. One also needs to store information about precison
(day, month not known).
Ideally, all places would be stored as longitude/latitude, since
cities expand and the borders of counties change. (I have an ancestor
who was supposedly born in Ithaca in 1803. Throughout the period
1800-40, that area has been included in three different counties.
Before circa 1815 Ithaca did not exist as such.) It would still be
useful to search specifically on county.
BTW, I think you can upload screenshots to sourceforge CVS. If not,
mail them to me, and I'll post them on my personal website
temporarily.
Jeremy
_______________________________________________
Genes-devel mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/mailman/listinfo/genes-devel
