@Entity
@Table(name="employee")
public class Employee {

    @Id
    long id;

    String name;

    @ElementCollection
    @CollectionTable(name="employee_roles",
                     joinColumns = @JoinColumn(name="employee_id"))
    @Column(name="role_id")
    private Set<EmployeeRole> roles;
}

public enum EmployeeRole {
    Role1,
    Role2,
    Role3,
    Role4
}

create table employee (id integer not null auto_increment, name varchar(255), primary key (id)) engine=InnoDB;

create table employee_roles (employee_id integer not null, role_id integer) engine=InnoDB;

alter table employee_roles add constraint FKivyn2pkkba72p28ahjxv1t0ai foreign key (employee_id) references employee (id);

insert into employee values (1, 'Bill');
insert into employee values (2, 'Joe');
insert into employee values (3, 'Bob');

insert into employee_roles values (1, 0);
insert into employee_roles values (1, 1);

insert into employee_roles values (2, 1);
insert into employee_roles values (2, 2);

insert into employee_roles values (3, 2);
insert into employee_roles values (3, 3);

Query deleteQuery = em.createQuery("delete Employee e where e.id = :id");
deleteQuery.setParameter("id", 1L);

deleteQuery.executeUpdate();