# # ChangeLog for sql # # Generated by Trac 1.6.1.dev0 # 09/24/26 00:08:33 Wed, 23 Sep 2026 12:02:31 GMT Stefan-Saveski [2853f2e] * sql/perf/after_dossier_one.txt (added) * sql/perf/after_gradebook.txt (added) * sql/perf/after_rep_busiest_professor.txt (added) * sql/perf/after_rep_semester_growth.txt (added) * sql/perf/after_rep_student_dossier.txt (added) * sql/perf/after_rep_subject_pass_rate.txt (added) * sql/perf/after_rep_top_student_per_major.txt (added) * sql/perf/before_dossier_one.txt (added) * sql/perf/before_gradebook.txt (added) * sql/perf/before_rep_busiest_professor.txt (added) * sql/perf/before_rep_semester_growth.txt (added) * sql/perf/before_rep_student_dossier.txt (added) * sql/perf/before_rep_subject_pass_rate.txt (added) * sql/perf/before_rep_top_student_per_major.txt (added) * sql/perf/indexes.sql (added) * sql/perf/perf_data.sql (added) * sql/perf/perf_schema.sql (added) Add performance analysis scripts and schema for educational database ... Wed, 23 Sep 2026 11:29:12 GMT Stefan-Saveski [e7bafc0] * docs/Ph6.md (added) * sql/reports.sql (added) Merge remote-tracking branch 'origin/phase6-reports' Wed, 23 Sep 2026 11:15:50 GMT Stefan-Saveski [8ee90bd] * sql/advanced.sql (added) Add advanced database development script for Phase 7 normalization Wed, 16 Sep 2026 20:22:43 GMT Boris Gjorgjievski [bcacc91] * docs/Ph6.md (added) * sql/reports.sql (added) Phase 6: advanced reports as SQL, relational algebra and stored ... Wed, 16 Sep 2026 12:48:55 GMT Stefan-Saveski [c42181c] * iknow-api/Data/AppDbContext.cs (modified) * iknow-api/Models/Payment.cs (modified) * iknow-api/Models/User.cs (modified) * sql/data_load.sql (modified) * sql/iknow.dbml (modified) * sql/schema.md (modified) * sql/schema_creation.sql (modified) Refactor payment model to remove redundant user_id, addressing BCNF ... Tue, 15 Sep 2026 19:15:53 GMT Stefan-Saveski [1b20b22] * Program.cs (deleted) * iknow-api/Controllers/AdminController.cs (added) * iknow-api/Controllers/DbHealthController.cs (added) * iknow-api/Controllers/EnrollmentController.cs (added) * iknow-api/Controllers/ProfController.cs (added) * iknow-api/Controllers/UserController.cs (modified) * iknow-api/Controllers/WeatherForecastController.cs (deleted) * iknow-api/DTOs/AdminDTO.cs (added) * iknow-api/DTOs/EnrollmentDTO.cs (added) * iknow-api/DTOs/ProfDTO.cs (added) * iknow-api/Data/AppDbContext.cs (modified) * iknow-api/Data/PgEnumLabels.cs (added) * iknow-api/Migrations/20251216191800_InitialCreate.Designer.cs (deleted) * iknow-api/Migrations/20251216191800_InitialCreate.cs (deleted) * iknow-api/Migrations/AppDbContextModelSnapshot.cs (deleted) * iknow-api/Models/EnrolledSemesters.cs (modified) * iknow-api/Models/EnrollmentInfo.cs (deleted) * iknow-api/Models/HighSchool.cs (modified) * iknow-api/Models/MajorSubjects.cs (modified) * iknow-api/Models/Payment.cs (modified) * iknow-api/Models/Quota.cs (added) * iknow-api/Models/SemesterSubjects.cs (modified) * iknow-api/Models/User.cs (modified) * iknow-api/Program.cs (modified) * iknow-api/Repository/Implementations/ProfRepository.cs (added) * iknow-api/Repository/Implementations/RefreshTokenRepository.cs (modified) * iknow-api/Repository/Implementations/UserRepository.cs (modified) * iknow-api/Repository/Interface/IProfRepository.cs (added) * iknow-api/Repository/Interface/IUserRepository.cs (modified) * iknow-api/Services/Implementations/AdminService.cs (added) * iknow-api/Services/Implementations/AuthService.cs (modified) * iknow-api/Services/Implementations/EnrollmentService.cs (added) * iknow-api/Services/Implementations/ProfService.cs (added) * iknow-api/Services/Implementations/RefreshTokenService.cs (modified) * iknow-api/Services/Interfaces/IAdminService.cs (added) * iknow-api/Services/Interfaces/IEnrollmentService.cs (added) * iknow-api/Services/Interfaces/IProfService.cs (added) * iknow-api/WeatherForecast.cs (deleted) * iknow-api/appsettings.Development.json.example (added) * iknow-api/appsettings.json (modified) * sql/data_load.sql (added) * sql/iknow.dbml (added) * sql/relational_schema.png (added) * sql/schema.md (added) * sql/schema_creation.sql (added) - ready for presentation Tue, 15 Sep 2026 19:15:53 GMT Stefan-Saveski [ea40556] * Program.cs (deleted) * iknow-api/Controllers/AdminController.cs (added) * iknow-api/Controllers/DbHealthController.cs (added) * iknow-api/Controllers/EnrollmentController.cs (added) * iknow-api/Controllers/ProfController.cs (added) * iknow-api/Controllers/UserController.cs (modified) * iknow-api/Controllers/WeatherForecastController.cs (deleted) * iknow-api/DTOs/AdminDTO.cs (added) * iknow-api/DTOs/EnrollmentDTO.cs (added) * iknow-api/DTOs/ProfDTO.cs (added) * iknow-api/Data/AppDbContext.cs (modified) * iknow-api/Data/PgEnumLabels.cs (added) * iknow-api/Migrations/20251216191800_InitialCreate.Designer.cs (deleted) * iknow-api/Migrations/20251216191800_InitialCreate.cs (deleted) * iknow-api/Migrations/AppDbContextModelSnapshot.cs (deleted) * iknow-api/Models/EnrolledSemesters.cs (modified) * iknow-api/Models/EnrollmentInfo.cs (deleted) * iknow-api/Models/HighSchool.cs (modified) * iknow-api/Models/MajorSubjects.cs (modified) * iknow-api/Models/Payment.cs (modified) * iknow-api/Models/Quota.cs (added) * iknow-api/Models/SemesterSubjects.cs (modified) * iknow-api/Models/User.cs (modified) * iknow-api/Program.cs (modified) * iknow-api/Repository/Implementations/ProfRepository.cs (added) * iknow-api/Repository/Implementations/RefreshTokenRepository.cs (modified) * iknow-api/Repository/Implementations/UserRepository.cs (modified) * iknow-api/Repository/Interface/IProfRepository.cs (added) * iknow-api/Repository/Interface/IUserRepository.cs (modified) * iknow-api/Services/Implementations/AdminService.cs (added) * iknow-api/Services/Implementations/AuthService.cs (modified) * iknow-api/Services/Implementations/EnrollmentService.cs (added) * iknow-api/Services/Implementations/ProfService.cs (added) * iknow-api/Services/Implementations/RefreshTokenService.cs (modified) * iknow-api/Services/Interfaces/IAdminService.cs (added) * iknow-api/Services/Interfaces/IEnrollmentService.cs (added) * iknow-api/Services/Interfaces/IProfService.cs (added) * iknow-api/WeatherForecast.cs (deleted) * iknow-api/appsettings.Development.json.example (added) * iknow-api/appsettings.json (modified) * sql/data_load.sql (added) * sql/iknow.dbml (added) * sql/relational_schema.png (added) * sql/schema.md (added) * sql/schema_creation.sql (added) - ready for presentation