Data engineering·Governance, privacy and meaning
there is one table everyone agrees is the answer for orders, and the other four are explicitly labelled as derived or deprecated.
Canonical dataset
Also calledsingle source of truth, SSOT, golden dataset
One agreed authoritative dataset for a given concept, with everything else derived from it. It is easy to say and organisationally difficult, because the competing copies usually exist for good local reasons and removing one costs somebody their workflow. The achievable version is not one table but one lineage root plus a clear statement of which derivations are sanctioned.