Prefer two boolean columns to one column which contains combinations

This is part of the Semicolon&Sons Code Diary - consisting of lessons learned on the job. You're in the data category.

Last Updated: 2021-05-15

The spec for the job marketplate had a column time_commitment with values part_time, full_time, and both. This was awkward for building data filters and necessitated refactoring.

I settled on splitting it up and having one col part_time and another full_time

Lesson

Never store the possibility of both A & B in a single column. Instead create two distinct columns for both.