SQLite Forum

Simply declare the FK with NO ACTION constraints?
```
CREATE TABLE t(
  id INTEGER PRIMARY KEY,
  parent INT REFERENCES p(id) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ...
  etc.
);
```
See: [CREATE TABLE - FK Clause](https://sqlite.org/syntax/foreign-key-clause.html)   
and: [Foreign Keys Actions](https://sqlite.org/foreignkeys.html#fk_actions)