schemas

type Category struct {
	gorm.Model
	UserID        uint
	Title         string
	MultiChoices  []CategoryMultiChoice       `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
	SingleChoices []CategorySingleChoiceGroup `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
}

type CategoryMultiChoice struct {
	gorm.Model
	CategoryID  uint
	Title       string
	Description string
	Entries     []*HealthEntry `gorm:"many2many:entry_multi_choices;"`
}

type CategorySingleChoiceGroup struct {
	gorm.Model
	CategoryID  uint
	Title       string
	Description string
	Choices     []CategorySingleChoiceItem `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
}

type CategorySingleChoiceItem struct {
	gorm.Model
	CategorySingleChoiceGroupID uint
	Title                       string
	Description                 string
	Entries                     []*HealthEntry `gorm:"many2many:entry_single_choices;"`
}

type HealthEntry struct {
	gorm.Model

	UserID uint `json:"user_id"`

	Remarks string `json:"remarks"`

	HaveBloodPressure bool    `json:"have_blood_pressure"`
	Systole           float32 `json:"systole"`
	Diastole          float32 `json:"diastole"`
	Pulse             float32 `json:"pulse"`

	StartTime time.Time `json:"start_time"`
	EndTime   time.Time `json:"end_time"`

	MultiChoices  []CategoryMultiChoice      `gorm:"many2many:entry_multi_choices;" json:"multi_choices"`
	SingleChoices []CategorySingleChoiceItem `gorm:"many2many:entry_single_choices;" json:"single_choices"`
}

type User struct {
	gorm.Model
	OidcIssuer    string
	OidcSub       string
	Name          string
	FirstName     string
	HealthEntries []HealthEntry
	Categories    []Category `gorm:"constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
}