* add show_complete_foreign_keys as setting

* test for show_complete_foreign_keys setting