in reply to Class::DBI and - possibly - complex data structures

Just curious about the data modeling of your tables ...

Why not define table person_name like so ...
person       mediumint unsigned not null, /* references 'person' */
name    mediumint unsigned not null, /* references 'name' */
seq     mediumint unsigned not null  /* determines firstname middlenam
+e lastname */

[download]

In Section Seekers of Perl Wisdom