package org.onap.portal.domain.db.cr;
+import java.io.Serializable;
import java.time.LocalDateTime;
-import java.util.ArrayList;
-import java.util.List;
import java.util.Set;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
+import javax.persistence.GeneratedValue;
+import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Index;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;
import javax.persistence.ManyToOne;
+import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
import javax.validation.Valid;
import javax.validation.constraints.Digits;
@Getter
@Setter
@Entity
-public class CrReportFileHistory {
+public class CrReportFileHistory implements Serializable {
@Id
@Column(name = "hist_id", nullable = false, length = 11)
+ @GeneratedValue(strategy = GenerationType.AUTO)
@Digits(integer = 11, fraction = 0)
private Long histId;
@Column(name = "sched_user_id", nullable = false)
@Digits(integer = 11, fraction = 0)
@NotNull
private Long userId;
- @ManyToOne(fetch = FetchType.LAZY, cascade = CascadeType.ALL)
+ @ManyToOne(fetch = FetchType.LAZY, cascade = CascadeType.MERGE)
@JoinColumn(name = "rep_id")
@Valid
private CrReport repId;
@Size(max = 50)
@SafeHtml
private String recurrence;
- @ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
+ @ManyToOne(cascade = CascadeType.MERGE, fetch = FetchType.LAZY)
@JoinColumn(name = "file_type_id")
@Valid
private CrLuFileType fileTypeId;
@Digits(integer = 38, fraction = 0)
private Long deletedBy;
- @ManyToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
+ @ManyToMany(cascade = CascadeType.MERGE, fetch = FetchType.LAZY)
@JoinTable(
name = "cr_hist_user_map",
joinColumns = {@JoinColumn(name = "hist_id", referencedColumnName = "hist_id")},
- inverseJoinColumns = {@JoinColumn(name = "user_id", referencedColumnName = "user_id")}
+ inverseJoinColumns = {@JoinColumn(name = "user_id", referencedColumnName = "id", columnDefinition = "bigint not null")}
)
private Set<FnUser> fnUserList;
}