cockroachdb-schema.go

package testparts

import (
	"time"

	"gorm.io/datatypes"
	"gorm.io/gorm"
)

// ----- Preferences -----

type GromPreference struct {
	gorm.Model
	Key   string `gorm:"uniqueIndex"`
	Value string
}

// ----- Classes -----

type GormClass struct {
	gorm.Model
	Subject  string `gorm:"uniqueIndex:index:idx_class"`
	Sections []GormClassSection
	Tests    []GormTest
}

type GormClassSection struct {
	gorm.Model
	Section     string `gorm:"uniqueIndex:index:idx_section"`
	GormClassID uint   `gorm:"uniqueIndex:index:idx_section"`
	Students    []GormStudent
}

type GormStudent struct {
	gorm.Model
	FamilyName         string
	GivenName          string
	GormClassSectionID uint
}

// ----- Tests -----

type GormTest struct {
	gorm.Model
	Title        string `gorm:"index:idx_test"`
	Length       uint
	MinQuestions uint
	GormClassID  uint
	Sessions     []GormTestSession
	Attempts     []GormTestAttempt
	Questions    []GormQuestion
}

type GormQuestion struct {
	gorm.Model
	Required   bool
	Question   string
	Points     uint
	GormTestID uint
	Choices    []GormQuestionChoice
}

type GormQuestionChoice struct {
	gorm.Model
	GormQuestionID uint
	Choice         string
	Feedback       string
	Answer         bool
}

type GormTestAttempt struct {
	gorm.Model
	GormStudentID uint
	GormTestID    uint
	Score         float64
	AttemptStart  time.Time
	AttemptEnd    time.Time
	Answers       datatypes.JSON
}

type GormTestSession struct {
	gorm.Model
	GormTestID         uint
	GormClassSectionID uint
	QuestionTime       time.Duration
	StartDateTime      time.Time
	EndDateTime        time.Time
}