How to Model Approval Workflows in a Database

How to Model Approval Workflows in a Database

How to Model Approval Workflows in a Database Without Boolean Chaos A supplier application has been approved. Then its bank details change. Is the supplier still approved? The answer sounds like a business-policy question, but it quickly becomes a database design...
Database Design: How Schema Choices Shape Real Products

Database Design: How Schema Choices Shape Real Products

The Schema Is Where Your Product Makes Its Promises A database does not merely store what your application has already decided. It decides what your application is allowed to believe. That sounds dramatic until a simple product feature turns into a week of awkward...