Data modelling - Record
UID
(Unique Identifier)
A value that identifies one thing and is not reused for anything else in the same scope
What's it for?
Gives one item a stable identity so systems do not confuse it with another item.
For example…
Each user account gets a UID so orders, logs, and permissions can all point at the right person even when two people share the same display name.
Customer 84721 keeps the same UID even if their email address changes, giving systems a stable way to refer to that exact record
Think of it like…
Passport number — one person, one number, even when names collide