@Entity
@Table(name = "USER")
public class UserEntity {

    @Id
    @Column(name = "ID", nullable = false)
    private Long id;

    @Column(name = "USERNAME", nullable = false)
    private String username;

    @Column(name = "FIRSTNAME", nullable = false)
    private String firstName;

    @Column(name = "LASTNAME", nullable = false)
    private String lastName;

    @Column(name = "PASSWORD", nullable = false)
    private String password;

    @Column(name = "EMAIL", nullable = false)
    private String email;

    @Column(name = "ACTIVE", nullable = false)
    private String active;

    @ManyToMany(fetch = FetchType.EAGER, cascade = {CascadeType.REMOVE})
    @JoinTable(
        name = "USER_ROLE",
        joinColumns = {@JoinColumn(name = "USER_ID")},
        inverseJoinColumns = {@JoinColumn(name = "ROLE_ID")}
    )
    private Set<RoleEntity> userRole = new HashSet<>(0);

    @OneToOne(fetch = FetchType.EAGER, cascade = {CascadeType.REMOVE}, mappedBy = "USER_SETTING_ID")
    @JoinTable(
        name = "SETTINGS",
        joinColumns = {@JoinColumn(name = "USER_ID")}
    )
    private UserSettingsEntity userSettings;

    public UserSettingsEntity getUserSettings() {
        return userSettings;
    }

    public void setUserSettings(UserSettingsEntity userSettings) {
        this.userSettings = userSettings;
    }

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getFirstName() {
        return firstName;
    }

    public void setFirstName(String firstName) {
        this.firstName = firstName;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public Set<RoleEntity> getUserRole() {
        return this.userRole;
    }

    public void setUserRole(Set<RoleEntity> userRole) {
        this.userRole = userRole;
    }

    public String getActive() {
        return active;
    }

    public void setActive(String active) {
        this.active = active;
    }
}









@Table(name = "SETTINGS")
public class UserSettingsEntity {

    @Id
    @Column(name = "ID")
    private String id;

    @Column(name = "SEARCH_TYPE")
    private String searchType;

    @Column(name = "TIMEZONE")
    private String timeZone;

    @Column(name = "LANGUAGE")
    private String language;

    @Column(name = "COUNTRY")
    private String country;

    @Column(name = "THEME")
    private String theme;

    @Column(name = "PRIVACY_IMAGE")
    private Long privacyImage;

    @Column(name = "PRIVACY_CONCERTS")
    private Long privacyConcerts;

    @Column(name = "PRIVACY_FRIENDS")
    private Long privacyFriends;

    @Column(name = "BIO")
    private String bio;

    @Column(name = "IMAGE")
    private String image;

    @Column(name = "GENDER")
    private String gender;

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getSearchType() {
        return searchType;
    }

    public void setSearchType(String searchType) {
        this.searchType = searchType;
    }

    public String getTimeZone() {
        return timeZone;
    }

    public void setTimeZone(String timeZone) {
        this.timeZone = timeZone;
    }

    public String getLanguage() {
        return language;
    }

    public void setLanguage(String language) {
        this.language = language;
    }

    public String getCountry() {
        return country;
    }

    public void setCountry(String country) {
        this.country = country;
    }

    public String getTheme() {
        return theme;
    }

    public void setTheme(String theme) {
        this.theme = theme;
    }

    public Long getPrivacyImage() {
        return privacyImage;
    }

    public void setPrivacyImage(Long privacyImage) {
        this.privacyImage = privacyImage;
    }

    public Long getPrivacyConcerts() {
        return privacyConcerts;
    }

    public void setPrivacyConcerts(Long privacyConcerts) {
        this.privacyConcerts = privacyConcerts;
    }

    public Long getPrivacyFriends() {
        return privacyFriends;
    }

    public void setPrivacyFriends(Long privacyFriends) {
        this.privacyFriends = privacyFriends;
    }

    public String getBio() {
        return bio;
    }

    public void setBio(String bio) {
        this.bio = bio;
    }

    public String getImage() {
        return image;
    }

    public void setImage(String image) {
        this.image = image;
    }

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }
}




CREATE TABLE  USER
(
    ID INT (40) NOT NULL AUTO_INCREMENT,
    USERNAME VARCHAR (40) NOT NULL,
    FIRSTNAME VARCHAR (40) NOT NULL,
    LASTNAME VARCHAR (40) NOT NULL,
    PASSWORD VARCHAR (124) NOT NULL,
    EMAIL VARCHAR (40) NOT NULL,
    ACTIVE VARCHAR (5) NOT NULL DEFAULT "true",
    PRIMARY KEY (ID)
);

CREATE TABLE USER_SETTINGS
(
    ID INT (40) NOT NULL AUTO_INCREMENT,
    USER_ID INT (40) NOT NULL,
    SEARCH_TYPE VARCHAR (40),
    TIMEZONE VARCHAR (40),
    LANGUAGE VARCHAR (40),
    COUNTRY VARCHAR (40),
    THEME VARCHAR (40),
    PRIVACY_IMAGE INT (40),
    PRIVACY_CONCERTS INT (40),
    PRIVACY_ACHIEVMENTS INT (40),
    PRIVACY_FRIENDS INT (40),
    BIO VARCHAR (360),
    IMAGE BLOB,
    GENDER VARCHAR (2),
    FOREIGN KEY (USER_ID) REFERENCES USER (ID),
    PRIMARY KEY (ID)
);