Common term for tenant-based keys
0
votes
2
answers
155
views
Assume the following schema:
ID | TENANT | TENANT_CUSTOM_ID
346 | 101 | 1
347 | 102 | 1
348 | 101 | 2
349 | 101 | 3
350 | 101 | 4
351 | 102 | 2
352 | 103 | 1
**What is another name (or the proper classification) for
TENANT_CUSTOM_ID
?** Perhaps something along the lines of a surrogate key? The purpose of this key is to make each tenant have their own numbering system instead of knowing that their records are mixed with all other tenants on the same tables.
Asked by 1234567
(159 rep)
Jun 2, 2017, 12:00 AM
Last activity: Jun 2, 2017, 09:01 PM
Last activity: Jun 2, 2017, 09:01 PM