## Journalists

id | name | email | phoneNumber | languages
--- | --- | --- | --- | ---
1 | John Doe | john@example.com | +1234567890 | English and Spanish
2 | Jane Smith | jane@example.com | +9876543210 | German and French

## Editors

id | name | email | phoneNumber | languages
--- | --- | --- | --- | ---
1 | Michael Johnson | michael@example.com | +0987654321 | English and Spanish
2 | Emily Davis | emily@example.com | +1234567890 | Italian and Portuguese

## Publications

id | title | publicationDate
--- | --- | ---
1 | The Daily News | 2021-01-01
2 | Weekly Times | 2021-01-15

## Articles

id | title | content | publishDate | editorId
--- | --- | --- | --- | ---
|  |  |  | (→ Editors.id)
1 | Article 1 | Content of Article 1 | 2021-01-01 | 1
2 | Article 2 | Content of Article 2 | 2021-01-15 | 2

## ArticleAuthors

articleId | journalistId
--- | ---
(→ Articles.id) | (→ Journalists.id)
1 | 1
2 | 2

## Subscriptions

id | subscriberEmail | subscriptionType
--- | --- | ---
1 | subscription1@example.com | Premium
2 | subscription2@example.com | Standard