id | section_name |
---|---|
1 | Local News |
2 | National News |
3 | World News |
4 | Technology |
5 | Entertainment |
id | newspaper_name |
---|---|
1 | The Times |
2 | Daily Mail |
3 | Financial Times |
4 | Guardian |
5 | Independent |
id | article_title | article_content | publication_date |
---|---|---|---|
1 | Brexit Updates | Latest news on Brexit. | 2024-01-30 19:19:35 |
2 | Coronavirus Update | Latest updates on coronavirus situation around the world. | 2024-01-30 19:19:35 |
id | author_name |
---|---|
1 | John Smith |
2 | Jane Doe |
3 | Alice Johnson |
4 | Bob Brown |
5 | Charlie White |
newspaper_id | author_id |
---|---|
(→ Newspapers.id) | (→ Authors.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
article_id | author_id |
---|---|
(→ Articles.id) | (→ Authors.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
newspaper_id | section_id |
---|---|
(→ Newspapers.id) | (→ Sections.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
2 | 3 |
1 | 3 |
4 | 3 |
5 | 3 |