SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE Customer (customer_id integer NOT NULL, first_name VARCHAR(25), last_name VARCHAR(25), street_address VARCHAR(30), city VARCHAR(30), state_name VARCHAR(2), zip_code integer NOT NULL, phone_number VARCHAR(20), payment_id integer NOT NULL, CONSTRAINT Customer_PK PRIMARY KEY (customer_id)); insert into Customer (customer_id, first_name, last_name, street_address, city, state_name, zip_code, phone_number, payment_id) 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"), (4, "Ron", "Swanson", "987 Bacon Avenue", "Pawnee", "IN", "46011", "456-987-3265", "234789"), (5, "Andy", "Dwyer", "2468 The Pit", "Pawnee", "IN", "46011", NULL, "12390");