_uid

Owned by Fiona Sargeant (Unlicensed)
Last updated: Jun 29, 2022
1 min read

PhixFlow cannot ensure unique values for a primary key where:

  • the name is UID but it's data type is not integer
  • the name is not UID.

If your data already has a unique attribute, you can use that as the primary key. For example, the Teacher table could have a National Insurance attribute, which would be unique to a teacher. In this case, you must set up your own processes to make sure that the records in a table all have unique values in the primary key.