good day!
I do this thread because I'm working with a transformer database
The subject is the following, I have something like that ..
Table Transformer
*Código comercial
1º Cliente
1º Nota de venta
Fecha de diseño
Norma
etcetera
The issue is that there can be two identical transformers, exactly the same, but change in the guaranteed data. When I did the normalization I came to this second table ..
Table Data Guaranteed
*Codigo comercial
*Version
Aplicación primaria
Aplicación secundaria
etcetera.
The problem is the following, to implement this structure, it would have to have in the table Data Guaranteed a composite key, where one (in this case Version) is auto-incremental, which is what I read It is not a good practice. And of course there is a Commercial Code to identify which transformer these guaranteed data correspond to.
Not so long ago that I have started working on what is databases, so it is possible that it is a very simple error, but I can not think of how to modify the structure so that I can dodge the autoincremental composite primary key
Thank you very much for reading my question!