preferredLanguage
preferredLanguage in person muß "short" aus language sein!
mysql> select distinct preferredLanguage from person;
+-------------------+
| preferredLanguage |
+-------------------+
| NULL |
| English |
| German |
| null |
| |
+-------------------+
5 rows in set (0,00 sec)
mysql> desc language;
+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| seq_id | int(11) | NO | PRI | NULL | auto_increment |
| short | varchar(5) | YES | | NULL | |
| language | varchar(50) | YES | | NULL | |
+----------+-------------+------+-----+---------+----------------+
3 rows in set (0,00 sec)
mysql>