models

type Course struct {
	gorm.Model
	Name        string `gorm:"not null"`
	Code        string `gorm:"uniqueIndex;not null"`
	Description string
	TeacherID   uint    `gorm:"not null"` // Reference to Teacher
	Teacher     Teacher `gorm:"foreignKey:TeacherID"`
}

type Enrollment struct {
	gorm.Model
	StudentID uint    `gorm:"not null"`
	CourseID  uint    `gorm:"not null"`
	Grade     *string // Nullable grade
}

type Student struct {
	gorm.Model
	UserID      uint   `gorm:"uniqueIndex;not null"`
	User        User   `gorm:"foreignKey:UserID"`
	DateOfBirth string `gorm:"type:date"`
	Address     string
	Phone       string
}

type Teacher struct {
	gorm.Model
	UserID  uint   `gorm:"uniqueIndex;not null"`
	User    User   `gorm:"foreignKey:UserID"`
	Subject string `gorm:"not null"`
	Phone   string
}

type User struct {
	gorm.Model
	Email     string `gorm:"uniqueIndex;not null"`
	Password  string `gorm:"not null"`
	FirstName string `gorm:"not null"`
	LastName  string `gorm:"not null"`
	Role      string `gorm:"not null"` // admin, teacher, student, parent
}