Subtypes and status-dependent data: pure relational approach
Summary
The post demonstrates a pure relational approach to modeling subtypes using constant columns to enforce status-specific data for images. It provides a concrete three-table schema (images, invalid_images, detected_animals), sample queries, and discusses the Make Invalid States Unrepresentable principle, along with references for further study.