Relative Content

Tag Archive for sqlsqliteforeign-keys

fix Foreign Key constraint in this SQLite3 database?

I’m creating a table of people, and I want to record a table of productions, with the amount each person contributed to that production. So we have a table of share splits; each production earns an amount of shares referenced by a splitid, and each split id covers a number of rows saying how many shares each person gets.

fix Foreign Key constraint in this SQLite3 database?

I’m creating a table of people, and I want to record a table of productions, with the amount each person contributed to that production. So we have a table of share splits; each production earns an amount of shares referenced by a splitid, and each split id covers a number of rows saying how many shares each person gets.