Entity IDs based on UUID

[01es]

Description

In order to support distributed databases, including sharding, ID values for entities should become UUIDs.

Performance implications (both memory and CPU) need to be considered. Also need to consider alternative approaches where UUIDs are used for "external" IDs and integer IDs are used internally.

Expected outcome

Ability to support distributed databases and multi-tenant environments.