如何向现有的SQLite表添加外键?

I have the following table:

我有以下表格:

CREATE TABLE child( 
  id INTEGER PRIMARY KEY, 
  parent_id INTEGER, 
  description TEXT);
CREATE