INSERT INTO UserRole (Role_roleName, UserAccount_email, UserAccount_Account_accountId) VALUES ('Client', 'email@example.com', 1)

DELETE FROM UserRole WHERE ((Role_roleName = 'Administrator') AND ((UserAccount_Account_accountId = 1) AND (UserAccount_email = null)))

@Entity
@Table(name="UserAccount")
@PrimaryKeyJoinColumn(name = "Account_accountId")
public class UserAccount extends Account implements Serializable {
	private static final long serialVersionUID = 1L;

	private String password;

	//bi-directional one-to-one association to Account
	@OneToOne
	@JoinColumn(name="Account_accountId")
	private Account account;
	
	@Column(name="email")
	private String email;
	
	//bi-directional many-to-many association to Role
	@ManyToMany
	@JoinTable(
		name="UserRole"
		,
				
		joinColumns={

			@JoinColumn(name="UserAccount_email", referencedColumnName="email"),
			@JoinColumn(name="UserAccount_Account_accountId", referencedColumnName="Account_accountId")
			}
		, inverseJoinColumns={
			@JoinColumn(name="Role_roleName")
			}
		)
	private List<Role> roles;
//getter and setters

@Entity
@Table(name="Account")
@Inheritance(strategy=InheritanceType.JOINED)
public abstract class Account implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue(strategy=GenerationType.IDENTITY)
	private int accountId;

	private boolean active;

	private String address;

	private String dtype;

	private String firstname;

	private String handy;

	private String name;

	private String tel;

//getter and setters

@Entity
@Table(name="Role")
public class Role implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@GeneratedValue(strategy=GenerationType.IDENTITY)
	private String roleName;

	@Lob
	private String roleDescription;

	//bi-directional many-to-many association to UserAccount
	@ManyToMany(mappedBy="roles")
	private List<UserAccount> userAccounts;

//getter and setters