Authors
id | name | email | phone | address |
1 | John Doe | john@example.com | 123-456-7890 | 123 Main St |
2 | Jane Smith | jane@example.com | 987-654-3210 | 456 Elm St |
3 | Alice Brown | alice@example.com | 555-555-5555 | 789 Oak St |
4 | Bob Johnson | bob@example.com | 111-222-3333 | 100 Pine St |
5 | Charlie Davis | charlie@example.com | 444-444-4444 | 200 Maple Ave |
Publications
id | name | circulation_numbers | location |
1 | The Daily News | 20000 | USA |
2 | The Weekly Times | 15000 | Canada |
3 | Time Magazine | 20000 | USA |
4 | Newsweek | 12000 | UK |
5 | Business Today | 10000 | India |
Articles
id | title | content | pub_date | author_id | publication_type |
| | | | (→ Authors.id) | |
1 | Article Title 1 | Content of Article 1 | 2022-01-01 | 1 | Print |
2 | Article Title 2 | Content of Article 2 | 2022-01-02 | 2 | Online |
3 | Article Title 3 | Content of Article 3 | 2022-01-03 | 3 | Print |
4 | Article Title 4 | Content of Article 4 | 2022-01-04 | 4 | Online |
5 | Article Title 5 | Content of Article 5 | 2022-01-05 | 5 | Print |
Category
id | descr |
1 | Politics |
2 | Economy |
3 | Technology |
4 | Entertainment |
5 | Sports |
ArticleCategory
article_id | cat_id |
(→ Articles.id) | (→ Category.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
PublicationsPeriodicals
publication_id | periodical_type |
(→ Publications.id) | |
1 | Newspaper |
2 | Newspaper |
3 | Magazine |
4 | Magazine |
5 | Journal |