

Accounts is the main table with foreign key in all other tables, so when a customer delete an account it freeze everything. Any suggestions?
EXPLAIN QUERY PLAN on all tablesPRAGMA index_list('TableName'); and when I did a simple query on the table with EXPLAIN QUERY PLAN select * from TableName where UserId = 'abc' it reported use of SCAN (full table scan). So I think that confirms to me that the FK indexes are not created automatically. Thank you for highlighting this, as I'll need to revisit the schema's for my SQLite apps.
Delete from Accounts where account_id = ?AccountsPRAGMA index_list('TableName');EXPLAIN QUERY PLAN select * from TableName where UserId = 'abc'