Composite Primary Key (or Foreign Key)

Composite Primary Key (or Foreign Key)

Is it possible to have a composite Unique key - either as a Primary key, or as a Foreign key reference?

If not, is it an acceptable workaround to create a new column that stores a concatenation of the fields I want as part of the composite key, and use this new column as my unique key?