Database Examples/Pubs/Jobs

< Database Examples < Pubs

Fields

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

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
This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.