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 |