Drill 15: Explain each line — Creating tables and relationships

create table courses (
  id integer generated always as identity primary key,
  slug text not null unique,
  title text not null
);

create table lessons (
  id integer generated always as identity primary key,
  course_id integer not null references courses(id) on delete cascade,
  title text not null,
  minutes integer not null
);