stores is defined as follows:
create table stores (stor_id char(4) not null, stor_name varchar(40) not null, stor_address varchar(40) null, city varchar(20) null, state char(2) null, country varchar(12) null, postalcode char(10) null, payterms varchar(12) null, unique nonclustered (stor_id))
Table B-7 lists the contents of stores:
stor_id |
stor_name |
stor_address |
city |
state |
country |
postalcode |
payterms |
---|---|---|---|---|---|---|---|
7066 |
Barnum’s |
567 Pasadena Ave. |
Tustin |
CA |
USA |
92789 |
Net 30 |
7067 |
News & Brews |
577 First St. |
Los Gatos |
CA |
USA |
96745 |
Net 30 |
7131 |
Doc-U-Mat: Quality Laundry and Books |
24-A Avrogado Way |
Remulade |
WA |
USA |
98014 |
Net 60 |
8042 |
Bookbeat |
679 Carson St. |
Portland |
OR |
USA |
89076 |
Net 30 |
6380 |
Eric the Read Books |
788 Catamaugus Ave. |
Seattle |
WA |
USA |
98056 |
Net 60 |
7896 |
Fricative Bookshop |
89 Madison St. |
Fremont |
CA |
USA |
90019 |
Net 60 |
5023 |
Thoreau Reading Discount Chain |
20435 Walden Expressway |
Concord |
MA |
USA |
01776 |
Net 60 |