Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

jobs

SQL Server 2000
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

  

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.