How to use composite key?

How to use composite key?

  

Hello, Is there any way to accomplish composite key feature?

Hello Dubey. In OutSystems, it's not possible to have composite keys. OutSystems promotes the use of surrogate keys, instead of natural keys, and with that approach there's no need to use composite keys. Please read this article to understand the differences between those types of keys.

If you need to integrate with an existing model, then OutSystems is able to import the composite keys, but they won't be considered as keys by the platform. You will still be able to use them for joins and take advantage of indexes and query optimizations.

You can however simulate composite keys by adding a composite, unique index using the attributes.

Solution

Thanks Kilian

Solution

You're most welcome :)