Reporters

idnameemailphone_numberaddress
1John Doejohndoe@example.com123-456-7890123 Main St
2Jane Smithjanesmith@example.com098-765-4321456 Elm St
3Alice Johnsonalicejohnson@example.com555-555-5555789 Oak St
4Bob Brownbobbrown@example.com333-333-3333101 Pine St
5Charlie Greencharliegreen@example.com222-222-2222111 Maple Ave

Photographers

idnameemailphone_numberaddress
1David Whitedavidwhite@example.com444-444-4444234 Birch St
2Eva Blackevablack@example.com666-666-6666345 Cedar St
3Frank Redfrankred@example.com777-777-7777456 Walnut St
4Grace Bluegraceblue@example.com888-888-8888567 Willow St
5Hannah Greenhannahgreen@example.com999-999-9999678 Sycamore St

Articles

idtitlecontentdeadlinereporter_idphotographer_id
(→ Reporters.id)(→ Photographers.id)
1Article Title 1Content of Article 12020-04-2511
2Article Title 2Content of Article 22020-04-2622
3Article Title 3Content of Article 32020-04-2733
4Article Title 4Content of Article 42020-04-2844
5Article Title 5Content of Article 52020-04-2955

Sources

idnamecontact_infotype
1Source Asourcea@example.comGovernment Agency
2Source Bsourceb@example.comNGO
3Source Csourcec@example.comPrivate Company
4Source Dsourced@example.comAcademic Institution
5Source Esourcee@example.comJournalist Association

ArticleSources

article_idsource_idrelationship
(→ Articles.id)(→ Sources.id)
11Primary Source
12Secondary Source
23Expert Interview
24Background Information
35Press Release

ReaderComments

comment_idreader_nameemailcommentarticle_id
(→ Articles.id)
1Reader 1reader1@example.comGreat article!1
2Reader 2reader2@example.comInteresting perspective.2
3Reader 3reader3@example.comI disagree with the conclusion.3
4Reader 4reader4@example.comThis is misleading information.4
5Reader 5reader5@example.comWell-written and informative.5