This is a progress tracker I'm making to track my progress throughout different books.
Here's the student tab!
Here's the chapter tab!
And here's the completed chapter tab!
- Core Java 15
- GUI Framework: JavaFX 15
- Database: H2 Embedded
- Data Persistence: Hibernate
The top levels have the column names and associated types
This table keeps track of students, including their IDs and Names
| ID(Long) | FIRSTNAME(String) | LASTNAME(String) |
|---|---|---|
| 1 | ExampleFirst | ExampleLast |
This table keeps track of how many chapters there are, and their associated titles.
| CHAPTERTITLE(String) | CHAPTERID(Long) | CHAPTERNUM | BOOKTITLE |
|---|---|---|---|
| Chapter 1: Example | 1 | 1 | The Example Book |
This table tracks students' progress, containing the ID of the student who completed the chapter, the ID of the chapter that's been completed, and the date that the chapter has been completed on.
| COMPLETEDCHAPTERID | STUDENTID(Long) | CHAPTERNUMBER(Long) | COMPLETIONDATE(Date) | BOOKTITLE | CHAPTERTITLE |
|---|---|---|---|---|---|
| 1 | 1 | 1 | 2021-1-3 | The Example Book | Chapter 1: Example |