package com.gkhy.labRiskManage.domain.experiment.entity;

import com.gkhy.labRiskManage.domain.basic.entity.BasicExperimentSite;
import com.gkhy.labRiskManage.domain.basic.entity.BasicExperimentType;
import lombok.Data;
import org.hibernate.annotations.Where;

import javax.persistence.*;

/**
 * @email 1603559716@qq.com
 * @author: zf
 * @date: 2023/3/20
 * @time: 15:54
 */
@Data
@Entity
@Table(name = "experiment_and_type")
@Where(clause = "delete_status = 0")
public class ExperimentAndType {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id")
    private Long id;
    /**
     * 实验ID
     */
    @Column(name = "experiment_id")
    private Long experimentId;
    /**
     * 类型
     */
    @Column(name = "type_id")
    private Long typeId;
    /**
     * 删除状态：0-正常；1-已删除
     */
    private Byte deleteStatus;

    @OneToOne(fetch = FetchType.EAGER,cascade = {CascadeType.REFRESH})
    @JoinColumn(name = "type_id",referencedColumnName = "id",insertable =false ,updatable = false)
    private BasicExperimentType type;
}