Authors
id | name | email |
1 | Author1 | a1@example.com |
2 | Author2 | a2@example.com |
3 | Author3 | a3@example.com |
4 | Author4 | a4@example.com |
5 | Author5 | a5@example.com |
Articles
id | title | content | published_date | author_id |
| | | | (→ Authors.id) |
1 | Article1 | Content of Article1 | 2021-08-01 | 1 |
2 | Article2 | Content of Article2 | 2021-09-01 | 2 |
3 | Article3 | Content of Article3 | 2021-10-01 | 3 |
4 | Article4 | Content of Article4 | 2021-11-01 | 4 |
5 | Article5 | Content of Article5 | 2021-12-01 | 5 |
Donors
id | first_name | last_name | email |
1 | Donor1 | LastName1 | d1@example.com |
2 | Donor2 | LastName2 | d2@example.com |
3 | Donor3 | LastName3 | d3@example.com |
4 | Donor4 | LastName4 | d4@example.com |
5 | Donor5 | LastName5 | d5@example.com |
DonationRecords
id | donor_id | article_id | amount |
| (→ Donors.id) | (→ Articles.id) | |
1 | 1 | 1 | 30000 |
2 | 2 | 2 | 10000 |
3 | 3 | 3 | 5000 |
4 | 4 | 4 | 7000 |
5 | 5 | 5 | 6000 |
Grants
id | grant_name | funding_amount | awarded_to_articles |
1 | Grants1 | 30000 | 1 |
2 | Grants2 | 50000 | 2 |
3 | Grants3 | 40000 | 3 |
4 | Grants4 | 20000 | 4 |
5 | Grants5 | 35000 | 5 |
GrantFundings
id | grant_id | article_id | amount |
| (→ Grants.id) | (→ Articles.id) | |
1 | 1 | 1 | 30000 |
2 | 2 | 2 | 10000 |
3 | 3 | 3 | 5000 |
4 | 4 | 4 | 7000 |
5 | 5 | 5 | 6000 |