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 |