UUID Use Case
UUID Member ID
A person may belong to several organisations with different roles. A per-org member UUID captures that membership distinctly from the user.
Per-orgRole-scopedv4
Generated locally with the Web Crypto API — nothing leaves your browser.
What Is UUID Member ID?
- The member ID is the junction between a user UUID and an account UUID, carrying role and status.
- This lets the same user appear in two orgs without duplicating their identity.
How to generate
- Create members(member_uuid, user_id, account_id, role).
- Key membership checks on member_uuid.
- Reference member_uuid from posts/comments.
Use Cases
- Slack/Discord-style workspaces.
- GitHub-style orgs.
- School class rosters.
Code Examples
PostgreSQL
CREATE TABLE members (
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
user_id UUID, account_id UUID, role text
);Frequently Asked Questions
Why not just user_id + account_id?
The pair is unique, but a member UUID gives you a stable handle to reference from other tables and to revoke cleanly.
One member per org per user?
Usually yes; enforce with a UNIQUE(user_id, account_id) constraint.
Related tools
UUID v1 GeneratorUUID v3 GeneratorUUID v4 GeneratorUUID v5 GeneratorUUID v6 GeneratorUUID v7 GeneratorUUID v8 GeneratorBulk UUID GeneratorShort UUID GeneratorUUID ValidatorUUID FormatterUUID as a Primary KeyUUID Database IDUUID Foreign KeyUUID Shard KeyUUID Partition KeyUUID in a Composite KeyUUID Surrogate KeyUUID API KeyUUID Session TokenUUID Access TokenUUID Refresh TokenUUID Idempotency KeyUUID Request IDUUID Correlation IDUUID Trace IDUUID CSRF TokenUUID NonceUUID FilenameUUID Object KeyUUID S3 KeyUUID Upload IDUUID Cache KeyUUID Blob NameUUID Temp FileUUID User IDUUID Account IDUUID Customer IDUUID Device IDUUID Tenant IDUUID Client IDUUID Anonymous IDUUID Member IDUUID Message IDUUID Event IDUUID Job IDUUID Task IDUUID Queue Message IDUUID Transaction IDUUID Order IDUUID Invoice IDUUID Payment IDUUID Reset TokenUUID Verification TokenUUID Invite CodeUUID API SecretUUID Share LinkUUID Magic LinkUUID Node IDUUID Worker IDUUID Lock IDUUID Cluster IDUUID Test DataUUID Seed DataUUID FixtureUUID Mock IDUUID Placeholder IDUUID Sample ID