njmango / sales-bot

0 stars 2 forks source link

3rd normal form database #6

Open mcmcford opened 3 months ago

mcmcford commented 3 months ago

By using 3rd normal form, repetition of strings can be drastically reduced saving both space and potential errors (a username update for example) while also helping teach "proper" database engineering.

For this, a few new tables will need to be made such as:

er

(All based on the most up-to-date code on the main branch). This isn't a big concern but would help remove edge-cases and will certainly help if the bots utilization begins to grow significantly