AuthorID | Name | BirthDate | Country |
---|---|---|---|
1 | John Doe | 2000-01-01 | USA |
2 | Jane Smith | 1985-06-15 | Canada |
ArticleID | Title | Content | PublishDate | ViewCount |
---|---|---|---|---|
1 | Test article title | This is a test article content. | 2022-01-01 | 0 |
2 | Another test article | Here is another piece of test content. | 2022-01-02 | 0 |
PublisherID | CompanyName | Address | Website |
---|---|---|---|
1 | Example Publishing | 123 Example St, Example City | http://www.examplepublishing.com |
2 | Sample Publishing | 456 Sample Ave, Sample Town | http://www.samplepublishing.org |
AuthorID | ArticleID | DatePublished |
---|---|---|
(→ Authors.AuthorID) | (→ Articles.ArticleID) | |
1 | 1 | 2022-01-01 |
2 | 2 | 2022-01-02 |
SupportID | Type | Amount | Description | DateReceived | ForeignKeyId |
---|---|---|---|---|---|
(→ Publications.PublisherID) | |||||
1 | Donations | 30000.0 | A large donation received from an anonymous source. | 2021-12-31 | 1 |
2 | Donations | 25000.0 | Smaller donation received from a fan. | 2022-01-01 | 1 |
3 | Grant Funding | 30000.0 | A research grant was awarded by the government. | 2021-12-31 | 2 |
4 | Grant Funding | 27000.0 | A smaller grant received for community outreach programs. | 2022-01-01 | 2 |