jobs

Transact-SQL Reference

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