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 |