Hi Guys,
i have 2 tables with the same fields for two different computers. And also i have 2 calculation environments : test and production.
Columns memory size and Serial_no can be characteristic also for test environment.
The rest of columns are used only in production.
How should i organize data to have best approach for this?
Should i create only one table , my junction table where i will have all data characteristic for each column?
For example for Memory Size and production_memory one separate table with relation to junction table?
In attachment please find my database.
thank you for help,
Best,
Jacek