Mapping of a table with two foreign keys

[marcelNgan]

Currently learning how to use fluent-nhibernate mapping and got stuck on an issue which I can't seem to find an answer to. I have a table in my SQL database that stores the relation between two different table. The code for creating the tables looks like this:

CREATE TABLE Person(
   Id int  NOT NULL,
   Name nvarchar(255)  NOT NULL,
   CONSTRAINT Person_pk PRIMARY KEY  (Id)
)

CREATE TABLE Shop(
   Id int  NOT NULL,
   Name nvarchar(255)  NOT NULL,
   CONSTRAINT Shop_pk PRIMARY KEY  (Id)
)

CREATE TABLE PersonShopRelations(
   Id int  NOT NULL,
   FK_PersonId int  NOT NULL,
   FK_ShopId int Not NULL,
   RelationDescription nvarchar (255) Not NULL
   CONSTRAINT PersonShopRelations_pk PRIMARY KEY  (Id),
   CONSTRAINT PersonShopRelations_Person FOREIGN KEY (FK_PersonId ) REFERENCES Person(Id),
   CONSTRAINT PersonShopRelations_Shop FOREIGN KEY (FK_ShopId ) REFERENCES Shop(Id)
)

How do you map this to Fluent-NHibernate?

[chester89]

So what's the problem? What have you tried? What didn't work?