By the way,

I'm using INNODB, and Firstname, Lastname and Birthdate is foreign keys in Visit and primary keys in person.

id in Visit is primary key.

(I know that it's not sutch a good idea to use this primary key in person, but i must use it anyway)