I am trying to structure my data base for an initial build in an application and I have some confusion with the data types.
Data Type Male:
Data Type Female:
The confusion stems with the color fields. Both male and female have colors of which I would like to setup a list of default color options. The question is, should Color be its own separate data type with fields of type text for each color? Or should I build the colors under both Male and Female in each data type.
Color is one example of this in my data structure but it is the best example of the confusion I am having.
Also, I am confused if each should be a list of colors or a single field type of color? Essentially I would like a list of default colors to select in a multi-dropdown menu but also have the ability for the user to input their own colors if none of the default fit the description.
Is this possible? Where does one list the colors available and under what type of data structure is this?