Persons
PersonID | FullName |
1 | John Doe |
2 | Jane Smith |
3 | Emily Johnson |
4 | Michael Brown |
5 | Cathy Williams |
Articles
ArticleID | Title | Content | AuthorID |
| | | (→ Persons.PersonID) |
1 | Article 1 | Content of article 1... | 1 |
2 | Article 2 | Content of article 2... | 2 |
3 | Article 3 | Content of article 3... | 3 |
4 | Article 4 | Content of article 4... | 4 |
5 | Article 5 | Content of article 5... | 5 |
MediaScrums
MediaScrumID | Description | StartTime | EndTime | PersonID |
| | | | (→ Persons.PersonID) |
1 | Desc 1 | 10:00 | 11:00 | 1 |
2 | Desc 2 | 12:00 | 13:00 | 3 |
3 | Desc 3 | 14:00 | 15:00 | 5 |
4 | Desc 4 | 16:00 | 17:00 | 2 |
5 | Desc 5 | 18:00 | 19:00 | 4 |
Events
EventID | EventName | EventType | Date | Location | PersonID |
| | | | | (→ Persons.PersonID) |
1 | New Year Press | Press Conference | 2022-01-01 | New York | 1 |
2 | LA Launch | Press Conference | 2022-02-01 | Los Angeles | 2 |
3 | Spring Scrum | Media Scrum | 2022-03-01 | Chicago | 1 |
4 | Dallas Debate | Media Scrum | 2022-04-01 | Dallas | 3 |
5 | Capitol Interview | Interview | 2022-05-01 | Washington | 4 |