package db

type LabelManage struct {
	ID        string `gorm:"column:id"`
	Name      string `gorm:"column:name"`
	Comment   string `gorm:"column:comment"`
	Type      int    `gorm:"column:type"`
	ValidDays int    `gorm:"column:valid_days"`
}

func (LabelManage) TableName() string {
	return "label"
}

// 查询人物身份属性表
func GeIdentityLabels() ([]LabelManage, error) {
	var db = DB

	// 查询数据
	var labelManageIdentity []LabelManage
	if err := db.Table("label").
		Select("id, name, valid_days").
		Where("type = 2").
		Find(&labelManageIdentity).Error; err != nil {
		return nil, err
	}

	return labelManageIdentity, nil
}