M
M
MasterF2020-10-28 21:44:14
Database design
MasterF, 2020-10-28 21:44:14

What key should I choose for the client database?

We plan to create a single customer base. Now we are collecting client data in 3 software 1C, ERP, CRM (all 3 are not interconnected). We want to make Surname + First Name + Mobile Phone a unique key. Managers record all other data not always and not always correctly.
1. Is this key correct or are there pitfalls?
2. What to do if the client was recorded in transliteration (is there a standard transliteration library?)

Destination B2C tourism

Answer the question

In order to leave comments, you need to log in

3 answer(s)
D
Dr. Bacon, 2020-10-28
@bacon

Choose a surrogate key.

R
Rsa97, 2020-10-28
@Rsa97

Last name and first name can be changed. Cell number too.
Unique, in theory, should be SNILS.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question