| Column_name | 数据类型 | 可为空 | 默认值 | 检查 | 键/索引 |
|---|---|---|---|---|---|
| job_id | smallint | 否 | IDENTITY(1,1) | 主键，聚集 | |
| stor_id | char(4) | 否 | 是1 | ||
| min_lvl | tinyint | 否 | 是3 | ||
| max_lvl | tinyint | 否 | 是3 |
(1) DEFAULT 约束定义为 ("New Position - title not formalized yet")。
(2) min_lvl CHECK 约束定义为 (min_lvl >= 10)。
(3) max_lvl CHECK 约束定义为 (max_lvl <= 250)。
下表显示 jobs 表的内容。
| job_id | job_desc | min_lvl | max_lvl |
|---|---|---|---|
| 1 | New Hire - Job not specified | 10 | 10 |
| 2 | Chief Executive Officer | 200 | 250 |
| 3 | Business Operations Manager | 175 | 225 |
| 4 | Chief Financial Officer | 175 | 250 |
| 5 | Publisher | 150 | 250 |
| 6 | Managing Editor | 140 | 225 |
| 7 | Marketing Manager | 120 | 200 |
| 8 | Public Relations Manager | 100 | 175 |
| 9 | Acquisitions Manager | 75 | 175 |
| 10 | Productions Manager | 75 | 165 |
| 11 | Operations Manager | 75 | 150 |
| 12 | Editor | 25 | 100 |
| 13 | Sales Representative | 25 | 100 |
| 14 | Designer | 25 | 100 |