There is a list of orders in the order table,

I need to create an invoice with multiple orders, how the table should be designed to do this?

Here what I have come up with as example:

order table
- order_id
- item_name
- cost
- order_date


invoice table
- invoice_id (PK)
- invoice_no
- invoice_date
- period_start_date
- period_end_date
- status (Paid, Unpaid, etc)


invoice_order
- invoice_order_id (PK)
- invoice_id (FK)
- order_id (FK)

Is invoice_order table necessarry?

I could add invoice_id (FK) field in the order_table instead. The "order. invoice_id" would be updated when I have added a row in the invoice table.