title: Mapping one entity to multiple tables
body: <p>I have a question related to the Fluent NHibernate. I can not describe the schema mapping one entity to multiple tables. There is the following structure of the database:</p>
  
  <pre><code>Create table CeTypes (Id int not null PRIMARY KEY, Name nvarchar(100) not null)
  Create table CeValues (Id int not null PRIMARY KEY, Name nvarchar(100) not null)
  Create table Ces (Id int not null PRIMARY KEY, CeType_id int not null FOREIGN KEY REFERENCES CeTypes(Id), CeValue_id int not null FOREIGN KEY REFERENCES CeTypes(Id))
  </code></pre>
  
  <p>there is the following entity:</p>
  
  <pre><code>public class Ce
  {
       public virtual int Id { get; set; }
       public virtual string Type { get; set; }
       public virtual string Value { get; set; }
  }
  </code></pre>
  
  <p>CeType, CeValue entities in the domain and there is no. I do not know how to describe the mapping Ce entity.</p>
  
  <p>Tried to describe:</p>
  
  <pre><code>public class CeMap : ClassMap&lt;Ce&gt;
  {
      public CeMap()
      {
          Table("Ces");
          Id(c =&gt; c.Id);
  
          Join("CeTypes", m =&gt; m.Map(ce =&gt; ce.Type).Column("Name"));
          Join("CeValues", m =&gt; m.Map(ce =&gt; ce.Value).Column("Name"));
      }
  }
  </code></pre>
  
  <p>But with such a scheme CeType, CeValue tables should have a field Ce_id. How can I describe scheme mapping under the current structure of the database?</p>