model

type Alumni struct {
	ID             int32          `gorm:"column:id;primaryKey;autoIncrement:true" json:"id"`
	FirstName      string         `gorm:"column:first_name" json:"first_name"`
	LastName       string         `gorm:"column:last_name" json:"last_name"`
	Email          string         `gorm:"column:email" json:"email"`
	GraduationYear int32          `gorm:"column:graduation_year" json:"graduation_year"`
	CreatedAt      time.Time      `gorm:"column:created_at;default:CURRENT_TIMESTAMP" json:"created_at"`
	UpdatedAt      time.Time      `gorm:"column:updated_at;default:CURRENT_TIMESTAMP" json:"updated_at"`
	DeletedAt      gorm.DeletedAt `gorm:"column:deleted_at" json:"deleted_at"`
	Subjects       []Subject      `gorm:"many2many:alumni_subjects" json:"subjects"`
}

type AlumniAssignment struct {
	AlumniID     int32  `gorm:"column:alumni_id;primaryKey" json:"alumni_id"`
	AssignmentID int32  `gorm:"column:assignment_id;primaryKey" json:"assignment_id"`
	Grade        string `gorm:"column:grade" json:"grade"`
}

type AlumniSubject struct {
	AlumniID  int32 `gorm:"column:alumni_id;primaryKey" json:"alumni_id"`
	SubjectID int32 `gorm:"column:subject_id;primaryKey" json:"subject_id"`
}

type Assignment struct {
	ID                    int32                    `gorm:"column:id;primaryKey;autoIncrement:true" json:"id"`
	AssignmentTitle       string                   `gorm:"column:assignment_title" json:"assignment_title"`
	AssignmentDescription string                   `gorm:"column:assignment_description" json:"assignment_description"`
	SubjectID             int32                    `gorm:"column:subject_id" json:"subject_id"`
	ProfessorID           int32                    `gorm:"column:professor_id" json:"professor_id"`
	CreatedAt             time.Time                `gorm:"column:created_at;default:CURRENT_TIMESTAMP" json:"created_at"`
	UpdatedAt             time.Time                `gorm:"column:updated_at;default:CURRENT_TIMESTAMP" json:"updated_at"`
	DeletedAt             gorm.DeletedAt           `gorm:"column:deleted_at" json:"deleted_at"`
	Examples              []AssignmentExample      `gorm:"foreignKey:assignment_id" json:"examples"`
	CodeTemplates         []AssignmentCodeTemplate `gorm:"foreignKey:assignment_id" json:"code_templates"`
}

type AssignmentCodeTemplate struct {
	ID             int32          `gorm:"column:id;primaryKey;autoIncrement:true" json:"id"`
	AssignmentID   int32          `gorm:"column:assignment_id" json:"assignment_id"`
	Language       string         `gorm:"column:language" json:"language"`
	Code           string         `gorm:"column:code" json:"code"`
	TestRunnerCode string         `gorm:"column:test_runner_code" json:"test_runner_code"`
	CreatedAt      time.Time      `gorm:"column:created_at;default:CURRENT_TIMESTAMP" json:"created_at"`
	UpdatedAt      time.Time      `gorm:"column:updated_at;default:CURRENT_TIMESTAMP" json:"updated_at"`
	DeletedAt      gorm.DeletedAt `gorm:"column:deleted_at" json:"deleted_at"`
}

type AssignmentExample struct {
	ID                 int32          `gorm:"column:id;primaryKey;autoIncrement:true" json:"id"`
	AssignmentID       int32          `gorm:"column:assignment_id" json:"assignment_id"`
	ExampleTitle       string         `gorm:"column:example_title" json:"example_title"`
	ExampleDescription string         `gorm:"column:example_description" json:"example_description"`
	CreatedAt          time.Time      `gorm:"column:created_at;default:CURRENT_TIMESTAMP" json:"created_at"`
	UpdatedAt          time.Time      `gorm:"column:updated_at;default:CURRENT_TIMESTAMP" json:"updated_at"`
	DeletedAt          gorm.DeletedAt `gorm:"column:deleted_at" json:"deleted_at"`
}

type Execution struct {
	ID           int32          `gorm:"column:id;primaryKey;autoIncrement:true" json:"id"`
	Language     string         `gorm:"column:language" json:"language"`
	WorkflowID   string         `gorm:"column:workflow_id" json:"workflow_id"`
	RunID        string         `gorm:"column:run_id" json:"run_id"`
	Code         string         `gorm:"column:code" json:"code"`
	AssignmentID int32          `gorm:"column:assignment_id" json:"assignment_id"`
	CreatedAt    time.Time      `gorm:"column:created_at;default:CURRENT_TIMESTAMP" json:"created_at"`
	UpdatedAt    time.Time      `gorm:"column:updated_at;default:CURRENT_TIMESTAMP" json:"updated_at"`
	DeletedAt    gorm.DeletedAt `gorm:"column:deleted_at" json:"deleted_at"`
}

type Professor struct {
	ID        int32          `gorm:"column:id;primaryKey;autoIncrement:true" json:"id"`
	FirstName string         `gorm:"column:first_name" json:"first_name"`
	LastName  string         `gorm:"column:last_name" json:"last_name"`
	Email     string         `gorm:"column:email" json:"email"`
	CreatedAt time.Time      `gorm:"column:created_at;default:CURRENT_TIMESTAMP" json:"created_at"`
	UpdatedAt time.Time      `gorm:"column:updated_at;default:CURRENT_TIMESTAMP" json:"updated_at"`
	DeletedAt gorm.DeletedAt `gorm:"column:deleted_at" json:"deleted_at"`
	Subjects  []Subject      `gorm:"foreignKey:professor_id" json:"subjects"`
}

type Subject struct {
	ID          int32          `gorm:"column:id;primaryKey;autoIncrement:true" json:"id"`
	SubjectName string         `gorm:"column:subject_name" json:"subject_name"`
	Semester    int32          `gorm:"column:semester" json:"semester"`
	ProfessorID int32          `gorm:"column:professor_id" json:"professor_id"`
	CreatedAt   time.Time      `gorm:"column:created_at;default:CURRENT_TIMESTAMP" json:"created_at"`
	UpdatedAt   time.Time      `gorm:"column:updated_at;default:CURRENT_TIMESTAMP" json:"updated_at"`
	DeletedAt   gorm.DeletedAt `gorm:"column:deleted_at" json:"deleted_at"`
	Assignments []Assignment   `gorm:"foreignKey:subject_id" json:"assignments"`
}