DB best practice question
Darcy
Posted on January 5, 2021
I am building an app on Strapi and am deciding on the best practice to organise the database.
I have a Table (‘Job’) that has roughly 60 rich text form fields. Additionally, each of the form fields needs to have a ‘visibility’ boolean value, which toggles whether the field is viewable by certain users.
Regarding the database structure, do you think it is better practice to have two separate fields, or to combine them into a single JSON field that contains 'value' and 'visibility' as keys within the field?
The upside of having them separate is that can store them text and boolean, but the downside is that it will double the number of fields needed for each Table.
Posted on January 5, 2021
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.
Related
November 29, 2024