| id | name | frequency | language | issue_date | format_type |
|---|---|---|---|---|---|
| (→ Newspaper_Formats.id) | |||||
| 1 | The Daily Post | Daily | English | 2023-01-01 | 1 |
| 2 | Financial Times | Weekly | English | 2023-01-06 | 2 |
| id | format_name |
|---|---|
| 1 | Broadsheet |
| 2 | Tabloid |
| id | title | content | publish_date | newspaper_id |
|---|---|---|---|---|
| (→ Newspapers.id) | ||||
| 1 | First Article | This is the first article. | 2023-01-01 10:00:00 | 1 |
| 2 | Second Article | This is the second article. | 2023-01-07 10:00:00 | 2 |
| id | first_name | last_name | |
|---|---|---|---|
| 1 | John | Smith | johnsmith@example.com |
| 2 | Jane | Doe | janedoe@example.com |
| 3 | Michael | Brown | mikebrown@example.com |
| 4 | Emily | White | emwhite@example.com |
| article_id | author_id |
|---|---|
| (→ Articles.id) | (→ Authors.id) |
| 1 | 1 |
| 2 | 2 |
| 3 | 3 |
| 4 | 4 |
| id | company_name | location |
|---|---|---|
| 1 | Sainsbury's | London |
| 2 | Tesco | Manchester |
| newspaper_id | distributor_id | quantity |
|---|---|---|
| (→ Newspapers.id) | (→ Distributors.id) | |
| 1 | 1 | 1000 |
| 2 | 1 | 800 |
| 1 | 2 | 900 |
| 2 | 2 | 700 |