Normally you use intermediate tables for solving this kind of needs. The main idea of relational databases is "no duplicated data" :-)rph wrote:Orders don't get dynamically updated nor would you want them to. They're historical information. What a customer changes their address to today has no bearing on the address you shipped their order to six months ago. This is the way all modern ecommerce platforms operate.evimail wrote:In OpenCart you have customer name and contact data in two tables: Customer and Order. What happens if you need to change the e-mail - have to change it in at in two places making at least two update queries.
I doubt that ALL modern e-commerce platforms use OpenCart approach :-P