id | min_age | max_age |
---|---|---|
1 | 18 | 24 |
2 | 25 | 39 |
3 | 40 | 64 |
4 | 65 | 79 |
5 | 80 | 100 |
id | status | description |
---|---|---|
1 | Low | Lower income and less educated |
2 | Middle | Middle income and middle education |
3 | High | Higher income and higher education |
4 | Upper Middle | Affluent with high education |
5 | Elite | Very affluent and highly educated |
id | age_range_id | socioeconomic_status_id |
---|---|---|
(→ Age_Range.id) | (→ Socioeconomic_Status.id) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 5 |
id | author_name | bio |
---|---|---|
1 | Author A | An accomplished journalist known for investigative reporting. |
2 | Author B | A bestselling author who writes about social issues. |
3 | Author C | A renowned foreign correspondent with extensive experience. |
4 | Author D | A Pulitzer Prize-winning reporter covering politics. |
5 | Author E | A freelance writer focusing on environmental topics. |
id | title | content | publish_date | author_id |
---|---|---|---|---|
(→ Authors.id) | ||||
1 | Investigating Corruption | An article exposing corruption in a local government. | 2023-01-01 00:00:00 | 1 |
2 | The Impact of Climate Change | A comprehensive report on climate change effects worldwide. | 2023-01-02 00:00:00 | 2 |
3 | Political Turmoil in Country X | Exploring political unrest and its consequences in an international context. | 2023-01-03 00:00:00 | 3 |
4 | Economic Recovery Strategies | Discussing various approaches to economic recovery after a recession. | 2023-01-04 00:00:00 | 4 |
5 | Preserving Endangered Species | A piece highlighting efforts to protect endangered wildlife species. | 2023-01-05 00:00:00 | 5 |
article_id | reader_id |
---|---|
(→ Articles.id) | (→ Readers.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |