Column_name | Data type | Nullable | Default | Check | Key/index |
---|---|---|---|---|---|
job_id | smallint | no | IDENTITY(1,1) | PK, clust | |
stor_id | char(4) | no | yes1 | ||
min_lvl | tinyint | no | yes2 | ||
max_lvl | tinyint | no | yes3 | ||
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 |