package com.foxedu.basecms.domain; import java.time.LocalDate; import java.time.LocalDateTime; import jakarta.persistence.Column; import jakarta.persistence.Entity; import jakarta.persistence.Id; import jakarta.persistence.Index; import jakarta.persistence.Table; import lombok.Getter; import lombok.NoArgsConstructor; import lombok.Setter; /** * 회원정보 */ @Getter @Setter @NoArgsConstructor @Entity @Table( name = "comtnmber", indexes = { @Index(name = "COMTNMBER_IE1", columnList = "USER_SE_CODE"), @Index(name = "COMTNMBER_IE2", columnList = "SITE_ID") } ) public class Member { @Id @Column(name = "ESNTL_ID", length = 20, nullable = false) private String esntlId; @Column(name = "USER_ID", length = 100, nullable = false, unique = true) private String userId; @Column(name = "USER_SE_CODE", length = 15, nullable = false) private String userSeCode; @Column(name = "PASSWORD", length = 100) private String password; @Column(name = "USER_NM", length = 100) private String userNm; @Column(name = "EMAIL_ADRES", length = 100) private String emailAdres; @Column(name = "TLPHON_NO", length = 100) private String tlphonNo; @Column(name = "MOBLPHON_NO", length = 100) private String moblphonNo; @Column(name = "ZIP", length = 100) private String zip; @Column(name = "ADRES", length = 100) private String adres; @Column(name = "ADRES_DETAIL", length = 100) private String adresDetail; @Column(name = "BRTHDY", length = 100) private String brthdy; @Column(name = "SLRCLD_LRR_CODE", length = 15) private String slrcldLrrCode; @Column(name = "SEXDSTN", length = 15) private String sexdstn; @Column(name = "EMAIL_RECPTN_AT", length = 1) private String emailRecptnAt; @Column(name = "MOBLPHON_RECPTN_AT", length = 1) private String moblphonRecptnAt; @Column(name = "PHOTO_ORIGINAL_FILE_NM", length = 255) private String photoOriginalFileNm; @Column(name = "PHOTO_STRE_FILE_NM", length = 255) private String photoStreFileNm; @Column(name = "DELETE_AT", length = 1) private String deleteAt; @Column(name = "DELETE_PNTTM") private LocalDateTime deletePnttm; @Column(name = "DELETE_RESN", length = 2500) private String deleteResn; @Column(name = "CONFM_AT", length = 1) private String confmAt; @Column(name = "CONFM_PNTTM") private LocalDateTime confmPnttm; @Column(name = "CREDT_ID", length = 64) private String credtId; @Column(name = "CRTFCT_DN", length = 200) private String crtFctDn; @Column(name = "CRTFCT_SERIAL", length = 200) private String crtFctSerial; @Column(name = "SITE_ID", length = 20) private String siteId; @Column(name = "FRST_REGIST_IP", length = 128) private String frstRegistIp; @Column(name = "FRST_REGISTER_PNTTM") private LocalDateTime frstRegisterPnttm; @Column(name = "LAST_UPDUSR_ID", length = 100) private String lastUpdtId; @Column(name = "LAST_UPDUSR_PNTTM") private LocalDate lastUpdtPnttm; @Column(name = "ST_GRADE", length = 100) private String stGrade; @Column(name = "ST_CLASS", length = 100) private String stClass; @Column(name = "ST_NUMBER", length = 100) private String stNumber; @Column(name = "SCHUL_CODE", length = 100) private String schulCode; @Column(name = "SCHUL_NM", length = 30) private String schulNm; }