X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=portal-BE%2Fsrc%2Fmain%2Fjava%2Forg%2Fonap%2Fportal%2Fdomain%2Fdb%2Fcr%2FCrReportAccess.java;h=44a53d31f30d5091949f32e7a2b6aed5a6d5999f;hb=refs%2Fchanges%2F61%2F93861%2F1;hp=083b6151adf2ead63893373f674df99d5d70d6da;hpb=0c2a54db354573a07291444e98b7b5175b9cd32e;p=portal.git

diff --git a/portal-BE/src/main/java/org/onap/portal/domain/db/cr/CrReportAccess.java b/portal-BE/src/main/java/org/onap/portal/domain/db/cr/CrReportAccess.java
index 083b6151..44a53d31 100644
--- a/portal-BE/src/main/java/org/onap/portal/domain/db/cr/CrReportAccess.java
+++ b/portal-BE/src/main/java/org/onap/portal/domain/db/cr/CrReportAccess.java
@@ -87,7 +87,8 @@ CREATE TABLE `cr_report_access` (
 @IdClass(CrReportAccessId.class)
 public class CrReportAccess implements Serializable{
        @Id
-       @JoinColumn(name = "rep_id", nullable = false)
+       @ManyToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY)
+       @JoinColumn(name = "rep_id")
        @Valid
        private CrReport repId;
        @Id
@@ -96,19 +97,19 @@ public class CrReportAccess implements Serializable{
        @Positive
        @NotNull
        private Long orderNo;
-       @Column(name = "role_id")
+       @Column(name = "role_id", columnDefinition = "decimal(11,0) DEFAULT NULL")
        @Digits(integer = 11, fraction = 0)
        @Positive
        private Long roleId;
-       @Column(name = "user_id")
+       @Column(name = "user_id", columnDefinition = "decimal(11,0) DEFAULT NULL")
        @Digits(integer = 11, fraction = 0)
        @Positive
        private Long userId;
-       @Column(name = "read_only_yn", nullable = false, length = 1, columnDefinition = "character varying(1) default 'n'")
+       @Column(name = "menu_approved_yn", nullable = false, length = 1, columnDefinition = "character varying(1) default 'n'")
        @Pattern(regexp = "[YNyn]")
        @SafeHtml
        @NotNull
-       private String readOnlyYn;
+       private String menuApprovedYn;
 
        @NoArgsConstructor
        @AllArgsConstructor