Hi there,

I need some help creating and mapping a relationship in hibernate. I have a many-many relationship but its a bit tricky, there is a property that only exists on the relationship. The table structure looks like this:

CREATE TABLE `customer` (
`customer_id` int(4) NOT NULL default '0',
`customer_name` varchar(50) default NULL,
PRIMARY KEY (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1


CREATE TABLE `order` (
`order_id` int(11) default NULL,
`order_number` varchar(50) default NULL,
PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

CREATE TABLE `customer_order` (
`customer_id` int(11) default NULL,
`order_id` int(11) default NULL,
`order_limit` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1

I dont know how or where to map the order_limit column. Can anyone help me on this? Thanks alot

Let me explain this better. A customer has a order that has a limit.
So customer "Stephan" has order "V001" and its limit is 1.
customer "Stephan" has order "V002" and its limit is 2.
But customer "Gawie" also has order "V001" but its limit is 2.

Dunno if this sheds more light on the subject.