CREATE TABLE OP_TURNOS (
op_fk INT8 NOT NULL
, turno_fk SMALLINT NOT NULL
, data_turno INT8 NOT NULL
, user_id CHAR(10) NOT NULL
, PRIMARY KEY (op_fk, turno_fk, data_turno)
, CONSTRAINT op_turnos_op_fk FOREIGN KEY (op_fk)
REFERENCES OP (id)
, CONSTRAINT op_turnos_turnos_fk FOREIGN KEY (turno_fk)
REFERENCES TURNOS (id)
);

CREATE TABLE OP_CONTROLO_REJEICAO (
op_fk INT8 NOT NULL
, turno_fk SMALLINT NOT NULL
, data_turno_fk INT8 NOT NULL
, tipo_rejeicao_fk INT8 NOT NULL
, user_id CHAR(10) NOT NULL
, PRIMARY KEY (op_fk, turno_fk, data_turno_fk, tipo_rejeicao_fk)
, CONSTRAINT tipo_rejeicao_fk FOREIGN KEY (tipo_rejeicao_fk)
REFERENCES TIPO_REJEICAO (id)
, CONSTRAINT op_cont_rej_op_turnos_fk FOREIGN KEY (op_fk, turno_fk, data_turno_fk)
REFERENCES OP_TURNOS (op_fk, turno_fk, data_turno)
);

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>
<!--
Created by Middlegen Hibernate plugin

http://boss.bekk.no/boss/middlegen/
http://hibernate.sourceforge.net/
-->

<class
name="pt.vo.OpTurno"
table="op_turnos"
>

<composite-id name="comp_id" class="pt.vo.OpTurnoPK">
<key-property
name="dataTurno"
column="data_turno"
type="long"
length="8"
/>
<!-- bi-directional many-to-one association to Turno -->
<key-many-to-one
name="turno"
class="pt.vo.Turno"
>
<column name="turno_fk" />
</key-many-to-one>
<!-- bi-directional many-to-one association to Op -->
<key-many-to-one
name="op"
class="pt.vo.Op"
>
<column name="op_fk" />
</key-many-to-one>
</composite-id>

<property
name="userId"
type="java.lang.String"
column="user_id"
not-null="true"
length="10"
/>

<!-- associations -->
<!-- bi-directional one-to-many association to OpControloRejeicao -->
<set
name="opControloRejeicaos"
lazy="true"
inverse="true"
>
<key>
<column name="op_fk" />
<column name="turno_fk" />
<column name="data_turno_fk" />
</key>
<one-to-many
class="pt.vo.OpControloRejeicao"
/>
</set>

</class>
</hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >

<hibernate-mapping>
<!--
Created by Middlegen Hibernate plugin

http://boss.bekk.no/boss/middlegen/
http://hibernate.sourceforge.net/
-->

<class
name="pt.vo.OpControloRejeicao"
table="op_controlo_rejeicao"
>

<composite-id name="comp_id" class="pt.vo.OpControloRejeicaoPK">
<!-- bi-directional many-to-one association to TipoRejeicao -->
<key-many-to-one
name="tipoRejeicao"
class="pt.vo.TipoRejeicao"
>
<column name="tipo_rejeicao_fk" />
</key-many-to-one>
<!-- bi-directional many-to-one association to OpTurno -->
<key-many-to-one
name="opTurno"
class="pt.vo.OpTurno"
>
<column name="op_fk" />
<column name="turno_fk" />
<column name="data_turno_fk" />
</key-many-to-one>
</composite-id>

<property
name="userId"
type="java.lang.String"
column="user_id"
not-null="true"
length="10"
/>

<!-- associations -->

</class>
</hibernate-mapping>

package pt.vo;

import java.io.Serializable;
import java.util.Set;
import org.apache.commons.lang.builder.EqualsBuilder;
import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.commons.lang.builder.ToStringBuilder;

