id | name | amount |
---|---|---|
1 | Academic Excellence Scholarship | 2000.0 |
2 | Service Leadership Scholarship | 1500.0 |
3 | Young Leader Scholarship | 1000.0 |
4 | Needy Student Grant | 500.0 |
5 | Artistic Talent Award | 750.0 |
id | value |
---|---|
1 | Academic Achievement |
2 | Community Service |
3 | Leadership Skills |
4 | Financial Need |
5 | Extracurricular Activities |
scholarship_id | criterion_id |
---|---|
(→ Scholarships.id) | (→ Criteria.id) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 2 |
student_id | first_name | last_name | phone_number | admission_date | |
---|---|---|---|---|---|
1 | John | Doe | john.doe@example.com | +123-456-7890 | 2021-08-01 |
2 | Jane | Smith | jane.smith@example.com | +123-456-7890 | 2021-08-01 |
3 | Tom | Brown | tom.brown@example.com | +123-456-7890 | 2021-08-01 |
4 | Alice | Green | alice.green@example.com | +123-456-7890 | 2021-08-01 |
5 | Mike | Black | mike.black@example.com | +123-456-7890 | 2021-08-01 |
application_id | student_id | scholarship_id | submission_date | status |
---|---|---|---|---|
(→ Students.student_id) | (→ Scholarships.id) | |||
1 | 1 | 1 | 2021-09-01 | Pending |
2 | 2 | 2 | 2021-09-01 | Approved |
3 | 3 | 3 | 2021-09-01 | Rejected |
4 | 4 | 4 | 2021-09-01 | Under Review |
5 | 5 | 5 | 2021-09-01 | Withdrawn |