UUID Use Case

UUID in a Composite Key

A composite key combines columns. Adding a UUID makes the combination unique regardless of the other fields, which is useful for join or mapping tables.

Multi-columnCollision-proofJoin tables

Version

How many

Uppercase Hyphens Braces { }

Result

Generated locally with the Web Crypto API — nothing leaves your browser.

What Is UUID in a Composite Key?

In a composite key, uniqueness is the tuple, not any single column. A UUID partner guarantees the tuple is unique even if every other column is identical across rows.
This is common in many-to-many join tables where you still want a stable, addressable row.

How to generate

Define the key as (entity_id, uuid) or (uuid, uuid).
Index the lookup columns separately for fast queries.
Use the UUID when you need to reference the junction row directly.

Use Cases

User ↔ role membership rows.
Product ↔ tag mappings.
Graph edges identified by two node IDs.

Code Examples

PostgreSQL

CREATE TABLE membership (
  user_id UUID,
  role_id UUID,
  row_id UUID DEFAULT gen_random_uuid(),
  PRIMARY KEY (user_id, role_id)
);

Frequently Asked Questions

Do I need a UUID in a composite key?

Only if you must address the junction row on its own, or if the natural columns alone are not unique. Otherwise the natural key suffices.

Does a UUID in the key bloat the index?

Slightly — 16 bytes per row. Acceptable for join tables; avoid it on huge fact tables.

Related tools

UUID v1 Generator UUID v3 Generator UUID v4 Generator UUID v5 Generator UUID v6 Generator UUID v7 Generator UUID v8 Generator Bulk UUID Generator Short UUID Generator UUID Validator UUID Formatter UUID as a Primary Key UUID Database ID UUID Foreign Key UUID Shard Key UUID Partition Key UUID in a Composite Key UUID Surrogate Key UUID API Key UUID Session Token UUID Access Token UUID Refresh Token UUID Idempotency Key UUID Request ID UUID Correlation ID UUID Trace ID UUID CSRF Token UUID Nonce UUID Filename UUID Object Key UUID S3 Key UUID Upload ID UUID Cache Key UUID Blob Name UUID Temp File UUID User ID UUID Account ID UUID Customer ID UUID Device ID UUID Tenant ID UUID Client ID UUID Anonymous ID UUID Member ID UUID Message ID UUID Event ID UUID Job ID UUID Task ID UUID Queue Message ID UUID Transaction ID UUID Order ID UUID Invoice ID UUID Payment ID UUID Reset Token UUID Verification Token UUID Invite Code UUID API Secret UUID Share Link UUID Magic Link UUID Node ID UUID Worker ID UUID Lock ID UUID Cluster ID UUID Test Data UUID Seed Data UUID Fixture UUID Mock ID UUID Placeholder ID UUID Sample ID