## Magazines

id | name | publication_date | editor_name
--- | --- | --- | ---
1 | The Daily Times | 2021-06-01 | John Smith
2 | Weekly News Digest | 2021-07-01 | Jane Doe
3 | Monthly Business Review | 2021-08-01 | Tom Brown
4 | Technology Insider | 2021-09-01 | Emily White
5 | Fashion World | 2021-10-01 | Michael Black

## Columns

id | column_name
--- | ---
1 | Editor's Letter
2 | Feature Story
3 | Opinion Piece
4 | Book Reviews
5 | Travel Guide

## Authors

id | first_name | last_name | email
--- | --- | --- | ---
1 | Alex | Smith | alex@gmail.com
2 | Linda | Doe | linda@yahoo.com
3 | Robert | Brown | robert@hotmail.com
4 | Cathy | White | cathy@aol.com
5 | David | Black | david@protonmail.com

## Articles

id | title | content | publish_date | magazine_id | author_id
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Magazines.id) | (→ Authors.id)
1 | First Article Title | Content of First Article... | 2021-06-01 | 1 | 1
2 | Second Article Title | Content of Second Article... | 2021-06-03 | 1 | 2
3 | Third Article Title | Content of Third Article... | 2021-06-05 | 2 | 3
4 | Fourth Article Title | Content of Fourth Article... | 2021-06-07 | 2 | 4
5 | Fifth Article Title | Content of Fifth Article... | 2021-06-09 | 2 | 5

## Magazine_Authors

magazine_id | author_id
--- | ---
(→ Magazines.id) | (→ Authors.id)
1 | 1
1 | 2
2 | 3
2 | 4
3 | 5

## Magazines_Columns

magazine_id | column_id | issue_date
--- | --- | ---
(→ Magazines.id) | (→ Columns.id) |
1 | 1 | 2021-06-01
1 | 2 | 2021-06-01
2 | 1 | 2021-07-01
2 | 2 | 2021-07-01
3 | 1 | 2021-08-01
3 | 2 | 2021-08-01
4 | 1 | None
5 | 1 | None