It's best practice to declare the foreign keys according to functional dependencies. E.g. if your other table is about salespeople, then its foreign key should refer to Salespeople.

In that case, the WITHOUT ROWID clause may be added to the table creation statement: create table Hens ( Name text primary key ) without rowid SQLite does, however, require a primary key. So if I ask ...