Uniqueness of a table attribute depends on another attribute.

[m-mattia-m]

I have in MySql a table "users" which has the column "type" and "email". If I now create a record where the "type" is "user", then the email must be unique and otherwise return an error if an entry with this email already exists. If the "type" is "sleeve", then the email may occur as much as you want.

type UserRequest struct {
	Type           string          `json:"type"` // 'user' or 'sleeve'
	Email            string `json:"email" gorm:"uniqueIndex"` // ,where: (type='user')
}