What is audit columns in Data Modeling?

audit columns is an important concept in Data Modeling. Understand its purpose, how it works, when to use it, and the tradeoffs it introduces before applying it in a production system.