Both table b and table c should be recognized as referencing table a. The shorthand syntax (omitting the referenced column) is equivalent to specifying the primary key column.

Sqlite remove/change/rename column don't pass foreign key references along in the new table #7078 New issue Closed #12420 ...