| Column_name | 数据类型 | 可为空 | 键/索引 |
|---|---|---|---|
| stor_id | char(4) | 否 | 组合主键，聚集索引1 ,外键 stores(stor_id) |
| ord_num | varchar(20) | 否 | 组合主键，聚集索引 1 |
| ord_date | datetime | 否 | |
| qty | smallint | 否 | |
| payterms | varchar(12) | 否 | |
| title_id | tid | 否 | 组合主键，聚集索引1,外键 titles(title_id) |
1 组合主键、聚集索引定义在 stor_id、ord_num 和 title_id 上。
下表显示 sales 表的内容。
| stor_id | ord_num | ord_date | qty | payterms | title_id |
|---|---|---|---|---|---|
| 6380 | 6871 | Sep 14 1994 12:00AM | 5 | Net 60 | BU1032 |
| 6380 | 722a | Sep 13 1994 12:00AM | 3 | Net 60 | PS2091 |
| 7066 | A2976 | May 24 1993 12:00AM | 50 | Net 30 | PC8888 |
| 7066 | QA7442.3 | Sep 13 1994 12:00AM | 75 | ON invoice | PS2091 |
| 7067 | D4482 | Sep 14 1994 12:00AM | 10 | Net 60 | PS2091 |
| 7067 | P2121 | Jun 15 1992 12:00AM | 40 | Net 30 | TC3218 |
| 7067 | P2121 | Jun 15 1992 12:00AM | 20 | Net 30 | TC4203 |
| 7067 | P2121 | Jun 15 1992 12:00AM | 20 | Net 30 | TC7777 |
| 7131 | N914008 | Sep 14 1994 12:00AM | 20 | Net 30 | PS2091 |
| 7131 | N914014 | Sep 14 1994 12:00AM | 25 | Net 30 | MC3021 |
| 7131 | P3087a | May 29 1993 12:00AM | 20 | Net 60 | PS1372 |
| 7131 | P3087a | May 29 1993 12:00AM | 25 | Net 60 | PS2106 |
| 7131 | P3087a | May 29 1993 12:00AM | 15 | Net 60 | PS3333 |
| 7131 | P3087a | May 29 1993 12:00AM | 25 | Net 60 | PS7777 |
| 7896 | QQ2299 | Oct 28 1993 12:00AM | 15 | Net 60 | BU7832 |
| 7896 | TQ456 | Dec 12 1993 12:00AM | 10 | Net 60 | MC2222 |
| 7896 | X999 | Feb 21 1993 12:00AM | 35 | ON invoice | BU2075 |
| 8042 | 423LL922 | Sep 14 1994 12:00AM | 15 | ON invoice | MC3021 |
| 8042 | 423LL930 | Sep 14 1994 12:00AM | 10 | ON invoice | BU1032 |
| 8042 | P723 | Mar 11 1993 12:00AM | 25 | Net 30 | BU1111 |
| 8042 | QA879.1 | May 22 1993 12:00AM | 30 | Net 30 | PC1035 |