T012: Apply EF Core migration to database #48
Description
Phase 2: Foundational
Task: T012
Status: Not Started
Story: Foundational (blocking all user stories)
Depends On: T011 (migration created)
Description
Apply EF Core migration to database to create Certificate-related tables.
Acceptance Criteria
- Run:
dotnet ef database update --context CourseRegistrationDbContext --project CourseRegistration.Infrastructure - All tables created successfully:
- Certificate table exists with correct schema
- CertificateVerification table exists
- CertificateAuditLog table exists
- All indexes created and verified (query execution plans use indexes)
- All constraints enforced at database level
- Database schema matches data-model.md specifications
- Migration can be rolled back:
dotnet ef database update <previous-migration>
Effort Estimate
1 hour
References
- data-model.md: Full schema specification
- plan.md: Technical Context (SQL Server)