What problem does it solve? Database tables often accumulate anti-patterns like proliferating status columns, Boolean flag explosions, and NULL-based implicit states that lead to invalid data and unmaintainable schemas. This Skill provides a structured review framework and checklist to catch these issues before they reach production. ## Core Features & Use Cases - Five-Step Status Design Framework: Enumerate events, separate resources from events, define state transition diagrams, isolate external codes, and manage external classification values with their meanings. - Anti-Pattern Detection: Identifies Boolean flag proliferation, multiple status columns in one table, and NULL-based status representation, then proposes concrete alternative DDL. - Review Checklist: Provides an eight-point checklist for auditing existing schemas and new migration proposals. - Use Case: When asked to add payment_status and shipping_status columns to an orders table, the Skill flags the status-column sprawl anti-pattern and proposes separating payment and shipping lifecycles into dedicated event tables with explicit transition constraints. ## Quick Start Ask the AI to review your table design or migration for status management issues, for example by requesting a design review of an orders table that tracks payment and shipping states.
