한명의 유저는 여러개의 역할을 가질 수 있다. (1 : N)
create table member(
user_no number(8) not null,
user_id varchar2(50) not null,
user_pw varchar2(100) not null,
user_name varchar2(100) not null,
coin number(8) default 0 null,
reg_date date default sysdate null,
upd_date date default sysdate null,
enabled varchar2(10) default '1' null,
constraint pk_member primary key(user_no)
);
create sequence seq_member increment by 1 start with 1 nocache;
create table member_auth(
user_no number(8) not null,
auth varchar2(50) not null,
constraint fk_member_auth_user_no foreign key(user_no)
references member(user_no)
);
package kr.or.ddit.vo;
import java.util.Date;
import java.util.List;
import lombok.Data;
@Data
public class MemberVO {
private int userNo;
private String userId;
private String userName;
private Date regDate;
private Date updDate;
private List<MemberAuth> authList;
}
package kr.or.ddit.vo;
import lombok.Data;
@Data
public class MemberAuth {
private int userNo;
private String auth;
}