best practices in data modelling
77546Aug 29 2008 — edited Aug 29 2008Hello,
When creating an ER diagram do I include auditing fields such as created_by, created_date, changed_by, changed_date or is this only shown in the physical model? Also if I will be using history tables to track the changes to a record are these shown on the ER diagram or only on the physical model?
Thanks