models

type Answer struct {
	gorm.Model
	UserID      uint
	QuestionID  uint
	Weights     []byte `gorm:"type=bytea"`
	Categories  []byte `gorm:"type=bytea"`
	Option1     string `json:"Option1"`
	Option2     string `json:"Option2"`
	Option3     string `json:"Option3"`
	Option4     string `json:"Option4"`
	Option5     string `json:"Option5"`
	UsersAnswer UsersAnswer
}

type Category struct {
	gorm.Model
	Questions []Question
	Name      string
	Parent    uint
	Level     int32
	Approved  bool
	Option    int32 `gorm:"-"` // ignore this field
}

type Question struct {
	gorm.Model
	Title      string
	Body       string
	Answer     Answer
	Weight     Weight
	Approved   bool
	CategoryID uint
	UserID     uint
}

type User struct {
	gorm.Model
	Email       string `validate:"required"`
	Questions   []Question
	Answers     []Answer
	UsersAnswer UsersAnswer
	Score       float32
}

type UsersAnswer struct {
	gorm.Model
	UserID   uint
	AnswerID uint
	Option   int32
}

type Weight struct {
	gorm.Model
	QuestionID sql.NullInt64
	AnswerID   sql.NullInt64
	Value      float32
	Option     int32
}