Press_Conferences

idDateLocationParticipant_TypeSpeaker1Speaker2
12023-01-01White HousePoliticianPresident John DoeNone
22023-01-02City HallGovernment OfficialMayor Jane SmithNone

Interviews

idDateLocationInterviewerParticipant_TypeTopic
12023-01-03Studio AJournalist Mike BrownPoliticianEconomy
22023-01-04Studio BJournalist Susan WhiteBusiness LeaderMarket Trends

Articles

idTitleAuthorPublication_DateContent
1Article Title 1Author 12023-01-05Content of Article 1
2Article Title 2Author 22023-01-06Content of Article 2

Sources

idNameTypeContact_Info
1Source Name 1Newspapersource@email.com; +1234567890
2Source Name 2Magazinesource2@email.com; +0987654321

Keywords

idWord
1Keyword 1
2Keyword 2
3Keyword 3
4Keyword 4
5Keyword 5

Article_Keywords

article_idkeyword_id
(→ Articles.id)(→ Keywords.id)
11
12
23
24
25