| 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 |