Is there such thing as a "Multi Company" design pattern for databases? We were being told the other day by a professor that this is a relatively simple feature to add in design time and that we should apply it to any software that may be used by more than one company at the time or for example by a corporation (D) that is made out of company A,B,C.
What he suggested was in general terms was this.
- All catalogs should include the ID of the company.
- All reports should include in their input parameters, the company for which the report is run or whether it is for all companies
For example...
Is this an accepted way to model databases that will hold multiple companies'registers without mixing them?
Is there a better more efficient way?
I ask because it wouldn't be the first time we're told something that is quite outdated and I would appreciate any insight into current design trends (or where to find them)
Cheers.
Aucun commentaire:
Enregistrer un commentaire