In MySql and MariaDB you can create a unique identity value for rows with the AUTO_INCREMENT attribute. PostgreSQL has the same idea with the SERIAL attribute.
CREATE TABLE domains
(id SERIAL PRIMARY KEY,
name VARCHAR(254) UNIQUE,
timestamp TIMESTAMPTZ NOT NULL DEFAULT NOW()
The example also shows how to have a column which stores the time when the record was created.