When architecting a transactional database or a data warehouse, it’s important not to forget about various types of technical columns.
![Towards Data Science](https://miro.medium.com/v2/resize:fill:48:48/1*CJe3891yB1A1mzMdqemkdg.jpeg)
Technical columns play a fundamental role in database design. They serve various purposes: from audit-related matters, via support in…