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 |