This article touches on something I’ve always wondered: how do I determine whether to add a BOOLEAN column to a table or create a new table instead? For all ta

This article touches on something I’ve always wondered: how do I determine whether to add a BOOLEAN column to a table or create a new table instead? For all tables containing a BOOLEAN column it’s always possible to simply split this table into two separate tables with the same columns, where the name of the table signals whether the factored-out BOOLEAN column would be TRUE or FALSE. My gut instinct says it’s cleaner to have two separate tables, but I’ve never found a definite answer.