 DROP TABLE IF EXISTS delivery;
 CREATE TABLE delivery (
   id SERIAL PRIMARY KEY,
-  status VARCHAR 255,
-  delivery_address FOREIGN KEY,
-  delivery_person VARCHAR 255,
+  status VARCHAR ( 255 ),
+  delivery_address INTEGER REFERENCES customer_address ( id ),
+  delivery_person VARCHAR ( 255 ),
   -- consider delivery_person
-  order_id FOREIGN KEY,
+  order_id INTEGER REFERENCES order ( id ),
   price DECIMAL,
   tip DECIMAL
 );

DROP TABLE IF EXISTS pizza;
CREATE TABLE pizza (
  id SERIAL PRIMARY KEY,
  name VARCHAR 255,
  size VARCHAR 255,
  type VARCHAR 255,
  price DECIMAL,
  discount DECIMAL
);

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

