Journalists

IDNameAgeExperience
1John Doe302 years
2Jane Smith283 years
3Michael Johnson406 years
4Linda Williams357 years
5David Brown295 years

Editors

IDNameAgePublicationsCount
1Robert White3210
2Emily Black298
3Kevin Green4512
4Laura Blue379
5Chris Red337

Languages

LanguageIDLanguageName
1English
2French
3German
4Spanish
5Italian

Proficiencies

JournalistIDEditorIDLanguageIDProficiencyLevel
(→ Journalists.ID)(→ Editors.ID)(→ Languages.LanguageID)
111Fluent
222Intermediate
333Native
444Advanced
555Beginner

Posts

PostIDTitleDescriptionDeadline
1Breaking News ReporterReport on breaking news stories.2023-04-01
2Feature WriterWrite in-depth articles and features.2023-04-15
3Investigative JournalistConduct investigative journalism.2023-04-30
4News AnchorAnchor daily news broadcasts.2023-05-10
5ReporterCover local events and write reports.2023-05-15

Assignments

AssignmentIDPostIDJournalistIDEditorID
(→ Posts.PostID)(→ Journalists.ID)(→ Editors.ID)
1111
2222
3333
4444
5555