package cn.lihongjie.coal.employee.entity;

import jakarta.persistence.Embeddable;

import lombok.Data;

import org.hibernate.annotations.Comment;
import org.hibernate.annotations.Formula;

import java.util.*;

@Data
@Embeddable
public class EmpFamilyMemberVO {
    
    private String name;

    @Comment("关系")
    private String relation;

    @Formula(
            "(select i.name\n"
                    + "from t_dictionary d,\n"
                    + "     t_dictionary_item i\n"
                    + "where d.id = i.dictionary_id\n"
                    + "  and d.code = 'emp.familyMember.relation'\n"
                    + "  and i.code = relation)")
    private String relationName;


    private String phone;


    private String remarks;










}
