Does anyone make notes or have best practice advise for logging relation ships and their changes
Ok, my database is starting to become quite complex. Is it worth trying to make notes of all the relationships, or is it more a case of when a change is required then to figure out what to do from the relationship chart?
for instance I have a contacts table and then contacts1, contacts2, contacts3, contacts4, contacts5 etc.. which are all different relationships
I am worried that I might lose track of what it all means and does, and I might delete or change the wrong thing