_uid

PhixFlow cannot ensure unique values for a primary key where:

  • the name is UID but its 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.