0004-use-uuid-as-primary-keys.md

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