views:

69

answers:

0

Hi
I'm using Fluent Nhibernate, i need to create mappings for 2 tables:

Simplified, they look like this:

TAXI  
(
 Id int primary key
 Name varchar
) 

ORDER 
( 
Id int primary key 
RedirectedFrom int foreign key on TAXI.Id
RedirectedTo int foreign key on TAXI.Id 
)

So, two foreign keys from table TAXI refer to table ORDER

Q: Is that a kind of many-to-many relation and its necessary to create a link table OrderTaxi?
Or it is possible to work with it as many-to-one? would be great to show bidirectional and unidirectional mapping then