id | name | publication_date |
---|---|---|
1 | The Daily News | 2021-08-01 |
2 | The Weekly Times | 2021-09-01 |
3 | Daily Post | 2021-10-01 |
4 | Weekend Review | 2021-11-01 |
5 | Morning Briefing | 2021-12-01 |
id | column_name |
---|---|
1 | Opinion |
2 | Lifestyle |
3 | Politics |
4 | Technology |
5 | Fashion |
id | first_name | last_name | |
---|---|---|---|
1 | John | Smith | johnsmith@example.com |
2 | Jane | Doe | janedoe@example.com |
3 | Tom | Brown | tom@brown.com |
4 | Alice | Green | alicelgreen@gmail.com |
5 | Robert | White | robertwhite@hotmail.com |
id | title | content | publish_date | newspaper_id | writer_id |
---|---|---|---|---|---|
(→ Newspapers.id) | (→ Writers.id) | ||||
1 | How Technology is Changing Our Lives | In this article... | 2021-10-03 10:00:00 | 2 | 1 |
2 | The Impact of Politics on Society | This piece discusses... | 2021-11-07 16:00:00 | 4 | 3 |
3 | A Look at Fashion Trends | Here we explore... | 2021-12-12 09:00:00 | 1 | 4 |
4 | Life Hacks from Opinion Columnists | Some useful tips... | 2021-11-22 14:00:00 | 3 | 2 |
5 | Understanding Modern Technologies | Exploring the latest tech... | 2021-12-17 08:00:00 | 1 | 5 |
newspaper_id | column_id |
---|---|
(→ Newspapers.id) | (→ Columns.id) |
1 | 1 |
1 | 2 |
2 | 1 |
2 | 3 |
3 | 1 |
4 | 1 |
5 | 1 |