Versions Compared

Old Version 10

changes.mady.by.user Fiona Sargeant

Saved on

compared with

New Version Current

changes.mady.by.user Zoe Baldwin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


PhixFlow cannot ensure unique values for a primary key where:

  • the name is UID but
with a
  • 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

these cases

this case, you must set up your own processes to make sure that the

data

records in a table all have unique values in the primary key.

Excerpt
Note