You do know, that you can create more than one table in SQLite and have references from one to another? Even recursive references work