Defining a primary key: Customer numbers are unique only within a country but may be duplicated across different countries
1
vote
2
answers
130
views
I am facing the following problem:
I have a table with customer information like the *customer number*, i.e.
customerID
set up as the primary key, and, besides a number of other data, also a country value in the form of a *country code*, countryID
.
However, customer data from other countries should also be imported into this table. Although the customer numbers are unique within a country, they are not cross-country. Customer numbers should not be changed for organizational reasons.
How can a key still be ensured for each customer in this table?
Asked by Poldi60
(11 rep)
Jan 29, 2019, 08:01 PM
Last activity: Jan 31, 2019, 10:21 AM
Last activity: Jan 31, 2019, 10:21 AM