I have my table design as below
Quote --> Quote_Contact -->Quote_Contact_Detail -->Breakdown
A quote has multiple quote_contact, a quote_contact has multiple quote_contact_detail and a quote_contact_detail has one breakdown.
What i want to do is when either any data changes from one of the 4 tables, i want to make a copy of the row from quote with its concerned table rows from quote_contact and so on.
I've read somewhere that triggers can sort of do this, but examples that i have been seeing contain on update from one table. So my question is, Is there any way i can do a trigger on these 4 tables at once, or any other way i could do this preferably at database level.
Aucun commentaire:
Enregistrer un commentaire