Supporting uniqueness constraints

A column that has a uniqueness constraint must have a unique value for every record.

Primary key columns automatically require uniqueness. Uniqueness can also be required for other columns. For example, in a users table, userid is the primary key column, but username also must be unique.

The following generators can be used with columns that have uniqueness constraints:

• Alphanumeric String Key

• ASCII Key

• Character Substitution

• Conditional

• Finnish Personal Identity Code

• FNR

• Geo

• IBAN

• Integer Key

• Null

• Numeric String Key

• Passthrough

• Random UUID

• Regex Mask

• Sequential Integer

• SIN

• Unique Email

• URL

• UUID Key