# BV-SIS — Registration Database Report

**Date:** 10 July 2026  
**Migration:** `2026_07_10_100000_create_student_registration_tables.php`  
**Verdict:** PASS

---

## Tables (23)

| Table | Purpose |
|-------|---------|
| registration_settings | Number formats & wizard config |
| registration_sessions | Open/close registration windows |
| computer_number_sequences | Sequential computer numbers |
| student_number_sequences | Sequential student numbers |
| students | Master student records |
| student_guardians | Guardians |
| student_sponsors | Sponsors |
| student_emergency_contacts | Emergency contacts |
| student_previous_education | Prior schooling |
| student_medical_records | Medical info |
| semester_registrations | Per-semester registration |
| course_registrations | Enrolled courses |
| programme_switches | Programme change history |
| student_status_changes | Status audit |
| student_transfers | Transfers |
| student_deferments | Deferments |
| student_withdrawals | Withdrawals |
| student_suspensions | Suspensions |
| student_offences | Disciplinary records |
| student_notes | Staff notes |
| student_documents | Document store |
| registration_workflow_logs | Wizard/workflow audit |
| online_registration_requests | Online requests |

---

## Seed

`StudentRegistrationSeeder` creates settings, session, sequences, and **2** sample students (with QR/barcode).

Depends on Institution + Admission seed data.

---

## Validation

```
php artisan migrate --no-interaction
→ 2026_07_10_100000_create_student_registration_tables DONE

php artisan db:seed --class=StudentRegistrationSeeder
→ completed with 2 sample student(s)
```