Database Examples/Pubs/Jobs
Appearance
Fields
[edit | edit source]Field Name | Field Type | Length | Index | Constraint | Default |
---|---|---|---|---|---|
job_id | Integer | Primary Key | Not Null | ||
job_desc | Text | 50 | Not Null | ||
min_lvl | Text | 25 | |||
max_lvl | Text | 2 |
Data
[edit | edit source]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 | 125 |
13 | Sales Representative | 25 | 100 |
14 | Designer | 25 | 100 |