WHAT IS THE DIFFERENCE BETWEEN A PRIMARY KEY AND A FOREIGN KEY?

A primary key is a unique identifier for a record in a database table. It ensures that each record can be uniquely identified and is often an auto-incrementing integer or a UUID. For example, a User table might use id as the primary key. A foreign key is a field in one table that references the primary key of another table. It establishes a