id | title | content | publishDate | authorId | publicationId | topicId |
---|---|---|---|---|---|---|
(→ journalists.id) | (→ publications.id) | (→ topics.id) | ||||
1 | Breaking News: New Government Policy | The government has announced a new policy that will impact citizens. | 2023-04-01T10:00:00Z | 1 | 1 | 1 |
2 | Economic Outlook for Q2 | Experts discuss the economic outlook for the second quarter. | 2023-04-02T10:00:00Z | 2 | 2 | 3 |
id | name | address |
---|---|---|
1 | Daily Times | 123 Main St, Anytown, USA |
2 | Weekly Post | 456 Elm St, Anycity, USA |
id | description |
---|---|
1 | Government and Politics |
2 | Business and Economy |
id | name | phoneNumber | Qualification | Investigative_Journalist | |
---|---|---|---|---|---|
1 | John Doe | john@example.com | 123-456-7890 | Bachelor of Arts in Journalism | 1 |
2 | Jane Smith | jane@example.com | 098-765-4321 | Master of Science in Communication | 0 |