| id | Date | Location | Participant_Type | Speaker1 | Speaker2 |
|---|---|---|---|---|---|
| 1 | 2023-01-01 | White House | Politician | President John Doe | None |
| 2 | 2023-01-02 | City Hall | Government Official | Mayor Jane Smith | None |
| id | Date | Location | Interviewer | Participant_Type | Topic |
|---|---|---|---|---|---|
| 1 | 2023-01-03 | Studio A | Journalist Mike Brown | Politician | Economy |
| 2 | 2023-01-04 | Studio B | Journalist Susan White | Business Leader | Market Trends |
| id | Title | Author | Publication_Date | Content |
|---|---|---|---|---|
| 1 | Article Title 1 | Author 1 | 2023-01-05 | Content of Article 1 |
| 2 | Article Title 2 | Author 2 | 2023-01-06 | Content of Article 2 |
| id | Name | Type | Contact_Info |
|---|---|---|---|
| 1 | Source Name 1 | Newspaper | source@email.com; +1234567890 |
| 2 | Source Name 2 | Magazine | source2@email.com; +0987654321 |
| id | Word |
|---|---|
| 1 | Keyword 1 |
| 2 | Keyword 2 |
| 3 | Keyword 3 |
| 4 | Keyword 4 |
| 5 | Keyword 5 |
| article_id | keyword_id |
|---|---|
| (→ Articles.id) | (→ Keywords.id) |
| 1 | 1 |
| 1 | 2 |
| 2 | 3 |
| 2 | 4 |
| 2 | 5 |