A customer disputed a refund on our marketplace. The orders row said status = 'completed' and the total was correct. Then the questions arrived. Was the order ever cancelled and reopened? Who changed the shipping address, and was it before or after payment? Did support or the customer trigger the refund? Our database could answer none of them. Every value in it was correct, and it still could not explain what had happened. That is a data modeling problem, not a query problem. A table that only s...