Tobias Schlemmer wrote:
>
> Hello,
>
> while reading the database description I could not find an option to mark
> some names of a persen used to call the person. For example:
> My name is "Rudolf Tobias Schlemmer". But normally I'm called "Tobias".
> I'm registered as "Rudolf _Tobias_ Schlemmer". But if you want to get any
> Information about me trying to use "Rudolf T. Schlemmer" you wouldn't get any.
> In German "Tobias" is my "Rufname" and Rudolf is an additional name -- the
> name of my grandfather. If we go some some generations back, we find some
> entries like:
>
> Anna _Magdalena_ Martina _Margarete_ _Isolde_ Irgendwas
>
> with the given names "Anna Magdalena Martina Margarete Isolde" who was called
>
> Magdalena Margarete Isolde Irgendwas.
>
[snip]
This should be handled in the schema that we've got by using multiple
Name records per Person record. One Name record would be used to store
the person's "official" name, while additional Name records would store
the person's nicknames.
To use your examples above, each person in the database would have two
Name records. So, the Person and Name tables would look something
like...
PERSON
per_id
1
2
NAME
nam_id nam_per_id nam_given
nam_surname
1 1 Rudolf Tobias
Schlemmer
2 1 Tobias
Schlemmer
3 2 Anna Magdalena Martina Margarete Isolde
Irgendwas
4 2 Magdalena Margarete Isolde
Irgendwas
If we were to do a lookup by name on these records (and sorted the
results by surname then given name), we would see something like...
Surname Given Name Primary
Person
Irgendwas Anna Magdalena Martina Margarete Isolde 2
Irgendwas Magdalena Margarete Isolde * 2
Schlemmer Rudolf Tobias 1
Schlemmer Tobias * 1
Note that for this example, I've chosen to use the popular names as the
primary names, but this selection is entirely up to the user. Also, the
final product would probably display a different set of columns on the
right to identify the person, like the person's primary birth date or
other such identifying information.
Granted, this does tend to make the number of names listed on a
search-by-name results list a little large, but it allows the user to
input any number of variations on a name for any person in the
database. The nam_primary field will be used only to determine which
Name record is printed on reports that allow only one name output per
person, and the nam_note field can be used to contain any additional
information about the name and its usage among the family.
Perhaps the field nam_given should be renamed to something else like
nam_regular to avoid confusion? I had intended this field to contain
the part of a name that is neither surname, prefix (Mr., Mrs., Dr., etc)
nor postfix (Sr., Jr., III, etc). Allowing multiple name records per
person would enable the user to input every name that a person is/was
known by.
--
Sean Lamb --- [EMAIL PROTECTED] Software Engineer
while( ) { s/$badcode/$goodcode/g; }
"A day without laughter is a day wasted." -- Groucho Marx
_______________________________________________
Genes-devel mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/genes-devel
