A foreign key should refer to a candidate key in some table. This is usually the primary key but may be a field (or list of fields) specified as UNIQUE.
You must have REFERENCE permission on the table being referenced.
|Specific to SQLite|
|Foreign key references are ignored. This problem does not arise.|