entity

type Base struct {
	ID        string    `json:"id" gorm:"type:uuid;primaryKey" valid:"uuid"`
	CreatedAt time.Time `json:"created_at" gorm:"column:created_at;autoUpdateTime" valid:"required"`
	UpdatedAt time.Time `json:"updated_at" gorm:"column:updated_at;autoCreateTime" valid:"-"`
}

type Employee struct {
	Base            `json:",inline" valid:"-"`
	Name            string            `json:"name" gorm:"column:name;not null" valid:"required"`
	Email           string            `json:"email" gorm:"column:email;not null" valid:"email"`
	Password        string            `json:"-" gorm:"column:password;not null" valid:"required"`
	Position        string            `json:"position" gorm:"column:position;not null" valid:"required"`
	Presentation    string            `json:"presentation" gorm:"column:presentation" valid:"required"`
	HireDate        time.Time         `json:"hire_date" gorm:"column:hire_date" valid:"required"`
	TerminationDate time.Time         `json:"termination_date" gorm:"column:termination_date" valid:"-"`
	IsActive        bool              `json:"is_active" gorm:"column:is_active;not null" valid:"-"`
	Skills          []*Skill          `json:"-" gorm:"many2many:employees_skills" valid:"-"`
	EmployeesSkills []*EmployeesSkill `json:"-" gorm:"foreignKey:EmployeeID" valid:"-"`
}

type EmployeesSkill struct {
	XP         XP        `json:"xp" gorm:"column:xp;not null" valid:"xp"`
	Note       string    `json:"note" gorm:"column:note;varchar(500)" valid:"-"`
	SkillID    string    `gorm:"column:skill_id;type:uuid;not null;unique_index:unique_employee_skill;primaryKey" valid:"uuid"`
	Skill      *Skill    `json:"-" valid:"-"`
	EmployeeID string    `gorm:"column:employee_id;type:uuid;not null;unique_index:unique_employee_skill;primaryKey" valid:"uuid"`
	Employee   *Employee `json:"-" valid:"-"`
}

type Skill struct {
	Base            `json:",inline" valid:"-"`
	Name            string            `json:"name" gorm:"column:name;type:varchar(255);unique" valid:"-"`
	Employees       []*Employee       `json:"-" gorm:"many2many:employees_skils" valid:"-"`
	EmployeesSkills []*EmployeesSkill `json:"-" gorm:"foreignKey:SkillID" valid:"-"`
}

type XP int