models

type Group struct {
	ID        uint32    `gorm:"primary_key;auto_increment" json:"id"`
	Name      string    `gorm:"size:1000;not null;" json:"name"`
	CreatedAt time.Time `gorm:"default:CURRENT_TIMESTAMP" json:"created_at"`
}

type IntersectionTestQuestion struct {
	ID         uint32
	QuestionID uint32 `gorm:"foreignkey:question_id"`
	TestID     uint32 `gorm:"foreignkey:test_id"`
}

type JsonUser struct {
	ID    uint32
	Name  string
	Email string
	Role  string
}

type Question struct {
	ID        uint32         `gorm:"primary_key;auto_increment" json:"id"`
	Name      string         `gorm:"size:1000;not null;" json:"name"`
	Answers   pq.StringArray `gorm:"type:text[];not null;" json:"answers"`
	Correct   pq.StringArray `gorm:"type:text[];not null;" json:"correct"`
	CreatedAt time.Time      `gorm:"default:CURRENT_TIMESTAMP" json:"created_at"`
	GroupID   uint32         `gorm:"type:bigserial;not null;" json:"group_id"`
	TestID    pq.Int32Array  `json:"test_id" gorm:"-"`
}

type Test struct {
	ID        uint32    `gorm:"primary_key;auto_increment" json:"id"`
	Name      string    `gorm:"size:1000;not null" json:"name"`
	CreatedAt time.Time `gorm:"default:CURRENT_TIMESTAMP" json:"created_at"`
}

type User struct {
	ID        uint32    `gorm:"primary_key;auto_increment" json:"id"`
	Name      string    `gorm:"size:255;not null;" json:"name"`
	Email     string    `gorm:"size:100;not null;unique" json:"email"`
	Password  string    `gorm:"size:100;not null;" json:"password"`
	Role      string    `gorm:"size:100;not null;" json:"role"`
	CreatedAt time.Time `gorm:"default:CURRENT_TIMESTAMP" json:"created_at"`
}