'TypeORM map array connection with seperate table

I'm using TypeORM in my NestJS backend to connect to a MySQL database.

I've come up with this diagram, where a Bill can have several Orders and a Order can have several Articles. Therefore, seperate mapping tables were created for these array connections. enter image description here

My Problem is, that i can't get this into code. All examples I find show such a mapping, where, for example, Order holds an array of Articles and Article holds a PK of Order. But that's not the case in my scheme.

  1. Question: Is my Scheme acceptable as it is, or do u have suggestions for improvement? For example, maybe it's not common for such a case to use seperate mapping tables to implement one to many connections..

  2. Question: Could you show me an example for Order and Article how to implement my scheme into code. This is what i got so far:

enter image description here enter image description here

Thanks in advance!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source