/** @author Hibernate CodeGenerator */
public class OpTurno implements Serializable {

/** identifier field */
private pt.vo.OpTurnoPK comp_id;

/** persistent field */
private String userId;

/** persistent field */
private Set opControloRejeicaos;

/** full constructor */
public OpTurno(pt.vo.OpTurnoPK comp_id, String userId, Set opControloRejeicaos) {
this.comp_id = comp_id;
this.userId = userId;
this.opControloRejeicaos = opControloRejeicaos;
}

/** default constructor */
public OpTurno() {
}

public pt.vo.OpTurnoPK getComp_id() {
return this.comp_id;
}

public void setComp_id(pt.vo.OpTurnoPK comp_id) {
this.comp_id = comp_id;
}

public String getUserId() {
return this.userId;
}

public void setUserId(String userId) {
this.userId = userId;
}

public Set getOpControloRejeicaos() {
return this.opControloRejeicaos;
}

public void setOpControloRejeicaos(Set opControloRejeicaos) {
this.opControloRejeicaos = opControloRejeicaos;
}

public String toString() {
return new ToStringBuilder(this)
.append("comp_id", getComp_id())
.toString();
}

public boolean equals(Object other) {
if ( !(other instanceof OpTurno) ) return false;
OpTurno castOther = (OpTurno) other;
return new EqualsBuilder()
.append(this.getComp_id(), castOther.getComp_id())
.isEquals();
}

public int hashCode() {
return new HashCodeBuilder()
.append(getComp_id())
.toHashCode();
}
}

package pt.vo;

import java.io.Serializable;
import org.apache.commons.lang.builder.EqualsBuilder;
import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.commons.lang.builder.ToStringBuilder;

/** @author Hibernate CodeGenerator */
public class OpTurnoPK implements Serializable {

/** identifier field */
private long dataTurno;

/** identifier field */
private pt.vo.Turno turno;

/** identifier field */
private pt.vo.Op op;

/** full constructor */
public OpTurnoPK(long dataTurno, pt.vo.Turno turno, pt.vo.Op op) {
this.dataTurno = dataTurno;
this.turno = turno;
this.op = op;
}

/** default constructor */
public OpTurnoPK() {
}

public long getDataTurno() {
return this.dataTurno;
}

public void setDataTurno(long dataTurno) {
this.dataTurno = dataTurno;
}

public pt.vo.Turno getTurno() {
return this.turno;
}

public void setTurno(pt.vo.Turno turno) {
this.turno = turno;
}

public pt.vo.Op getOp() {
return this.op;
}

public void setOp(pt.vo.Op op) {
this.op = op;
}

public String toString() {
return new ToStringBuilder(this)
.append("dataTurno", getDataTurno())
.append("turno", getTurno())
.append("op", getOp())
.toString();
}

public boolean equals(Object other) {
if ( !(other instanceof OpTurnoPK) ) return false;
OpTurnoPK castOther = (OpTurnoPK) other;
return new EqualsBuilder()
.append(this.getDataTurno(), castOther.getDataTurno())
.append(this.getTurno(), castOther.getTurno())
.append(this.getOp(), castOther.getOp())
.isEquals();
}

public int hashCode() {
return new HashCodeBuilder()
.append(getDataTurno())
.append(getTurno())
.append(getOp())
.toHashCode();
}
}

package pt.vo;

import java.io.Serializable;
import org.apache.commons.lang.builder.EqualsBuilder;
import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.commons.lang.builder.ToStringBuilder;

