SQLite Forum

3.31.1: create table with multiple primary key columns
Login
Not only, as Keyth already explained, this only postpones the FK check to  
commit-time, instead of insert-time, `DEFERRABLE INITIALLY DEFERRED` is  
SQLite default **and** only supported mode, unlike most databases.

*(Well, putting aside the fact FKs are never active by default,  
and one must explicitly turn them ON when opening a connection.)*