Spring Boot 기반 회원 테이블

Spring Boot 기능을 익히면서 회원 테이블을 생성하고 칼럼을 추가하면서 기능을 테스트하고 있다.

 

CREATE TABLE members (
  member_id bigint(20) NOT NULL,
  userID varchar(60) NOT NULL,
  userNM varchar(30) NOT NULL,
  access int(2) NOT NULL DEFAULT 1 COMMENT '접속상태',
  access_failed_count int(2) NOT NULL DEFAULT 0 COMMENT '로그인실패횟수',
  access_date datetime DEFAULT NULL COMMENT '접속일자 및 시간',
  date date DEFAULT NULL COMMENT '최근접속일자',
  regNO int(5) NOT NULL DEFAULT 0 COMMENT '팀서열',
  admin int(2) NOT NULL DEFAULT 0 COMMENT '관리자유무',
  passwd varchar(120) DEFAULT NULL,
  salt varchar(20) DEFAULT NULL,
  email varchar(60) DEFAULT NULL,
  org_id int(5) NOT NULL DEFAULT 0 COMMENT '조직도ID',
  parent_id int(5) NOT NULL DEFAULT 0 COMMENT '조직도 parent_id',
  codeID int(4) NOT NULL DEFAULT 0 COMMENT '직위',
  telNO varchar(16) DEFAULT NULL COMMENT '유선전화',
  mobileNO varchar(30) DEFAULT NULL COMMENT '휴대폰번호',
  workrole varchar(200) DEFAULT NULL COMMENT '담당업무',
  chosung varchar(10) DEFAULT NULL COMMENT '초성',
  reg_date timestamp NULL DEFAULT current_timestamp() COMMENT '등록일자',
  phoneSE varchar(80) DEFAULT NULL COMMENT 'deviceID',
  is_temp_password int(2) DEFAULT 0 COMMENT '임시비번할당(1)',
  passwd_change_date datetime DEFAULT NULL COMMENT '비밀번호 변경일자',
  last_login_date datetime DEFAULT NULL COMMENT '마지막성공로그인시간',
  display int(2) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
 
ALTER TABLE members
  ADD PRIMARY KEY (member_id),
  ADD UNIQUE KEY userID (userID) USING BTREE;
 
ALTER TABLE members
  MODIFY member_id bigint(20) NOT NULL AUTO_INCREMENT;
COMMIT;
 

 

 

import jakarta.persistence.*;
import lombok.*;
 
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.List;
 
@Entity
@Table(name = "members")
@Getter
@Setter
@NoArgsConstructor
@AllArgsConstructor
@Builder
@ToString(exclude = "roleList")
public class Member {
 
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "member_id")
    private Long memberId;
 
    @Column(name = "userID", nullable = false, unique = true, length = 60)
    private String userID;
 
    @Column(name = "userNM", nullable = false, length = 30)
    private String userNM;
 
    @Column(name = "regNO")
    private int regNO;
 
    @Column(name = "admin")
    private int admin;
 
    @Column(name = "passwd", length = 120)
    private String passwd;
 
    @Column(name = "salt", length = 20)
    private String salt;
 
    @Column(name = "email", length = 60)
    private String email;
 
    @Column(name = "org_id")
    private Integer orgId;
 
    @Column(name = "parent_id")
    private Integer parentId;
 
    @Column(name = "codeID")
    private Integer codeID;
 
    @Column(name = "telNO", length = 16)
    private String telNO;
 
    @Column(name = "mobileNO", length = 30)
    private String mobileNO;
 
    @Column(name = "workrole", length = 200)
    private String workrole;
 
    @Column(name = "access")
    private Integer access;
 
    @Column(name = "chosung", length = 10)
    private String chosung;
 
    @Column(name = "access_failed_count")
    private Integer accessFailedCount;
 
    @Column(name = "access_date")
    private LocalDateTime accessDate;
 
    @Column(name = "reg_date", columnDefinition = "timestamp default current_timestamp")
    private LocalDateTime regDate;
 
    @Column(name = "date")
    private LocalDate date;
 
    @Column(name = "phoneSE", length = 80)
    private String phoneSE;
 
    @Column(name = "is_temp_password")
    private Integer isTempPassword; // 관리자 임시 비밀번호 할당 여부
 
    @Column(name = "passwd_change_date")
    private LocalDateTime passwdChangeDate; // 비밀번호 변경일자
 
    @Column(name = "last_login_date")
    private LocalDateTime lastLoginDate;
 
    @Column(name = "display")
    private Integer display;
 
    @Builder.Default
    @OneToMany(mappedBy = "member", fetch = FetchType.LAZY, cascade = CascadeType.ALL)
    private List<MemberRoleList> roleList = new ArrayList<>();
 
    public void addRole(MemberRoleList role) {
        this.roleList.add(role);
    }
 
    public void clearRoles() {
        this.roleList.clear();
    }
}