Database Examples/Pubs/Stores
Fields
editField Name | Field Type | Length | Index | Constraint | Default |
---|---|---|---|---|---|
store_id | Integer | Primary Key | Not Null | ||
stor_name | Text | 40 | Yes | Not Null | |
stor_address | Text | 40 | |||
city | Text | 20 | Yes | ||
state | Text | 2 | Yes | ||
zip | Text | 5 | Yes |
Data
editstore_id | stor_name | stor_address | city | state | zip |
---|---|---|---|---|---|
6380 | Eric the Read Books | 788 Catamaugus Ave. | Seattle | WA | 98056 |
7066 | Barnum's | 567 Pasadena Ave. | Tustin | CA | 92789 |
7067 | News & Brews | 577 First St. | Los Gatos | CA | 96745 |
7131 | Doc-U-Mat: Quality Laundry and Books | 24-A Avogadro Way | Remulade | WA | 98014 |
7896 | Fricative Bookshop | 89 Madison St. | Fremont | CA | 90019 |
8042 | Bookbeat | 679 Carson St. | Portland | OR | 89076 |