Using a user-defined type as a primary key
Posted
by Chris Kaminski
on Stack Overflow
See other posts from Stack Overflow
or by Chris Kaminski
Published on 2010-03-16T20:29:31Z
Indexed on
2010/03/16
20:31 UTC
Read the original article
Hit count: 202
Suppose I have a system where I have metadata such as:
table:
======
key
name
address
...
Then suppose I have a user-defined type described as so:
datasource
datasource-key
A) are there systems where it's possible to have keys based on user-defined types?
B) if so, how do you decompose the keys into a form suitable for querying?
C) is this a case where I'm just better off with a composite primary key?
© Stack Overflow or respective owner