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 |
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 |
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 |
id | name | phone_number | |
---|---|---|---|
1 | John Doe | johndoe@example.com | +1234567890 |
2 | Jane Smith | janesmith@example.com | +0987654321 |
id | source_name | contact_details |
---|---|---|
1 | Reuters | reuters@example.com |
2 | Associated Press | ap@example.com |
article_id | source_id |
---|---|
(→ News_Articles.id) | (→ Sources.id) |
1 | 1 |
2 | 2 |