Hello!

I need to store and manage some data into an SQLite-Database:

- Customers
- Articles
- Invoices

So far I created two QSqlTableModels for Customers and Articles as they are straight forward. I thought of a QSqlRelationalTableModel for the invoices to share the customers and the articles.
But I am not really sure how to store the invoices and their children, the invoice entries (position, quantity, article name, price,...)

Is it common in this case to create a new table for each invoice, and just fill it with the entries? This looks a bit like overkill to me, but would also be straight forward. Well, I have no idea how else this could be accomplished using a database.
Can SQL tables have child-tables, like e.g. QStandardItems can?

Kind regards,
HomeR