Good day. I am trying to solve the problem with the connections between the entities "Client", "Personal data of the client" and "Passport". Between the Client and LDK there should be 1 to 1 and between LDK and Passport similarly. How to do it? In theory, the identification number should be a unique value, but the LDK and the passport can be linked only through the client ID ...

  • So it is normal. in the passport, write the client id and that's it. Although his own id he also would not hurt. And by the way, I wonder why you consider a one-to-one passport-client relationship. And if the passport is changed, you will erase the old one. And if there are several passports (a citizen of several countries, internal / foreign, two foreign) - Mike
  • The scheme, to put it mildly, is not very. Limiting a person to one mobile phone is cruel. And the fact that the client may have an identification number that differs from that in his personal data is completely nonsense. In general, charting data without analyzing the subject area to the end is not worth it. - Akina

0