jobs (T-SQL)

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

  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.