I believe this:
"CREATE TABLE grades (
id serial PRIMARY KEY,
"date" timestamptz NOT NULL,
grade text NOT NULL,
score integer NOT NULL,
restaurant_id integer REFERENCES restaurants ON DELETE CASCADE
);
should actually read:
CREATE TABLE grades (
id serial PRIMARY KEY,
"date" timestamptz NOT NULL,
grade text NOT NULL,
score integer NOT NULL,
restaurant_id integer REFERENCES restaurants(id) ON DELETE CASCADE
);
I believe this: "CREATE TABLE grades ( id serial PRIMARY KEY, "date" timestamptz NOT NULL, grade text NOT NULL, score integer NOT NULL, restaurant_id integer REFERENCES restaurants ON DELETE CASCADE );
should actually read: CREATE TABLE grades ( id serial PRIMARY KEY, "date" timestamptz NOT NULL, grade text NOT NULL, score integer NOT NULL, restaurant_id integer REFERENCES restaurants(id) ON DELETE CASCADE );
Curriculum url: https://courses.thinkful.com/node-sql-001v1/project/1.1.4 UUID: 81cbd850-e895-11e6-a3eb-03934004d1da