This is part of the Semicolon&Sons Code Diary - consisting of lessons learned on the job. You're in the data category.
Last Updated: 2024-04-23
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
Never store the possibility of both A & B in a single column. Instead create two distinct columns for both.