Understanding Many-to-Many Relationships in SQLite: A Deep Dive into Foreign Key Modeling and Best Practices for Refactoring Existing Schemas