The primary key field will be followed by any foreign keys in the table. The name of foreign key fields begins with the 1^st, 2^nd and 3^rd characters identifying the table name. The 4^th, 5^th, & 6^th characters in the field name will identify the table to which the foreign key relates.

AndMunID – foreign key in the Annual Data table pointing to the Municipalities table

DedDehID – foreign key in the Debt Detail table pointing to the Debt Header table.

Figure 6: Screen shot showing data tables in the NaviCat MySQL control panel

Figure 7: Screen shot of the m_municiplaities table in the NaviCat MySQL control panel

Figure 8: screen shot showing field relationships in a data model