id | name | participant_type |
---|---|---|
1 | John Doe | Politician |
2 | Jane Smith | Journalist |
3 | Alice Brown | Expert |
4 | Bob Johnson | Politician |
5 | Charlie White | Activist |
id | date | location | topic |
---|---|---|---|
1 | 2023-01-01 10:00:00 | City Hall | Economy |
2 | 2023-01-02 14:00:00 | Government Building | Healthcare |
3 | 2023-01-03 16:00:00 | National Convention Center | Environment |
4 | 2023-01-04 18:00:00 | State House | Education |
5 | 2023-01-05 20:00:00 | Parliament Building | Foreign Affairs |
id | date | location | topic |
---|---|---|---|
1 | 2023-01-06 10:00:00 | Radio Station A | Technology |
2 | 2023-01-07 14:00:00 | TV Studio B | Culture |
3 | 2023-01-08 16:00:00 | Podcast C | Politics |
4 | 2023-01-09 18:00:00 | Newspaper D | History |
5 | 2023-01-10 20:00:00 | Magazine E | Science |
id | participant_id | details |
---|---|---|
(→ Participants.id) | ||
1 | 1 | CEO of Tech Company |
2 | 2 | Investigative Journalist |
3 | 3 | Climate Scientist |
4 | 4 | Lawyer |
5 | 5 | Historian |
id | conference_id | participant_id | role |
---|---|---|---|
(→ Press_Conferences.id) | (→ Participants.id) | ||
1 | 1 | 1 | Spokesperson |
2 | 2 | 2 | Moderator |
3 | 3 | 3 | Panelist |
4 | 4 | 4 | Legal Advisor |
5 | 5 | 5 | Resource Person |
id | article_title | interview_id | press_conference_id | publication_date |
---|---|---|---|---|
(→ Interviews.id) | (→ Press_Conferences.id) | |||
1 | The Future of AI | 1 | None | 2023-01-11 08:00:00 |
2 | Cultural Shifts and Trends | 2 | None | 2023-01-12 09:00:00 |
3 | Impact of Politics on Business | 3 | 1 | 2023-01-13 10:00:00 |
4 | Global Warming Solutions | 4 | 2 | 2023-01-14 11:00:00 |
5 | Revolutionary Advancements in Medicine | 5 | 3 | 2023-01-15 12:00:00 |