SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE `Customer` ( `customerId` INTEGER, `firstName` VARCHAR(20), `lastName` VARCHAR(20), `street` VARCHAR(35), `city` VARCHAR(35), `state` CHAR(2), `zip` CHAR(10), `phoneNumber` INTEGER, PRIMARY KEY (`customerId`) ); CREATE TABLE `Restaurant` ( `restaurantId` INTEGER, `restaurantName` VARCHAR(35), `cuisine` VARCHAR(20), `street` VARCHAR(35), `city` VARCHAR(35), `state` CHAR(2), `zip` CHAR(10), `phoneNumber` INTEGER, PRIMARY KEY (`restaurantId`) ); CREATE TABLE `Driver` ( `driverId` INTEGER, `firstName` VARCHAR(20), `lastName` VARCHAR(20), `status` VARCHAR(10), `phoneNumber` INTEGER, PRIMARY KEY (`driverId`) ); CREATE TABLE `Payment` ( `paymentId` INTEGER, `status` VARCHAR(20), `date` DATE, `customerId` INTEGER, `restaurantId` INTEGER, `driverId` INTEGER, PRIMARY KEY (`paymentId`) ); INSERT INTO Customer (customerId, firstName, lastName, street, city, state, zip, phoneNumber) VALUES (1, April, Ludgate, "123 5 55 Ave", "Omaha", 'NE', 68132, 4025534397), (2, "Leslie Knope", "4387 Waffles Drive", "Pawnee", 'IN', 46011, 234432537), (3, "Ron", "Swanson", "987 Bacon Avenue", "Pawnee," 'IN', 46011, 4569873265), (4, "Andy", "Dwyer", "2468 The Pit", "Pawnee," 'IN' 46011); INSERT INTO Restaurant (restaurantId, restaurantName, cuisine, street, city, state, zip, phoneNumber) VALUES (1, "Paunch Burger", "Fast Food", "6872 Lard Lane", "Pawnee", 'IN', 46011, 2869372250); SELECT * FROM Payment; SELECT * FROM Driver; SELECT * FROM Restaurant; SELECT * FROM Customer;