How to create Foreign Key in SQLite via Framework bottle.py?

Question

Python

I am creating a relational database where there is a Users table and a Todotable table, and I get an error when key bindings (foreign key), here is the actual code:
class TODOTABLE:
@classmethod
def init(self):
conn = sqlite3.connect('test.db ')
cursor = conn.cursor()
a = "select name from sqlite_master where type='table' and name='TODOTABLE'"
result = cursor.execute(a).fetchone()
if not result:
a = """
create table TODOTABLE(
id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
text char(100),
author char(20),
datechar,
user_id INTEGER foreign key(user_id) references User(id)
)"""
cursor.execute(a)
conn.commit()
print("table for TODOTABLE created")
and here is the actual error:
cursor.execute(a)
sqlite3. OperationalError: near "foreign": syntax error

Answer 1

isn't it:
a ="""... user_id INTEGER,
FOREIGN KEY....
"""
?