## Public_Relations

id | contact | department | role | email | phone | description
--- | --- | --- | --- | --- | --- | ---
1 | BBC | News Agency | PR Manager | bbc@email.com | 123-456-7890 | Manages PR for BBC News
2 | CNN | News Agency | Director of Communications | cnn@email.com | 987-654-3210 | Oversees communications strategy for CNN

## Government_Communications

id | contact | department | role | email | phone | description
--- | --- | --- | --- | --- | --- | ---
1 | WhiteHouse | Executive Branch | Press Secretary | whitehouse@email.gov | 555-123-4567 | Spokesperson for the White House
2 | StateDept | Executive Branch | Deputy Spokesman | statedept@email.gov | 555-987-6543 | Assists the Press Secretary at State Department

## Contacts

id | name | organization | public_relations_id | government_communications_id
--- | --- | --- | --- | ---
|  |  | (→ Public_Relations.id) | (→ Government_Communications.id)
1 | John Doe | ABC News | 1 | None
2 | Jane Smith | Fox News | 2 | 1
3 | Alice Brown | NBC News | None | 2

## Articles

id | title | content | published_date | author_id
--- | --- | --- | --- | ---
|  |  |  | (→ Authors.id)
1 | Article 1 | Content for Article 1... | 2022-01-01 10:00:00 | 1
2 | Article 2 | Content for Article 2... | 2022-01-02 10:00:00 | 2

## Authors

id | name | organization | public_relations_contact_id | government_communications_contact_id
--- | --- | --- | --- | ---
|  |  | (→ Contacts.public_relations_id) | (→ Contacts.government_communications_id)
1 | Michael Johnson | The Guardian | 1 | 1
2 | Emma Davis | The New York Times | 2 | 2

## Sources

id | name | type | source_url | article_id
--- | --- | --- | --- | ---
|  |  |  | (→ Articles.id)
1 | Source 1 | Website | https://www.source1.com/article | 1
2 | Source 2 | Newspaper | http://newspaper.com/article | 2