The main foreign keys are for the layout (layout_id), and for the part name and part abbreviation displays (part_name_display_id and part_abbreviation_display_id) in the name_display table.