Counter

The optional counter column constraint delegates the responsibility of counting duplicate records to the specified column.

If you attempt to insert a duplicate record into the table, the insertion of the duplicate entry is suppressed and the value of the specified column is incremented in the record that already exists.