I have an invoice table. I spend one more table called "offers".
If a customer says ok to the offer so the offer for that customer should become an invoice.
How can I copy all of the relevant tables?
First, I think about to handle the offers in the same table (invoice) and spent a field called "is_offer" to seperate the difference. But it is too complex now to handle that.
So I have decided to clone the invoice table and their structure of TOs and make an "offer".
Afterwards I will copy all the contents to the invoice table including the TOs of customer, products etc. to generate an invoice.
I hope, I could explain it as you can understand.