Refactoring Databases - Evolutionary Database Design

Replace Type Code With Property Flags

Replace a code column with individual property flags, usually implemented as Boolean columns, within the same table column.



Example

Replace Type Code With Property Flags Example

For more information see page 196 of Database Refactoring