使用外键创建表的SQLite语法

I'm creating a table with foreign key references. I'm wondering about the required syntax. Mostly I've seen the following (from I'm creating a table with foreign key reference