id | name | phone_number | address | |
---|---|---|---|---|
1 | John Doe | johndoe@example.com | 123-456-7890 | 123 Main St |
2 | Jane Smith | janesmith@example.com | 098-765-4321 | 456 Elm St |
3 | Alice Johnson | alicejohnson@example.com | 555-555-5555 | 789 Oak St |
4 | Bob Brown | bobbrown@example.com | 333-333-3333 | 101 Pine St |
5 | Charlie Green | charliegreen@example.com | 222-222-2222 | 111 Maple Ave |
id | name | phone_number | address | |
---|---|---|---|---|
1 | David White | davidwhite@example.com | 444-444-4444 | 234 Birch St |
2 | Eva Black | evablack@example.com | 666-666-6666 | 345 Cedar St |
3 | Frank Red | frankred@example.com | 777-777-7777 | 456 Walnut St |
4 | Grace Blue | graceblue@example.com | 888-888-8888 | 567 Willow St |
5 | Hannah Green | hannahgreen@example.com | 999-999-9999 | 678 Sycamore St |
id | title | content | deadline | reporter_id | photographer_id |
---|---|---|---|---|---|
(→ Reporters.id) | (→ Photographers.id) | ||||
1 | Article Title 1 | Content of Article 1 | 2020-04-25 | 1 | 1 |
2 | Article Title 2 | Content of Article 2 | 2020-04-26 | 2 | 2 |
3 | Article Title 3 | Content of Article 3 | 2020-04-27 | 3 | 3 |
4 | Article Title 4 | Content of Article 4 | 2020-04-28 | 4 | 4 |
5 | Article Title 5 | Content of Article 5 | 2020-04-29 | 5 | 5 |
id | name | contact_info | type |
---|---|---|---|
1 | Source A | sourcea@example.com | Government Agency |
2 | Source B | sourceb@example.com | NGO |
3 | Source C | sourcec@example.com | Private Company |
4 | Source D | sourced@example.com | Academic Institution |
5 | Source E | sourcee@example.com | Journalist Association |
article_id | source_id | relationship |
---|---|---|
(→ Articles.id) | (→ Sources.id) | |
1 | 1 | Primary Source |
1 | 2 | Secondary Source |
2 | 3 | Expert Interview |
2 | 4 | Background Information |
3 | 5 | Press Release |
comment_id | reader_name | comment | article_id | |
---|---|---|---|---|
(→ Articles.id) | ||||
1 | Reader 1 | reader1@example.com | Great article! | 1 |
2 | Reader 2 | reader2@example.com | Interesting perspective. | 2 |
3 | Reader 3 | reader3@example.com | I disagree with the conclusion. | 3 |
4 | Reader 4 | reader4@example.com | This is misleading information. | 4 |
5 | Reader 5 | reader5@example.com | Well-written and informative. | 5 |