How to store a old company which become a new company or part of a group?
^Bart <[email protected]> Wed, 5 Aug 2020 16:58:23 +0200
| Newsgroups | comp.databases.mysql |
|---|---|
| Organization | Aioe.org NNTP Server |
| Message-ID | <[email protected]> |
Hi Guys! I need to do a db where I could store company's details and company's products but what happen when a company for example named "X" become a company named "Y"? I should see the story of the product for example the product named "A" is repaired ten times when the owner was company "X" and now is repaired one time with the company "Y". Sometimes it happen also a group of company will become just one... ^Bart