models

type OTP struct {
	Code     string `gorm:"type:varchar(16);primary_key"`
	ExpiryAt time.Time
	User     User
	UserID   uint `gorm:"unique"`
}

type Role struct {
	gorm.Model
	Name string `gorm:"type:varchar(64)"`
}

type Team struct {
	gorm.Model
	Name             string `gorm:"type:varchar(64);not null"`
	Description      string `gorm:"type:text"`
	Active           bool   `gorm:"default:true; not null"`
	TimeProviderName string `gorm:"not null"`
	Users            []User
}

type TeamRole int8

type TimeProviderConfig struct {
	Data interface{} `json:"data"`
	Type string      `json:"type"`
}

type User struct {
	gorm.Model
	Email              string       `gorm:"type:varchar(255); not null; unique_index"`
	FirstName          string       `gorm:"type:varchar(30); not null"`
	LastName           string       `gorm:"type:varchar(150)"`
	Password           []byte       `gorm:"type:bytea"`
	Active             bool         `gorm:"default:true; not null"`
	TimeProviderConfig fields.JSONB `gorm:"type:jsonb; not null; default:'{}'::jsonb"`
	IsAdmin            bool         `gorm:"default:false; not null"`
	Teams              []Team
	Profiles           []UserProfile
}

type UserProfile struct {
	gorm.Model
	User   User
	UserID uint `gorm:"not null"`
	Role   Role
	RoleID uint `gorm:"not null"`
	Active bool `gorm:"default:false; not null"`
}

type UserTeam struct {
	gorm.Model
	User     User
	UserID   uint `gorm:"not null"`
	Team     Team
	TeamID   uint      `gorm:"not null"`
	Role     TeamRole  `gorm:"default:0; not null"`
	JoinedAt time.Time `gorm:"not null"`
	LeavedAt *time.Time
}