/** @author Hibernate CodeGenerator */
public class OpControloRejeicao implements Serializable {

/** identifier field */
private pt.vo.OpControloRejeicaoPK comp_id;

/** persistent field */
private String userId;

/** full constructor */
public OpControloRejeicao(pt.vo.OpControloRejeicaoPK comp_id, String userId) {
this.comp_id = comp_id;
this.userId = userId;
}

/** default constructor */
public OpControloRejeicao() {
}

public pt.vo.OpControloRejeicaoPK getComp_id() {
return this.comp_id;
}

public void setComp_id(pt.vo.OpControloRejeicaoPK comp_id) {
this.comp_id = comp_id;
}

public String getUserId() {
return this.userId;
}

public void setUserId(String userId) {
this.userId = userId;
}

public String toString() {
return new ToStringBuilder(this)
.append("comp_id", getComp_id())
.toString();
}

public boolean equals(Object other) {
if ( !(other instanceof OpControloRejeicao) ) return false;
OpControloRejeicao castOther = (OpControloRejeicao) other;
return new EqualsBuilder()
.append(this.getComp_id(), castOther.getComp_id())
.isEquals();
}

public int hashCode() {
return new HashCodeBuilder()
.append(getComp_id())
.toHashCode();
}
}

package pt.vo;

import java.io.Serializable;
import org.apache.commons.lang.builder.EqualsBuilder;
import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.commons.lang.builder.ToStringBuilder;

/** @author Hibernate CodeGenerator */
public class OpControloRejeicaoPK implements Serializable {

/** identifier field */
private pt.vo.TipoRejeicao tipoRejeicao;

/** identifier field */
private pt.vo.OpTurno opTurno;

/** full constructor */
public OpControloRejeicaoPK(pt.vo.TipoRejeicao tipoRejeicao, pt.vo.OpTurno opTurno) {
this.tipoRejeicao = tipoRejeicao;
this.opTurno = opTurno;
}

/** default constructor */
public OpControloRejeicaoPK() {
}

public pt.vo.TipoRejeicao getTipoRejeicao() {
return this.tipoRejeicao;
}

public void setTipoRejeicao(pt.vo.TipoRejeicao tipoRejeicao) {
this.tipoRejeicao = tipoRejeicao;
}

public pt.vo.OpTurno getOpTurno() {
return this.opTurno;
}

public void setOpTurno(pt.vo.OpTurno opTurno) {
this.opTurno = opTurno;
}

public String toString() {
return new ToStringBuilder(this)
.append("tipoRejeicao", getTipoRejeicao())
.append("opTurno", getOpTurno())
.toString();
}

public boolean equals(Object other) {
if ( !(other instanceof OpControloRejeicaoPK) ) return false;
OpControloRejeicaoPK castOther = (OpControloRejeicaoPK) other;
return new EqualsBuilder()
.append(this.getTipoRejeicao(), castOther.getTipoRejeicao())
.append(this.getOpTurno(), castOther.getOpTurno())
.isEquals();
}

public int hashCode() {
return new HashCodeBuilder()
.append(getTipoRejeicao())
.append(getOpTurno())
.toHashCode();
}
}

( ... )
OpControloRejeicao op_controlo_rej = new OpControloRejeicao();
OpControloRejeicaoPK op_controlo_rej_pk = new OpControloRejeicaoPK();

TipoRejeicao tipo_rejeicao = new TipoRejeicao();
tipo_rejeicao.setId(new Long(1));
op_controlo_rej_pk.setTipoRejeicao(tipo_rejeicao);

OpTurnoPK op_turno_pk = new OpTurnoPK();
op_turno_pk.setDataTurno(new Long(21122003).longValue());

Op op = new Op();
op.setId(new Long(1));
op_turno_pk.setOp(op);

Turno turno = new Turno();
turno.setId(new Short(new Integer(2).shortValue()));
op_turno_pk.setTurno(turno);

OpTurno op_turno = new OpTurno();
op_turno.setComp_id(op_turno_pk);
op_controlo_rej_pk.setOpTurno(op_turno);

op_controlo_rej.setComp_id(op_controlo_rej_pk);
op_controlo_rej.setUserId("mike");
HashSet op_cont_rejs = new HashSet();
op_cont_rejs.add(op_controlo_rej);
op_turno.setOpControloRejeicaos(op_cont_rejs);
( ... )