| Column_name | 数据类型 | 可为空 | 默认值 | 检查 | 键/索引 |
|---|---|---|---|---|---|
| stor_id | char(4) | 否 | 聚集主键 | ||
| stor_name | varchar(40) | 是 | |||
| stor_address | varchar(40) | 是 | |||
| city | varchar(20) | 是 | |||
| state | char(2) | 是 | |||
| zip | char(5) | 是 |
下表显示 stores 表的内容。
| stor_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 Avrogado Way | Remulade | WA | 98014 |
| 7896 | Fricative Bookshop | 89 Madison St. | Fremont | CA | 90019 |
| 8042 | Bookbeat | 679 Carson St. | Portland | OR | 89076 |