SQLize Online / PHPize Online  /  SQLtest Online

CREATE DATABASE grubhub; USE grubhub; CREATE TABLE Customer (customer_id integer PRIMARY KEY, name VARCHAR(25), address VARCHAR(50), phone VARCHAR(15), pmt_id integer ); CREATE TABLE Restaurant (restaurant_id integer PRIMARY KEY, name VARCHAR(25), address VARCHAR(50), phone VARCHAR(15), rest_pmt_id integer, cuisine VARCHAR(10) ); CREATE TABLE Driver (driver_id integer PRIMARY KEY, name VARCHAR(25), address VARCHAR(50), phone VARCHAR(15), license_plate VARCHAR(6), dr_license VARCHAR(9), dr_status enum('active','inactive'), dr_pmt_id integer ); CREATE TABLE Orders (order_id integer PRIMARY KEY, customer_id integer, restaurant_id integer, driver_id integer, status enum('out','placed','fulfilled','cancelled'), FOREIGN KEY (customer_id) REFERENCES Customer(customer_id), FOREIGN KEY (restaurant_id) REFERENCES Restaurant(restaurant_id), FOREIGN KEY (driver_id) REFERENCES Driver(driver_id)); /*** Insert statements ***/ insert into Customer(customer_id, name, address, phone, pmt_id) values(1, "April Ludgate", "123 S 55 Ave, Omaha, NE 68132", "402-553-4397", 23456), (2, "April Ludgate", "123 S 55 Ave, Omaha, NE 68132", "402-553-4397", 23456), (3, "Leslie Knope", "4387 Waffles Drive, Pawnee, IN, 46011", "234-432-5437", 98754), (4, "Ron Swanson", "987 Bacon Avenue, Pawnee, IN 46011", "456-987-3265", 234789), (5, "Andy Dwyer", "2468 The Pit, Pawnee, IN 46011", NULL, 12390); insert into Restaurant(restaurant_id, name, address, phone, rest_pmt_id, cuisine) values(1, 'Paunch Burger','6872 Lard Lane, Pawnee, IN 46011', '678-893-1568', 4826, 'Fast food'), (2, 'JJ''s Diner','23428 Main St. Pawnee, IN 46011', '456-987-3185', 78623, 'Breakfast'), (3, 'Mulligan''s','6876 Classy Rd., Indianapolis, IN 46077', '786-235-4862', 48623, 'Steakhouse'); insert into Driver(driver_id, name, phone, license_plate, dr_license, dr_status, dr_pmt_id) values(1, "Henry Roth", '(286) 937-2250', 'IUC989', 'C04790049','active', 444862), (2, "Charity Osborne", '(815) 605-0336', 'REW222', 'D89973937', 'active', 959227), (3, "Fritz Macias", '(943) 893-6193', 'XUA177', 'U06119817', 'active', 718371), (4, "Brenden Hill", '(513) 284-9064', 'IOL455', 'X22173227', 'active', 334452), (5, "Leah Peters", '(909) 477-8843', 'AJA879', 'V44276914', 'inactive', 603268); insert into Orders(order_id, customer_id, restaurant_id, driver_id, status) values(1, 1, 1, 1, 'out'), (2, 1, 1, 2, 'placed'), (3, 3, 2, 3, 'fulfilled'), (4, 4, 3, 4, 'placed'), (5, 5, 2, 1, 'cancelled');