entities

type Avatar struct {
	Id        uint      `gorm:"primaryKey"`
	UserId    uint      `gorm:"uniqueIndex;not null"`
	ImageId   uint      `gorm:"not null"`
	Image     Image     `gorm:"constraint:OnDelete:CASCADE;foreignKey:ImageId"`
	CreatedAt time.Time `gorm:"autoCreateTime"`
}

type Ban struct {
	Id          uint   `gorm:"primaryKey"`
	UserId      uint   `gorm:"not null"`
	User        User   `gorm:"foreignKey:UserId;constraint:OnDelete:CASCADE"`
	Reason      string `gorm:"type:text"`
	IsPermanent bool   `gorm:"not null;default:false"`
	UnbanDate   *time.Time
	IsActive    bool      `gorm:"not null;default:true"`
	CreatedAt   time.Time `gorm:"default:CURRENT_TIMESTAMP"`
	UpdatedAt   time.Time `gorm:"default:CURRENT_TIMESTAMP"`
}

type Entity interface {
	MarkerEntity()
}

type Image struct {
	Id        uint      `gorm:"primaryKey"`
	S3Key     string    `gorm:"size:255;not null"`
	Url       string    `gorm:"size:512;not null"`
	UserID    *uint     `gorm:"index"` // Указатель для nullable
	Size      int       `gorm:""`
	MimeType  string    `gorm:"size:50"`
	ExpiresAt time.Time `gorm:""`
	CreatedAt time.Time `gorm:"default:CURRENT_TIMESTAMP"`
}

type Role struct {
	Id          uint   `gorm:"primaryKey"`
	Name        string `gorm:"unique;not null"`
	Level       int    `gorm:"not null;default:0"`
	Description string
	CreatedAt   time.Time
	UpdatedAt   time.Time
}

type User struct {
	Id           uint   `gorm:"primaryKey"`
	Username     string `gorm:"unique;not null"`
	Email        string `gorm:"unique;not null" query:"ops:ilike|like|eq|neq"`
	PasswordHash string `gorm:"not null" query:"ignore"`
	FirstName    string
	LastName     string
	RoleId       uint
	IsBanned     bool  `gorm:"default:false"`
	Bans         []Ban `gorm:"foreignKey:UserId"`
	Role         Role  `gorm:"foreignKey:RoleId"`
	IsActive     bool
	LastLogin    *time.Time
	CreatedAt    time.Time `gorm:"default:CURRENT_TIMESTAMP"`
	UpdatedAt    time.Time `gorm:"default:CURRENT_TIMESTAMP"`
	Avatar       *Avatar   `gorm:"foreignKey:UserId;references:Id"`
}