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 |