ELI5: Explain Like I'm 5

Primary key

Let's pretend you have a big toy box with lots of toys inside. You want to find one specific toy in the box, but you don't know where it is. To help you find it, you decide to label each toy with a different number. That number is like the toy's "primary key."

Now, when you want to find a toy, all you have to do is look for its number. It's like doing a search in the toy box. The number tells you exactly which toy you're looking for, like a special code.

In real life, this kind of system is used for storing information in a computer. Instead of toys and numbers, there might be a big list of information with lots of details about each thing. To help find specific information quickly, something like a "primary key" is assigned. This is usually a unique identifier that's easy to sort and search for. Just like in the toy box, the primary key lets you find the specific piece of information you need without having to hunt through the whole list.