Identity Column in a Entity

Out system says it can only have one column as Identity Column , no composite key is there.

but how can we design a entity where we needs to constantly insert/update records based on few columns which makes data in the table unique

Example, we have a entity for maintaining Payee/Role Relationship with date effectiveness. Columns are





Now key attribute in this column can be "PayeeID+RoleID+StartInRole, based on we will insert/update data in this entity on daily basis

Can can we design this in Outsystem to achieve our needs for maintain data in this entity (table)



Hello Naveen,

You can create compost keys with 2 or more fields, example:

In this way, the database will not allow records with the same fields to be created, as long as they are unique.

Documents about:

Hope it helps.


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.