<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-lazy="false">
  <class name="WiscNet.Database.Model.SiteCANS, WiscNet.Database.Model" table="SiteCANS"
    proxy="WiscNet.Database.Model.SiteCANS, WiscNet.Database.Model">
    <id name="SiteCode" column="SiteCode" type="String">
      <generator class="native" />
    </id>
    <property name="AAMFON" column="AAMFON" type="Boolean" not-null="false" />
    <property name="CINC" column="CINC" type="Boolean" not-null="false" />
    <property name="FoxNet" column="FoxNet" type="Boolean" not-null="false" />
    <property name="Madison" column="Madison" type="Boolean" not-null="false" />
    <property name="Milwaukee" column="" type="Boolean" not-null="false" />
  </class>
</hibernate-mapping>

<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-lazy="false">
  <class name="WiscNet.Database.Model.Member, WiscNet.Database.Model" table="Members" lazy="false">
    <id name="SiteCode" column="SiteCode" type="String" length="25" unsaved-value="null">
      <generator class="assigned" />
    </id> 
    <property name="Institution" column="Institution" type="String" length="50" not-null="false" />
    <property name="MemberType" column="MemberType" type="String" length="25" not-null="false" />
    <property name="MemberGroup" column="MemberGroup" type="String" length="25" not-null="false" />
     <property name="Latitude" column="Latitude" type="Decimal" update="false" not-null="false" />
     <property name="Longitude" column="Longitude" type="Decimal" update="false" not-null="false" />
     <property name="Elevation" column="Elevation" type="Decimal" update="false" not-null="false" />
     <property name="primeURL" column="primeURL" type="String" length="255" update="false" not-null="false" />
    <property name="Taxable" column="Taxable" type="Boolean" not-null="false" />
    <property name="Billable" column="Billable" type="Boolean" not-null="false" />
    <property name="CBSCode" column="CBSCode" type="String" length="25" not-null="true" />
    <property name="SuperSite" column="SuperSite" type="String" length="25" not-null="false" />
    <property name="SuperSiteRelation" column="SuperSiteRelation" type="String" length="25" not-null="false" />
    <property name="LastUpdate" column="LastUpdate" type="DateTime" not-null="false" />
    <set name="MemberContacts" lazy="true" inverse="true" order-by="ContactId">
      <key column="SiteCode" />
      <one-to-many class="WiscNet.Database.Model.MemberContact, WiscNet.Database.Model" />
    </set>
    <set name="MemberDomains" lazy="true" inverse="true" order-by="Id">
      <key column="SiteCode" />
      <one-to-many class="WiscNet.Database.Model.MemberDomain, WiscNet.Database.Model" />
    </set>   
    <set name="MemberShipping" lazy="true" inverse="true" order-by="ContactID">
      <key column="SiteCode" />
      <one-to-many class="WiscNet.Database.Model.MemberShipping, WiscNet.Database.Model" />
    </set>
   <set name="MemberContactsServices" lazy="true" inverse="true" order-by="ContactId">
       <key column="SiteCode" />
       <one-to-many class="WiscNet.Database.Model.MemberContactService, WiscNet.Database.Model" />
     </set>
   <set name="MemberContactsWorkgroups" lazy="true" inverse="true" order-by="ContactId">
       <key column="SiteCode" />
       <one-to-many class="WiscNet.Database.Model.MemberContactWorkgroup, WiscNet.Database.Model" />
     </set>
   <set name="MemberContactsGovernance" lazy="true" inverse="true" order-by="ContactId">
       <key column="SiteCode" />
       <one-to-many class="WiscNet.Database.Model.MemberContactGovernance, WiscNet.Database.Model" />
     </set>
   <set name="MemberContactsFiscal" lazy="true" inverse="true" order-by="ContactId">
       <key column="SiteCode" />
       <one-to-many class="WiscNet.Database.Model.MemberContactFiscal, WiscNet.Database.Model" />
     </set>
   <set name="MemberContactsStrategic" lazy="true" inverse="true" order-by="ContactId">
       <key column="SiteCode" />
       <one-to-many class="WiscNet.Database.Model.MemberContactStrategic, WiscNet.Database.Model" />
     </set>
   <set name="MemberContactsInternal" lazy="true" inverse="true" order-by="ContactId">
       <key column="SiteCode" />
       <one-to-many class="WiscNet.Database.Model.MemberContactInternal, WiscNet.Database.Model" />
     </set>
     <set name="SiteCANS" lazy="true" inverse="true" order-by="SiteCode">
       <key column="SiteCode" />
       <one-to-many class="WiscNet.Database.Model.SiteCANS, WiscNet.Database.Model" />
     </set>
  </class>
</hibernate-mapping>