BOOLEAN for true/false

Boolean Best Practices Choosing the right type also has real storage consequences at scale. Name boolean columns with a clear prefix like is_, has_, or can_ so readers immediately know the column holds a true/false value without reading documentation.