sql - Flutter sqflite relationships. Get length of a table and set that to column of other table

Question

I have a table called boxes and a table called words. Every word has a box id column that specifies the word is in which box. Every box has a length column. Now I want the box length column value should be equal to the length of words that box id is equal to the box id. I tried to use Foreign key in sqflite but I'm unable to do this.

question from:https://stackoverflow.com/questions/66068808/flutter-sqflite-relationships-get-length-of-a-table-and-set-that-to-column-of-o

Answer 1

Waitting for answers