Database Examples/Pubs/Stores
Fields
[edit | edit source]| Field 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
[edit | edit source]| store_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 |