| id | name | phoneNumber | Degree | Certificate | Investigative_Journalist | |
|---|---|---|---|---|---|---|
| 1 | John Doe | john@example.com | 123-456-7890 | Bachelor of Arts in Journalism | Certified Professional Writer | 1 |
| 2 | Jane Smith | jane@example.com | 098-765-4321 | Master of Science in Communication | Advanced Reporting Specialist | 0 |
| 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 | name | contactInfo |
|---|---|---|
| 1 | City Hall | Phone: +1 (555) 123-4567 | Email: cityhall@anycity.gov |
| 2 | Local Police Department | Phone: +1 (555) 987-6543 | Email: police@anystate.us |
| id | description |
|---|---|
| 1 | Government and Politics |
| 2 | Business and Economy |