ArticleID | Title | Content | PublishDate | AuthorID |
---|---|---|---|---|
(→ Authors.AuthorID) | ||||
1 | Breaking News: Earth Shake | A powerful earthquake hits California | 2024-03-07 23:25:22 | 1 |
2 | Tech Giants Merge | Apple and Google announce a merger | 2024-03-07 23:25:22 | 2 |
AuthorID | Name | PhoneNumber | Classification | Payment | |
---|---|---|---|---|---|
1 | John Doe | johndoe@example.com | +1234567890 | Stringer | 2000 |
2 | Jane Smith | janesmith@example.com | +0987654321 | Stringer | 3000 |
3 | Alice Johnson | alicejohnson@example.com | +1357924680 | Editor | 2000 |
4 | Bob Brown | bobbrown@example.com | +2468135790 | Editor | 2500 |
OutletID | Name | Location | Website |
---|---|---|---|
1 | Global Times | New York, USA | https://www.globaltimes.com |
2 | European Gazette | London, UK | https://www.europeangazette.co.uk |
SubmissionID | ArticleID | OutletID | Accepted |
---|---|---|---|
(→ Articles.ArticleID) | (→ NewsOutlets.OutletID) | ||
1 | 1 | 1 | 1 |
2 | 2 | 2 | 0 |
SourceID | Name | ContactInfo | Reliability | LastUsed |
---|---|---|---|---|
1 | Washington Post | washpost@example.com | 4 | 2021-07-01 12:00:00 |
2 | Reuters | reuters@example.com | 5 | 2021-07-15 15:30:00 |