| 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 |