I found the solution as I had to modify the request as below removing the FOREIGN KEY key-word.
CREATE TABLE IF NOT EXISTS project_assignee (id INTEGER PRIMARY KEY, person, role, status, project_id INTEGER REFERENCES project1 (id) )
Enter the destination URL
Or link to existing content