## Media_Types

ID | TypeName
--- | ---
1 | Print
2 | Online

## Jobs

ID | Title | Description | Salary | PostedDate | ClosingDate | Status | MediaTypeID | LanguageProficiencyID
--- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  |  | (→ Media_Types.ID) | (→ Languages.ID)
1 | Journalist | Write news articles for a newspaper. | 60000.0 | 2021-09-01 | 2021-09-30 | Open | 1 | 1
2 | Journalist | Create content for an online magazine. | 70000.0 | 2021-08-15 | 2021-09-15 | Open | 2 | 1
3 | Editor | Edit and proofread articles for a print publication. | 75000.0 | 2021-09-10 | 2021-09-25 | Open | 1 | 1
4 | Editor | Review and edit content for an ebook publisher. | 80000.0 | 2021-08-20 | 2021-09-20 | Open | 4 | 2
5 | Graphic Designer | Design layouts and visual elements for magazines. | 65000.0 | 2021-09-05 | 2021-09-25 | Open | 2 | 3
6 | Web Developer | Develop websites and manage online presence. | 85000.0 | 2021-08-25 | 2021-09-30 | Open | 3 | 1
7 | Data Analyst | Analyze and interpret data for various industries. | 90000.0 | 2021-09-10 | 2021-09-25 | Closed | 5 | 1

## Media_Types_Values

ID | Value
--- | ---
1 | Newspaper
2 | Magazine
3 | Blog
4 | Ebook
5 | Podcast

## Jobs_Values

ID | JobID | ValueID
--- | --- | ---
| (→ Jobs.ID) | (→ Media_Types_Values.ID)
1 | 1 | 1
2 | 1 | 2
3 | 3 | 1
4 | 4 | 4
5 | 5 | 5
6 | 7 | 3
7 | 7 | 5

## Languages

ID | Name
--- | ---
1 | English
2 | Spanish
3 | French