How to allow duplicate value of a key in SQL?

2

I need the Process_Number and RecipeNumber keys to be able to receive values that already exist in the table. for example:

Id = 1, Numero_Processo = 1, Numero_Revisao = 1
Id = 2, Numero_Processo = 1, Numero_Revisao = 2
Id = 2, Numero_Processo = 1, Numero_Revisao = 3

or

Id = 4, Numero_Processo = 2, Numero_Revisao = 1
Id = 2, Numero_Processo = 2, Numero_Revisao = 2
Id = 2, Numero_Processo = 2, Numero_Revisao = 3

In both cases I need to repeat the ProcessNumber and RevisionNumber values. These fields are keys in other tables with the Quality_Insp_Inj_Entrance table in the image below.

    
asked by anonymous 19.06.2018 / 17:02

0 answers