"Let’s see what we’ve got. The below is my analysis based on the data I’ve found in the tables in my own DB and my inferences about it:
1. Z_PK — seems like a serial number..."
Yup, it is a serial number. One those who dream SQL, like me, for past 20+ years, will also call it Primary Key.
This article is getting better with every re-read :)
"Let’s see what we’ve got. The below is my analysis based on the data I’ve found in the tables in my own DB and my inferences about it: 1. Z_PK — seems like a serial number..."
Yup, it is a serial number. One those who dream SQL, like me, for past 20+ years, will also call it Primary Key. This article is getting better with every re-read :)