utilitymodels

type Common struct {
	ID        uint      `gorm:"primarykey" json:"id"`
	CreatedAt time.Time `json:"-"`
	UpdatedAt time.Time `json:"-"`
}

type CommonID struct {
	ID uint `gorm:"primarykey" json:"id"`
}

type CommonSoftDelete struct {
	ID        uint           `gorm:"primarykey" json:"id"`
	CreatedAt time.Time      `json:"-"`
	UpdatedAt time.Time      `json:"-"`
	DeletedAt gorm.DeletedAt `gorm:"index" json:"-"`
}

type Session struct {
	Common
	UserID     uint      `json:"user_id" gorm:"not null"`
	User       User      `json:"user" gorm:"not null;constraint:OnDelete:CASCADE"`
	SessionID  string    `json:"-" gorm:"not null;unique"`
	ValidUntil time.Time `json:"valid_until" gorm:"not null"`
}

type User struct {
	Common
	LastLoginAt sql.NullTime `json:"-" gorm:"default:null"` // This is only relevant if the session middleware is in use
	Email       *string      `json:"email" gorm:"unique;default:null"`
	Username    string       `json:"username" gorm:"unique;not null"`
	Password    string       `json:"-" gorm:"not null"`
	Active      sql.NullBool `json:"active" gorm:"default:true"`
}