Primary keys in write tables
To add editable columns to a write table, you need to define at least one primary key.
What is a primary key?
A primary key is a field used to link changes to editable columns back to the original data from the data model. Primary keys provide the mapping between records in the write table — which represent data from the data model — and the edits that users introduce within editable columns.
The primary key can be a single field, or it could be a composite key that spans multiple fields.
The primary key is also important when you pull changes from the change-stores API.
Defining primary keys
Do the following:
-
In the properties panel, expand Change store.
-
Next to Primary keys, click Define or Modify.