id | contact | department | role | 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 |
id | contact | department | role | 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 |
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 |
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 |
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 |
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 |