A unique identifier is a numeric field in a database table. It is populated by a sequence that ensures that each record has a unique value in that field. Foreign keys in other tables should reference the unique identifier column in order to get accurate joins to records in the target table.