| id | title | content | author_id | publication_date |
|---|---|---|---|---|
| (→ Author.id) | ||||
| 1 | Sample Title | Sample Content | 1 | 2024-02-19 14:11:16 |
| 2 | Another Sample Title | More Sample Content | 2 | 2024-02-19 14:11:16 |
| id | name | |
|---|---|---|
| 1 | John Doe | john@example.com |
| 2 | Jane Smith | jane@example.com |
| id | name | education | experience | photojournalist | |
|---|---|---|---|---|---|
| 1 | Tom Brown | tom@example.com | Bachelor of Arts | 5 | 1 |
| 2 | Alice Green | alice@example.com | Master of Science | 8 | 0 |
| id | name | address | contact_email |
|---|---|---|---|
| 1 | Daily News Group | 123 Main St. | editor@dailynewsgroup.com |
| 2 | Weekly Chronicles | 456 Elm St. | editor@weeklychronicles.com |
| id | publisher_id | publication_name | start_year | end_year |
|---|---|---|---|---|
| (→ Publisher.id) | ||||
| 1 | 1 | The Daily Sun | 1900 | None |
| 2 | 2 | The Weekly Herald | 1975 | None |