## Public_Relations

id | organization | contacts | description | created_at
--- | --- | --- | --- | ---
1 | BBC | +1234567890 | A leading global broadcasting corporation | 2024-03-13 18:14:54
2 | CNN | +9876543210 | An American basic cable and satellite television news channel | 2024-03-13 18:14:54

## Government_Communications

id | government_agency | contacts | description | created_at
--- | --- | --- | --- | ---
1 | White House | +0987654321 | The official residence and workplace of the President of the United States | 2024-03-13 18:14:54
2 | Department of State | +1234567890 | U.S. Department responsible for international relations | 2024-03-13 18:14:54

## News_Articles

id | title | content | author_id | publication_date | public_relations_contact_id
--- | --- | --- | --- | --- | ---
|  |  | (→ Authors.id) |  | (→ Public_Relations.id)
1 | Test Title 1 | This is a test content. | 1 | 2024-03-13 18:14:54 | 1
2 | Test Title 2 | This is another test content. | 2 | 2024-03-13 18:14:54 | 2

## Authors

id | name | email | phone_number
--- | --- | --- | ---
1 | John Doe | johndoe@example.com | +1234567890
2 | Jane Smith | janesmith@example.com | +0987654321

## Sources

id | source_name | contact_details
--- | --- | ---
1 | Reuters | reuters@example.com
2 | Associated Press | ap@example.com

## Article_Sources

article_id | source_id
--- | ---
(→ News_Articles.id) | (→ Sources.id)
1 | 1
2 | 2