There are two types of keys you should be aware of. A natural key uses the data in the record as the primary key. A surrogate key is generated by the database and is not naturally part of the data.
0:00 How to assign keys to a table
0:09 Types of Primary Keys
1:14 Primary Keys in CockroachDB
1:44 Strong Primary Keys
2:18 Weak Primary Keys
3:07 Choosing a Primary Keys
#CockroachDB #DistributedSQL #DistributedSystems
![](https://i.ytimg.com/vi/2nwbCFaNeoc/maxresdefault.jpg)