The database schema refers to the structure of the databse. It describes the design of the database similar to a templatre or a blueprint. It descibes all the tables and their layouts, but doesn't contain the actual data in the database. It should show the tables along with their columns, and the primary key of each table and any foreign key.

Foreign keys represent a relationship between data in two tables.