 DROP TABLE IF EXISTS drink_order;
 CREATE TABLE drink_order (
   id SERIAL PRIMARY KEY,
-  order_id FOREIGN KEY,
-  drink_id FOREIGN KEY,
+  order_id INTEGER REFERENCES order ( id ),
+  drink_id INTEGER REFERENCES drink ( id ),
   quantity INTEGER
 );
 

DROP TABLE IF EXISTS address;
CREATE TABLE address (
  id SERIAL PRIMARY KEY,
  street_address VARCHAR 255,
  zipcode INTEGER,
  apartment_number VARCHAR 255,
  city VARCHAR 255,
  state VARCHAR 255
);


DROP TABLE IF EXISTS drink;
CREATE TABLE drink (
  id SERIAL PRIMARY KEY,
  description VARCHAR 255,
  manufacturer VARCHAR 255,
  supplier VARCHAR 255,
  price DECIMAL
);


DROP TABLE IF EXISTS pizza_order;
CREATE TABLE pizza_order (
  id SERIAL PRIMARY KEY,
  order_id INTEGER REFERENCES order ( id ),
  pizza_id INTEGER REFERENCES pizza ( id ),
  quantity INTEGER
);


DROP TABLE IF EXISTS pizza_ingredient;
CREATE TABLE pizza_ingredient (
  pizza_id INTEGER REFERENCES pizza ( id ),
  ingredient_id INTEGER REFERENCES customer ( id )
);


DROP TABLE IF EXISTS ingredient;
CREATE TABLE ingredient (
  id SERIAL PRIMARY KEY,
  name VARCHAR ( 255 ),
  price DECIMAL,
  quantity INTEGER
);
