Build A Menu For Bytes Of China

Hello, I have a problem with this project: in step 8, I create a table to relate the category table with the dish table, but when I save I get this error: “Error: relation ‘dish’ does not exist”.
Can you help me and tell me what is my error?

Here is my code.

create table restaurant (
  id integer primary key,
  name varchar(20),
  description varchar(100),
  rating decimal,
  telephone char(10),
  hours varchar(100)
);

create table address (
  id integer primary key,
  restaurant_id integer references restaurant(id) unique,
  street_number varchar(10),
  street_name varchar(20),
  city varchar(20),
  state varchar(15),
  google_map_link varchar(50)
);

create table category (
  id char(2) primary key,
  name varchar(20),
  description varchar(200)
);

create table categories_dishes (
  category_id char(2) references category(id),
  dish_id integer references dish(id),
  price money,
  primary key (category_id, dish_id)
);

create table dish (
  id integer primary key,
  name varchar(50),
  description varchar(200),
  hot_and_spicy boolean
);

create table review (
  id integer primary key,
  restaurant_id integer references restaurant(id),
  rating decimal,
  description varchar(100),
  date date
);

select constraint_name, column_name, table_name 
from information_schema.key_column_usage;

Hello @juandiegojeanpiercha , can you post the link to the lesson?

https://www.codecademy.com/paths/design-databases-with-postgresql/tracks/how-do-i-make-and-populate-my-own-database/modules/designing-a-database-schema/projects/restaurant-database-project-with-postgresql

Check your create table statement for categories_dishes:

create table categories_dishes (
  category_id char(2) references category(id),
  dish_id integer references dish(id),  -- check this line
  price money,
  primary key (category_id, dish_id)
);