Authors

AuthorIDFirstNameLastNameEmailAddress
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com

Articles

ArticleIDTitleContentPublishDateAuthorID
(→ Authors.AuthorID)
1Article 1Content of article 1.2024-03-13 15:02:411
2Article 2Content of article 2.2024-03-13 15:02:412

Events

EventIDNameLocationDate
1Turkey–Syria EarthquakesEurasia Region2023-02-06 10:00:00
2Another EventSomewhere Else2023-02-07 10:00:00

CategoryTable

CategoryIDType
1Breaking News
2News Analysis

EventCategoryRelationTable

EventIDCategoryID
(→ Events.EventID)(→ CategoryTable.CategoryID)
11
21
12
22