| 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 |
| id | column_name |
|---|---|
| 1 | Editor's Letter |
| 2 | Feature Story |
| 3 | Opinion Piece |
| 4 | Book Reviews |
| 5 | Travel Guide |
| id | first_name | last_name | |
|---|---|---|---|
| 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 |
| 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_id | author_id |
|---|---|
| (→ Magazines.id) | (→ Authors.id) |
| 1 | 1 |
| 1 | 2 |
| 2 | 3 |
| 2 | 4 |
| 3 | 5 |
| 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 |