When modeling Entities to store data on the database, you can make Integer attributes auto numbers to ensure they have unique values for each record. Learn how to Create a Sequential Attribute.
This page explains what happens on the database when setting an attribute IsAutoNumber property to Yes.
When creating a sequential attribute with a SQL Server database, a column with Int data type, and with Identity (1,1) is created. This ensures the value starts at 1, and is incremented by 1, each time a new record is inserted.
In Oracle, a sequential attribute is mapped to the following Oracle objects:
In MySQL, a sequential attribute is mapped in a column of type Integer with the AUTO_INCREMENT attribute. This attribute indicates to the MySQL database that this column uses sequential numbers that start at 1.
Create a Sequential Attribute