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

import com.gkhy.labRiskManage.domain.basic.entity.BasicExperimentSite;
import com.gkhy.labRiskManage.domain.basic.entity.BasicExperimentStuff;
import lombok.Data;


import javax.persistence.*;

/**
 * @email 1603559716@qq.com
 * @author: zf
 * @date: 2023/3/20
 * @time: 15:54
 */
@Data
@Entity
@Table(name = "experiment_and_site")
public class ExperimentAndSite {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id")
    private Long id;
    /**
     * 实验ID
     */
    @Column(name = "experiment_id")
    private Long experimentId;
    /**
     * 场所
     */
    @Column(name = "site_id")
    private Long siteId;
    /**
     * 删除状态：0-正常；1-已删除
     */
    private Byte deleteStatus;

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