4. Use UUID as Primary Keys

Date: 2022-12-10

Status

Accepted

Context

We need some identifier for entities that will be unique throughout the service. A more detailed description of the problem can be found in the issue #762

Docs

• UUID or GUID as Primary Keys? Be Careful!
• Primary Keys: IDs versus GUIDs

• UUID vs. Sequences

• MySQL
  • MySQL 8.0.13: Default Value as uuid
• PostgreSQL
  • Default value for UUID column in Postgres

Decision

We will use UUID as primary keys

Consequences

• We will have a unique identifier for each entity