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 |