Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
2 votes
Accepted

Foreign Key Error in SQLite3 CREATE TABLE Command

You need also the column PersonID in the table conversations, as it the value of the reference and the Foreign keyis only a constraint for the column PersonID. It indicates that you can add only ...
nbk's user avatar
  • 8,423
1 vote

A foreign key that references a table and another to reference the parent table (what's the alternative)

The simplest solution is to remove ti_id from your user_permissions table. If user_permissions references some tim_id's, and each respective trackable_item_metrics references exactly one ti_id, so you ...
Bill Karwin's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible