SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Restaurant (restaurant_id integer NOT NULL, restaurant_name VARCHAR(25), street_address VARCHAR(25), city VARCHAR(30), state_name VARCHAR(25), zip_code integer NOT NULL, phone_number VARCHAR(25), cuisine_type VARCHAR(25), rest_payment_id integer NOT NULL, CONSTRAINT Restaurant_PK PRIMARY KEY (restaurant_id)); insert into Restaurant (restaurant_id, restaurant_name, street_address, city, state_name, zip_code, phone_number, cuisine_type, rest_payment_id) values (6, "Paunch Burger", "6872 Lard Lane", "Pawnee", "IN", "46011", "678-893-1568", "Fast Food", "4826"), (7, "JJ's Diner", "23428 Main St.", "Pawnee", "IN", "46011", "456-987-3185", "Breakfast", "78623"), (8, "Mulligan's", "6876 Classy RD.", "Indianapolis", "IN", "46077", "786-235-4862", "Steakhouse", "48623");