SQLite Forum

Foreign key that is never enforced?
There’s nothing to do, since FKs are OFF by default...  
Just declare your FKs, and they will NOT be enforced.  
Unless the app you use explicitly turns them ON, on the connection.  
The fact that the FK pragma is NOT PERSISTENT in the DB file is very unfortunate,  
but exactly what you want in your case.