Database Examples/Pubs/Jobs
< Database Examples | Pubs
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 |