Databases > pubs > Tables > jobs

pubs

jobs

Created: Modified:

Columns

  • job_id
    [smallint] IDENTITY (1,1) NOT NULL
  • job_desc
    [varchar](50) NOT NULL DEFAULT ('New Position - title not formalized yet')
  • min_lvl
    [tinyint] NOT NULL
    //
    CONSTRAINT
    ([min_lvl]>=(10))
  • max_lvl
    [tinyint] NOT NULL
    //
    CONSTRAINT
    ([max_lvl]<=(250))

Indexes

  • PK__jobs__6E32B6A5C7EA10F9
    UNIQUE CLUSTERED
    job_id

Sample Data

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 Officier
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