The Customer table
create table customer(
customer_id bigint not null,
name varchar not null,
address_line_1 varchar not null,
address_line_2 varchar,
city varchar not null,
state char(2) not null,
zip char(5) not null,
phone varchar,
primary key(customer_id)
);
|