SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Customer (customerID integer NOT NULL, customerName VARCHAR (25), customerAddress VARCHAR (50), customerPhone VARCHAR (12), customerPayID CHAR (8), CONSTRAINT Customer_PK PRIMARY KEY (customerID)); CREATE TABLE Restaurant (restaurantID CHAR(8) NOT NULL, restaurantName VARCHAR (25), restaurantAddress VARCHAR (50), restaurantPhone CHAR (12), restaurantPayID CHAR (16), restaurantCuisine CHAR (16), CONSTRAINT Restaurant_PK PRIMARY KEY (restaurantID)); CREATE TABLE Orders (restaurantID integer NOT NULL, customerID integer NOT NULL, driverID integer NOT NULL, orderDate TIMESTAMP, orderStatus ENUM('placed', 'out', 'cancelled', 'fulfilled'), CONSTRAINT Orders_PK PRIMARY KEY (restaurantID, customerID), CONSTRAINT Orders_Restaurant_FK FOREIGN KEY (restaurantID) REFERENCES Restaurant(restaurantID), CONSTRAINT Orders_Customer_FK FOREIGN KEY (customerID) REFERENCES Customer(customerID), CONSTRAINT Orders_Driver_FK FOREIGN KEY(driverID) REFERENCES Driver(driverID)); CREATE TABLE Driver (driverID integer NOT NULL, driverName CHAR (25), driverPhone CHAR (12), driverLicensePlate VARCHAR (8), driverLicenseNum VARCHAR (25), driverPayID CHAR (16), driverStatus ENUM ('active', 'inactive'), CONSTRAINT Driver_PK PRIMARY KEY (driverID)); INSERT INTO Customer(customerID, customerName, customerAddress, customerPhone, customerPayID) VALUES (1, 'April Ludgate', '123 S 55 Ave, Omaha NE 68132', '402-553-4397', '23456'), (2, 'Leslie Knope', '4387 Waffles Drive, Pawnee, IN 46011', '234-432-5437', '98754'), (3, 'Ron Swanson', '987 Bacon Ave, Pawnee, IN, 46011', '456-987-3265', '234789'), (4, 'Andy Dwyer', '2468 The Pit, Pawnee, IN, 46011', '', '12390'); INSERT INTO Restaurant(restaurantID, restaurantName, restaurantAddress, restaurantPhone, restaurantPayID, restaurantCuisine) VALUES(1, 'Paunch Burger', '6872 Lard Lane, Pawnee, IN, 46011', '678-893-1568', '4826', 'fast food'), (2, 'JJs Diner', '23428 Main St., Pawnee, IN, 46011', '456-987-3185', '78623', 'breakfast'), (3, 'Mulligans', '6876 Classy Rd., Indianapolis, IN, 46077', '786-235-4862', '48623', 'steakhouse'); INSERT INTO Orders(restaurantID, customerID, driverID, orderDate, orderStatus) VALUES(1, 1, 1, '9/30/2020 6:44', 'out'); INSERT INTO Driver(driverID, driverName, driverPhone, driverLicensePlate, driverLicenseNum, driverPayID, driverStatus) VALUES(1, 'Henry Roth', '203-937-2250', 'IUC989', 'C04790049', '444862', 'active'), (2, 'Charity Osborne', '815-605-0336', 'REW222', 'D89973937', '959227', 'active'), (3, 'Fritz Macias', '943-893-6193', 'XUA177', 'U06119817', '718371', 'active'), (4, 'Brenden Hill', '513-284-9064', 'IOL455', 'X22173227', '334452', 'active'), (5, 'Leah Peters', '909-477-8843', 'AJA879', 'V44276914', '603268', 'inactive'); SELECT * FROM Customer; SELECT * FROM Restaurant; SELECT * FROM Driver; SELECT * FROM Orders;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear