Transact-SQL Reference
jobs
| Column_name | Data type | Nullable | Default | Check | Key/index |
|---|---|---|---|---|---|
| job_id | smallint | no | IDENTITY(1,1) | PK, clust | |
| stor_id | char(4) | no | yes 1 | ||
| min_lvl | tinyint | no | yes 2 | ||
| max_lvl | tinyint | no | yes 3 |
(1) The DEFAULT constraint is defined as ("New Position - title not formalized yet").
(2) The min_lvl CHECK constraint is defined as (min_lvl >= 10).
(3) The max_lvl CHECK constraint is defined as (max_lvl <= 250).
This table shows the contents of the jobs table.
| 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 |