2👍
✅
(I’ll fix the duplicate “school” later.)
Actually, that is your problem. The second definition of school as a foreign key will require it to be an integer, thus the error.
You can confirm this by dumping the schema of your table with
sqlite3 <database-file> ‘.schema wkw2_Lawyer’
Source:stackexchange.com