Jump to content

Database Examples/Pubs/Jobs

From Wikiversity

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