I'm just getting my feet wet in databases and in creating a database I came to the realization that there are instances where what could be a text field could also be several Boolean fields.
To give a concrete example: I'm creating a database that has various exercises and the muscles that each exercise works. For each exercise, I could either have one muscles_worked TEXT or shoulders BOOLEAN, pecs BOOLEAN, lower_legs BOOLEAN, etc.
I'm trying to be smart about system resources and keep the database (as well as any attached code) as lean as possible, so which would be the preferred method?
Thanks in advance.
Aucun commentaire:
Enregistrer un commentaire