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;
Telegram: DB developers channel