WindchimeModel.edmx

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="1.0" xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
    <Schema Namespace="WindchimeModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2005" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl">
        <EntityContainer Name="WindchimeModelStoreContainer">
          <EntitySet Name="Assets" EntityType="WindchimeModel.Store.Assets" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="AssetTypes" EntityType="WindchimeModel.Store.AssetTypes" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="AssignmentCreators" EntityType="WindchimeModel.Store.AssignmentCreators" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="AssignmentEditors" EntityType="WindchimeModel.Store.AssignmentEditors" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Assignments" EntityType="WindchimeModel.Store.Assignments" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="AssignmentType" EntityType="WindchimeModel.Store.AssignmentType" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="BinaryVersions" EntityType="WindchimeModel.Store.BinaryVersions" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Categories" EntityType="WindchimeModel.Store.Categories" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="CollectionAssetMembership" EntityType="WindchimeModel.Store.CollectionAssetMembership" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="CollectionRelationships" EntityType="WindchimeModel.Store.CollectionRelationships" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Collections" EntityType="WindchimeModel.Store.Collections" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Comments" EntityType="WindchimeModel.Store.Comments" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Creators" EntityType="WindchimeModel.Store.Creators" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="EntityTags" EntityType="WindchimeModel.Store.EntityTags" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="GroupMemberships" EntityType="WindchimeModel.Store.GroupMemberships" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="GroupRelationships" EntityType="WindchimeModel.Store.GroupRelationships" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Groups" EntityType="WindchimeModel.Store.Groups" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Issues" EntityType="WindchimeModel.Store.Issues" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="PermissionableEntities" EntityType="WindchimeModel.Store.PermissionableEntities" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="PermissionEntries" EntityType="WindchimeModel.Store.PermissionEntries" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="PolicyEntries" EntityType="WindchimeModel.Store.PolicyEntries" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Tags" EntityType="WindchimeModel.Store.Tags" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="TextVersions" EntityType="WindchimeModel.Store.TextVersions" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Users" EntityType="WindchimeModel.Store.Users" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Versions" EntityType="WindchimeModel.Store.Versions" store:Type="Tables" Schema="dbo" />
          <AssociationSet Name="Assets_CollectionAssetMembership_FK1" Association="WindchimeModel.Store.Assets_CollectionAssetMembership_FK1">
            <End Role="Assets" EntitySet="Assets" />
            <End Role="CollectionAssetMembership" EntitySet="CollectionAssetMembership" />
          </AssociationSet>
          <AssociationSet Name="Assets_Comments_FK1" Association="WindchimeModel.Store.Assets_Comments_FK1">
            <End Role="PermissionableEntities" EntitySet="PermissionableEntities" />
            <End Role="Comments" EntitySet="Comments" />
          </AssociationSet>
          <AssociationSet Name="Assets_Versions_FK1" Association="WindchimeModel.Store.Assets_Versions_FK1">
            <End Role="Assets" EntitySet="Assets" />
            <End Role="Versions" EntitySet="Versions" />
          </AssociationSet>
          <AssociationSet Name="AssetTypes_Assets_FK1" Association="WindchimeModel.Store.AssetTypes_Assets_FK1">
            <End Role="AssetTypes" EntitySet="AssetTypes" />
            <End Role="Assets" EntitySet="Assets" />
          </AssociationSet>
          <AssociationSet Name="Assignments_AssignmentEditors_FK1" Association="WindchimeModel.Store.Assignments_AssignmentEditors_FK1">
            <End Role="Assignments" EntitySet="Assignments" />
            <End Role="AssignmentEditors" EntitySet="AssignmentEditors" />
          </AssociationSet>
          <AssociationSet Name="Assignments_AssignmentUsers_FK1" Association="WindchimeModel.Store.Assignments_AssignmentUsers_FK1">
            <End Role="Assignments" EntitySet="Assignments" />
            <End Role="AssignmentCreators" EntitySet="AssignmentCreators" />
          </AssociationSet>
          <AssociationSet Name="Collections_Assignments_FK1" Association="WindchimeModel.Store.Collections_Assignments_FK1">
            <End Role="Collections" EntitySet="Collections" />
            <End Role="Assignments" EntitySet="Assignments" />
          </AssociationSet>
          <AssociationSet Name="Collections_Categories_FK1" Association="WindchimeModel.Store.Collections_Categories_FK1">
            <End Role="Collections" EntitySet="Collections" />
            <End Role="Categories" EntitySet="Categories" />
          </AssociationSet>
          <AssociationSet Name="Collections_CollectionAssetMembership_FK1" Association="WindchimeModel.Store.Collections_CollectionAssetMembership_FK1">
            <End Role="Collections" EntitySet="Collections" />
            <End Role="CollectionAssetMembership" EntitySet="CollectionAssetMembership" />
          </AssociationSet>
          <AssociationSet Name="Collections_CollectionRelationships_FK1" Association="WindchimeModel.Store.Collections_CollectionRelationships_FK1">
            <End Role="Collections" EntitySet="Collections" />
            <End Role="CollectionRelationships" EntitySet="CollectionRelationships" />
          </AssociationSet>
          <AssociationSet Name="Collections_CollectionRelationships_FK2" Association="WindchimeModel.Store.Collections_CollectionRelationships_FK2">
            <End Role="Collections" EntitySet="Collections" />
            <End Role="CollectionRelationships" EntitySet="CollectionRelationships" />
          </AssociationSet>
          <AssociationSet Name="Creators_Assets_FK1" Association="WindchimeModel.Store.Creators_Assets_FK1">
            <End Role="Creators" EntitySet="Creators" />
            <End Role="Assets" EntitySet="Assets" />
          </AssociationSet>
          <AssociationSet Name="Creators_Comments_FK1" Association="WindchimeModel.Store.Creators_Comments_FK1">
            <End Role="Creators" EntitySet="Creators" />
            <End Role="Comments" EntitySet="Comments" />
          </AssociationSet>
          <AssociationSet Name="Creators_Users_FK1" Association="WindchimeModel.Store.Creators_Users_FK1">
            <End Role="Creators" EntitySet="Creators" />
            <End Role="Users" EntitySet="Users" />
          </AssociationSet>
          <AssociationSet Name="FK_Collections_AssignmentTypes" Association="WindchimeModel.Store.FK_Collections_AssignmentTypes">
            <End Role="Collections" EntitySet="Collections" />
            <End Role="AssignmentType" EntitySet="AssignmentType" />
          </AssociationSet>
          <AssociationSet Name="FK_EntityTags_Entities" Association="WindchimeModel.Store.FK_EntityTags_Entities">
            <End Role="PermissionableEntities" EntitySet="PermissionableEntities" />
            <End Role="EntityTags" EntitySet="EntityTags" />
          </AssociationSet>
          <AssociationSet Name="FK_EntityTags_Tags" Association="WindchimeModel.Store.FK_EntityTags_Tags">
            <End Role="Tags" EntitySet="Tags" />
            <End Role="EntityTags" EntitySet="EntityTags" />
          </AssociationSet>
          <AssociationSet Name="Groups_AccessControlListEntries_FK1" Association="WindchimeModel.Store.Groups_AccessControlListEntries_FK1">
            <End Role="Groups" EntitySet="Groups" />
            <End Role="PermissionEntries" EntitySet="PermissionEntries" />
          </AssociationSet>
          <AssociationSet Name="Issues_Collections_FK1" Association="WindchimeModel.Store.Issues_Collections_FK1">
            <End Role="Collections" EntitySet="Collections" />
            <End Role="Issues" EntitySet="Issues" />
          </AssociationSet>
          <AssociationSet Name="PermissionableEntity_AccessControlListEntries_FK1" Association="WindchimeModel.Store.PermissionableEntity_AccessControlListEntries_FK1">
            <End Role="PermissionableEntities" EntitySet="PermissionableEntities" />
            <End Role="PermissionEntries" EntitySet="PermissionEntries" />
          </AssociationSet>
          <AssociationSet Name="PermissionableEntity_Assets_FK1" Association="WindchimeModel.Store.PermissionableEntity_Assets_FK1">
            <End Role="PermissionableEntities" EntitySet="PermissionableEntities" />
            <End Role="Assets" EntitySet="Assets" />
          </AssociationSet>
          <AssociationSet Name="PermissionableEntity_Collections_FK1" Association="WindchimeModel.Store.PermissionableEntity_Collections_FK1">
            <End Role="PermissionableEntities" EntitySet="PermissionableEntities" />
            <End Role="Collections" EntitySet="Collections" />
          </AssociationSet>
          <AssociationSet Name="Roles_RoleManagers_FK1" Association="WindchimeModel.Store.Roles_RoleManagers_FK1">
            <End Role="Groups" EntitySet="Groups" />
            <End Role="GroupRelationships" EntitySet="GroupRelationships" />
          </AssociationSet>
          <AssociationSet Name="Roles_RoleManagers_FK2" Association="WindchimeModel.Store.Roles_RoleManagers_FK2">
            <End Role="Groups" EntitySet="Groups" />
            <End Role="GroupRelationships" EntitySet="GroupRelationships" />
          </AssociationSet>
          <AssociationSet Name="Roles_RolePolicies_FK1" Association="WindchimeModel.Store.Roles_RolePolicies_FK1">
            <End Role="Groups" EntitySet="Groups" />
            <End Role="PolicyEntries" EntitySet="PolicyEntries" />
          </AssociationSet>
          <AssociationSet Name="Roles_UserRoleMemberships_FK1" Association="WindchimeModel.Store.Roles_UserRoleMemberships_FK1">
            <End Role="Groups" EntitySet="Groups" />
            <End Role="GroupMemberships" EntitySet="GroupMemberships" />
          </AssociationSet>
          <AssociationSet Name="Users_AssignmentEditors_FK1" Association="WindchimeModel.Store.Users_AssignmentEditors_FK1">
            <End Role="Users" EntitySet="Users" />
            <End Role="AssignmentEditors" EntitySet="AssignmentEditors" />
          </AssociationSet>
          <AssociationSet Name="Users_AssignmentUsers_FK1" Association="WindchimeModel.Store.Users_AssignmentUsers_FK1">
            <End Role="Users" EntitySet="Users" />
            <End Role="AssignmentCreators" EntitySet="AssignmentCreators" />
          </AssociationSet>
          <AssociationSet Name="Users_UserRoleMemberships_FK1" Association="WindchimeModel.Store.Users_UserRoleMemberships_FK1">
            <End Role="Users" EntitySet="Users" />
            <End Role="GroupMemberships" EntitySet="GroupMemberships" />
          </AssociationSet>
          <AssociationSet Name="Versions_ImageVersions_FK1" Association="WindchimeModel.Store.Versions_ImageVersions_FK1">
            <End Role="Versions" EntitySet="Versions" />
            <End Role="BinaryVersions" EntitySet="BinaryVersions" />
          </AssociationSet>
          <AssociationSet Name="Versions_TextVersions_FK1" Association="WindchimeModel.Store.Versions_TextVersions_FK1">
            <End Role="Versions" EntitySet="Versions" />
            <End Role="TextVersions" EntitySet="TextVersions" />
          </AssociationSet>
          <AssociationSet Name="Versions_Versions_FK1" Association="WindchimeModel.Store.Versions_Versions_FK1">
            <End Role="Versions" EntitySet="Versions" />
            <End Role="Versions1" EntitySet="Versions" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="Assets">
          <Key>
            <PropertyRef Name="AssetID" />
          </Key>
          <Property Name="AssetID" Type="int" Nullable="false" />
          <Property Name="Headline" Type="nvarchar(max)" Nullable="false" />
          <Property Name="Summary" Type="text" Nullable="false" />
          <Property Name="CreatorID" Type="int" />
          <Property Name="Approved" Type="bit" Nullable="false" />
          <Property Name="CompletedDate" Type="datetime" />
          <Property Name="TypeID" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="AssetTypes">
          <Key>
            <PropertyRef Name="TypeID" />
          </Key>
          <Property Name="TypeID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
        </EntityType>
        <EntityType Name="AssignmentCreators">
          <Key>
            <PropertyRef Name="AssignmentID" />
            <PropertyRef Name="UserID" />
          </Key>
          <Property Name="AssignmentID" Type="int" Nullable="false" />
          <Property Name="UserID" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="AssignmentEditors">
          <Key>
            <PropertyRef Name="UserID" />
            <PropertyRef Name="AssignmentID" />
          </Key>
          <Property Name="UserID" Type="int" Nullable="false" />
          <Property Name="AssignmentID" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Assignments">
          <Key>
            <PropertyRef Name="AssignmentID" />
          </Key>
          <Property Name="AssignmentID" Type="int" Nullable="false" />
          <Property Name="DueDate" Type="datetime" />
          <Property Name="StartDate" Type="datetime" />
          <Property Name="Summary" Type="varchar" Nullable="false" MaxLength="500" />
          <Property Name="Location" Type="varchar" MaxLength="150" />
          <Property Name="CompletedDate" Type="datetime" />
          <Property Name="PublishPriority" Type="int" />
        </EntityType>
        <EntityType Name="AssignmentType">
          <Key>
            <PropertyRef Name="AssignmentTypeID" />
          </Key>
          <Property Name="AssignmentTypeID" Type="int" Nullable="false" />
          <Property Name="Summary" Type="nvarchar" Nullable="false" MaxLength="50" />
        </EntityType>
        <EntityType Name="BinaryVersions">
          <Key>
            <PropertyRef Name="VersionID" />
          </Key>
          <Property Name="VersionID" Type="int" Nullable="false" />
          <Property Name="Path" Type="nvarchar(max)" Nullable="false" />
        </EntityType>
        <EntityType Name="Categories">
          <Key>
            <PropertyRef Name="CategoryID" />
          </Key>
          <Property Name="CategoryID" Type="int" Nullable="false" />
          <Property Name="Summary" Type="text" Nullable="false" />
        </EntityType>
        <EntityType Name="CollectionAssetMembership">
          <Key>
            <PropertyRef Name="AssetID" />
            <PropertyRef Name="CollectionID" />
          </Key>
          <Property Name="AssetID" Type="int" Nullable="false" />
          <Property Name="CollectionID" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="CollectionRelationships">
          <Key>
            <PropertyRef Name="ParentCollectionID" />
            <PropertyRef Name="ChildCollectionID" />
          </Key>
          <Property Name="ParentCollectionID" Type="int" Nullable="false" />
          <Property Name="ChildCollectionID" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Collections">
          <Key>
            <PropertyRef Name="CollectionID" />
          </Key>
          <Property Name="CollectionID" Type="int" Nullable="false" />
          <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="127" />
        </EntityType>
        <EntityType Name="Comments">
          <Key>
            <PropertyRef Name="EntityID" />
            <PropertyRef Name="CommentID" />
          </Key>
          <Property Name="EntityID" Type="int" Nullable="false" />
          <Property Name="CommentID" Type="int" Nullable="false" />
          <Property Name="Text" Type="text" Nullable="false" />
          <Property Name="CreatorID" Type="int" />
        </EntityType>
        <EntityType Name="Creators">
          <Key>
            <PropertyRef Name="CreatorID" />
          </Key>
          <Property Name="CreatorID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="FirstName" Type="nvarchar" Nullable="false" MaxLength="45" />
          <Property Name="LastName" Type="nvarchar" Nullable="false" MaxLength="45" />
        </EntityType>
        <EntityType Name="EntityTags">
          <Key>
            <PropertyRef Name="EntityID" />
            <PropertyRef Name="TagID" />
          </Key>
          <Property Name="EntityID" Type="int" Nullable="false" />
          <Property Name="TagID" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="GroupMemberships">
          <Key>
            <PropertyRef Name="UserID" />
            <PropertyRef Name="GroupID" />
          </Key>
          <Property Name="UserID" Type="int" Nullable="false" />
          <Property Name="GroupID" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="GroupRelationships">
          <Key>
            <PropertyRef Name="ChildGroupID" />
            <PropertyRef Name="ParentGroupID" />
          </Key>
          <Property Name="ChildGroupID" Type="int" Nullable="false" />
          <Property Name="ParentGroupID" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Groups">
          <Key>
            <PropertyRef Name="GroupID" />
          </Key>
          <Property Name="GroupID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
          <Property Name="IsSpecial" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="Issues">
          <Key>
            <PropertyRef Name="IssueID" />
          </Key>
          <Property Name="IssueID" Type="int" Nullable="false" />
          <Property Name="Date" Type="datetime" Nullable="false" />
          <Property Name="Volume" Type="nvarchar" MaxLength="50" />
        </EntityType>
        <EntityType Name="PermissionableEntities">
          <Key>
            <PropertyRef Name="EntityID" />
          </Key>
          <Property Name="EntityID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Published" Type="bit" />
        </EntityType>
        <EntityType Name="PermissionEntries">
          <Key>
            <PropertyRef Name="GroupID" />
            <PropertyRef Name="EntityID" />
            <PropertyRef Name="Permission" />
          </Key>
          <Property Name="GroupID" Type="int" Nullable="false" />
          <Property Name="EntityID" Type="int" Nullable="false" />
          <Property Name="Permission" Type="int" Nullable="false" />
          <Property Name="IsDeny" Type="bit" Nullable="false" />
          <Property Name="DoesApplyToTarget" Type="bit" Nullable="false" />
          <Property Name="DoesApplyToCollections" Type="bit" Nullable="false" />
          <Property Name="DoesApplyToAssets" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="PolicyEntries">
          <Key>
            <PropertyRef Name="GroupID" />
            <PropertyRef Name="Policy" />
          </Key>
          <Property Name="GroupID" Type="int" Nullable="false" />
          <Property Name="Policy" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Tags">
          <Key>
            <PropertyRef Name="TagID" />
          </Key>
          <Property Name="TagID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Tag" Type="nvarchar" Nullable="false" MaxLength="100" />
        </EntityType>
        <EntityType Name="TextVersions">
          <Key>
            <PropertyRef Name="VersionID" />
          </Key>
          <Property Name="VersionID" Type="int" Nullable="false" />
          <Property Name="Text" Type="text" Nullable="false" />
        </EntityType>
        <EntityType Name="Users">
          <Key>
            <PropertyRef Name="UserID" />
          </Key>
          <Property Name="UserID" Type="int" Nullable="false" />
          <Property Name="Username" Type="varchar" Nullable="false" MaxLength="45" />
          <Property Name="Password" Type="varchar" Nullable="false" MaxLength="100" />
          <Property Name="Address1" Type="varchar" MaxLength="75" />
          <Property Name="Address2" Type="varchar" MaxLength="75" />
          <Property Name="City" Type="varchar" MaxLength="35" />
          <Property Name="State" Type="varchar" MaxLength="35" />
          <Property Name="PostalCode" Type="varchar" MaxLength="20" />
          <Property Name="Country" Type="varchar" MaxLength="10" />
          <Property Name="MobilePhone" Type="int" />
          <Property Name="HomePhone" Type="int" />
          <Property Name="IsStaff" Type="bit" Nullable="false" />
          <Property Name="Email" Type="varchar(max)" />
        </EntityType>
        <EntityType Name="Versions">
          <Key>
            <PropertyRef Name="VersionID" />
          </Key>
          <Property Name="VersionID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="CreatedDate" Type="datetime" Nullable="false" />
          <Property Name="AssetID" Type="int" Nullable="false" />
          <Property Name="Log" Type="text" Nullable="false" />
          <Property Name="ParentVersionID" Type="int" />
        </EntityType>
        <Association Name="Assets_CollectionAssetMembership_FK1">
          <End Role="Assets" Type="WindchimeModel.Store.Assets" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="CollectionAssetMembership" Type="WindchimeModel.Store.CollectionAssetMembership" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Assets">
              <PropertyRef Name="AssetID" />
            </Principal>
            <Dependent Role="CollectionAssetMembership">
              <PropertyRef Name="AssetID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Assets_Comments_FK1">
          <End Role="PermissionableEntities" Type="WindchimeModel.Store.PermissionableEntities" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Comments" Type="WindchimeModel.Store.Comments" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="PermissionableEntities">
              <PropertyRef Name="EntityID" />
            </Principal>
            <Dependent Role="Comments">
              <PropertyRef Name="EntityID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Assets_Versions_FK1">
          <End Role="Assets" Type="WindchimeModel.Store.Assets" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Versions" Type="WindchimeModel.Store.Versions" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Assets">
              <PropertyRef Name="AssetID" />
            </Principal>
            <Dependent Role="Versions">
              <PropertyRef Name="AssetID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="AssetTypes_Assets_FK1">
          <End Role="AssetTypes" Type="WindchimeModel.Store.AssetTypes" Multiplicity="1" />
          <End Role="Assets" Type="WindchimeModel.Store.Assets" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="AssetTypes">
              <PropertyRef Name="TypeID" />
            </Principal>
            <Dependent Role="Assets">
              <PropertyRef Name="TypeID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Assignments_AssignmentEditors_FK1">
          <End Role="Assignments" Type="WindchimeModel.Store.Assignments" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="AssignmentEditors" Type="WindchimeModel.Store.AssignmentEditors" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Assignments">
              <PropertyRef Name="AssignmentID" />
            </Principal>
            <Dependent Role="AssignmentEditors">
              <PropertyRef Name="AssignmentID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Assignments_AssignmentUsers_FK1">
          <End Role="Assignments" Type="WindchimeModel.Store.Assignments" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="AssignmentCreators" Type="WindchimeModel.Store.AssignmentCreators" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Assignments">
              <PropertyRef Name="AssignmentID" />
            </Principal>
            <Dependent Role="AssignmentCreators">
              <PropertyRef Name="AssignmentID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Collections_Assignments_FK1">
          <End Role="Collections" Type="WindchimeModel.Store.Collections" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Assignments" Type="WindchimeModel.Store.Assignments" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Collections">
              <PropertyRef Name="CollectionID" />
            </Principal>
            <Dependent Role="Assignments">
              <PropertyRef Name="AssignmentID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Collections_Categories_FK1">
          <End Role="Collections" Type="WindchimeModel.Store.Collections" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Categories" Type="WindchimeModel.Store.Categories" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Collections">
              <PropertyRef Name="CollectionID" />
            </Principal>
            <Dependent Role="Categories">
              <PropertyRef Name="CategoryID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Collections_CollectionAssetMembership_FK1">
          <End Role="Collections" Type="WindchimeModel.Store.Collections" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="CollectionAssetMembership" Type="WindchimeModel.Store.CollectionAssetMembership" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Collections">
              <PropertyRef Name="CollectionID" />
            </Principal>
            <Dependent Role="CollectionAssetMembership">
              <PropertyRef Name="CollectionID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Collections_CollectionRelationships_FK1">
          <End Role="Collections" Type="WindchimeModel.Store.Collections" Multiplicity="1" />
          <End Role="CollectionRelationships" Type="WindchimeModel.Store.CollectionRelationships" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Collections">
              <PropertyRef Name="CollectionID" />
            </Principal>
            <Dependent Role="CollectionRelationships">
              <PropertyRef Name="ParentCollectionID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Collections_CollectionRelationships_FK2">
          <End Role="Collections" Type="WindchimeModel.Store.Collections" Multiplicity="1" />
          <End Role="CollectionRelationships" Type="WindchimeModel.Store.CollectionRelationships" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Collections">
              <PropertyRef Name="CollectionID" />
            </Principal>
            <Dependent Role="CollectionRelationships">
              <PropertyRef Name="ChildCollectionID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Creators_Assets_FK1">
          <End Role="Creators" Type="WindchimeModel.Store.Creators" Multiplicity="0..1" />
          <End Role="Assets" Type="WindchimeModel.Store.Assets" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Creators">
              <PropertyRef Name="CreatorID" />
            </Principal>
            <Dependent Role="Assets">
              <PropertyRef Name="CreatorID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Creators_Comments_FK1">
          <End Role="Creators" Type="WindchimeModel.Store.Creators" Multiplicity="0..1" />
          <End Role="Comments" Type="WindchimeModel.Store.Comments" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Creators">
              <PropertyRef Name="CreatorID" />
            </Principal>
            <Dependent Role="Comments">
              <PropertyRef Name="CreatorID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Creators_Users_FK1">
          <End Role="Creators" Type="WindchimeModel.Store.Creators" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Users" Type="WindchimeModel.Store.Users" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Creators">
              <PropertyRef Name="CreatorID" />
            </Principal>
            <Dependent Role="Users">
              <PropertyRef Name="UserID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Collections_AssignmentTypes">
          <End Role="Collections" Type="WindchimeModel.Store.Collections" Multiplicity="1" />
          <End Role="AssignmentType" Type="WindchimeModel.Store.AssignmentType" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Collections">
              <PropertyRef Name="CollectionID" />
            </Principal>
            <Dependent Role="AssignmentType">
              <PropertyRef Name="AssignmentTypeID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EntityTags_Entities">
          <End Role="PermissionableEntities" Type="WindchimeModel.Store.PermissionableEntities" Multiplicity="1" />
          <End Role="EntityTags" Type="WindchimeModel.Store.EntityTags" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="PermissionableEntities">
              <PropertyRef Name="EntityID" />
            </Principal>
            <Dependent Role="EntityTags">
              <PropertyRef Name="EntityID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_EntityTags_Tags">
          <End Role="Tags" Type="WindchimeModel.Store.Tags" Multiplicity="1" />
          <End Role="EntityTags" Type="WindchimeModel.Store.EntityTags" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Tags">
              <PropertyRef Name="TagID" />
            </Principal>
            <Dependent Role="EntityTags">
              <PropertyRef Name="TagID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Groups_AccessControlListEntries_FK1">
          <End Role="Groups" Type="WindchimeModel.Store.Groups" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="PermissionEntries" Type="WindchimeModel.Store.PermissionEntries" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groups">
              <PropertyRef Name="GroupID" />
            </Principal>
            <Dependent Role="PermissionEntries">
              <PropertyRef Name="GroupID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Issues_Collections_FK1">
          <End Role="Collections" Type="WindchimeModel.Store.Collections" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Issues" Type="WindchimeModel.Store.Issues" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Collections">
              <PropertyRef Name="CollectionID" />
            </Principal>
            <Dependent Role="Issues">
              <PropertyRef Name="IssueID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="PermissionableEntity_AccessControlListEntries_FK1">
          <End Role="PermissionableEntities" Type="WindchimeModel.Store.PermissionableEntities" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="PermissionEntries" Type="WindchimeModel.Store.PermissionEntries" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="PermissionableEntities">
              <PropertyRef Name="EntityID" />
            </Principal>
            <Dependent Role="PermissionEntries">
              <PropertyRef Name="EntityID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="PermissionableEntity_Assets_FK1">
          <End Role="PermissionableEntities" Type="WindchimeModel.Store.PermissionableEntities" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="Assets" Type="WindchimeModel.Store.Assets" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="PermissionableEntities">
              <PropertyRef Name="EntityID" />
            </Principal>
            <Dependent Role="Assets">
              <PropertyRef Name="AssetID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="PermissionableEntity_Collections_FK1">
          <End Role="PermissionableEntities" Type="WindchimeModel.Store.PermissionableEntities" Multiplicity="1" />
          <End Role="Collections" Type="WindchimeModel.Store.Collections" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="PermissionableEntities">
              <PropertyRef Name="EntityID" />
            </Principal>
            <Dependent Role="Collections">
              <PropertyRef Name="CollectionID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Roles_RoleManagers_FK1">
          <End Role="Groups" Type="WindchimeModel.Store.Groups" Multiplicity="1" />
          <End Role="GroupRelationships" Type="WindchimeModel.Store.GroupRelationships" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groups">
              <PropertyRef Name="GroupID" />
            </Principal>
            <Dependent Role="GroupRelationships">
              <PropertyRef Name="ChildGroupID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Roles_RoleManagers_FK2">
          <End Role="Groups" Type="WindchimeModel.Store.Groups" Multiplicity="1" />
          <End Role="GroupRelationships" Type="WindchimeModel.Store.GroupRelationships" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groups">
              <PropertyRef Name="GroupID" />
            </Principal>
            <Dependent Role="GroupRelationships">
              <PropertyRef Name="ParentGroupID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Roles_RolePolicies_FK1">
          <End Role="Groups" Type="WindchimeModel.Store.Groups" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="PolicyEntries" Type="WindchimeModel.Store.PolicyEntries" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groups">
              <PropertyRef Name="GroupID" />
            </Principal>
            <Dependent Role="PolicyEntries">
              <PropertyRef Name="GroupID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Roles_UserRoleMemberships_FK1">
          <End Role="Groups" Type="WindchimeModel.Store.Groups" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="GroupMemberships" Type="WindchimeModel.Store.GroupMemberships" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Groups">
              <PropertyRef Name="GroupID" />
            </Principal>
            <Dependent Role="GroupMemberships">
              <PropertyRef Name="GroupID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Users_AssignmentEditors_FK1">
          <End Role="Users" Type="WindchimeModel.Store.Users" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="AssignmentEditors" Type="WindchimeModel.Store.AssignmentEditors" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Users">
              <PropertyRef Name="UserID" />
            </Principal>
            <Dependent Role="AssignmentEditors">
              <PropertyRef Name="UserID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Users_AssignmentUsers_FK1">
          <End Role="Users" Type="WindchimeModel.Store.Users" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="AssignmentCreators" Type="WindchimeModel.Store.AssignmentCreators" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Users">
              <PropertyRef Name="UserID" />
            </Principal>
            <Dependent Role="AssignmentCreators">
              <PropertyRef Name="UserID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Users_UserRoleMemberships_FK1">
          <End Role="Users" Type="WindchimeModel.Store.Users" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="GroupMemberships" Type="WindchimeModel.Store.GroupMemberships" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Users">
              <PropertyRef Name="UserID" />
            </Principal>
            <Dependent Role="GroupMemberships">
              <PropertyRef Name="UserID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Versions_ImageVersions_FK1">
          <End Role="Versions" Type="WindchimeModel.Store.Versions" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="BinaryVersions" Type="WindchimeModel.Store.BinaryVersions" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Versions">
              <PropertyRef Name="VersionID" />
            </Principal>
            <Dependent Role="BinaryVersions">
              <PropertyRef Name="VersionID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Versions_TextVersions_FK1">
          <End Role="Versions" Type="WindchimeModel.Store.Versions" Multiplicity="1">
            <OnDelete Action="Cascade" />
          </End>
          <End Role="TextVersions" Type="WindchimeModel.Store.TextVersions" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Versions">
              <PropertyRef Name="VersionID" />
            </Principal>
            <Dependent Role="TextVersions">
              <PropertyRef Name="VersionID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="Versions_Versions_FK1">
          <End Role="Versions" Type="WindchimeModel.Store.Versions" Multiplicity="0..1" />
          <End Role="Versions1" Type="WindchimeModel.Store.Versions" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Versions">
              <PropertyRef Name="VersionID" />
            </Principal>
            <Dependent Role="Versions1">
              <PropertyRef Name="ParentVersionID" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Function Name="DoesGroupHavePolicy" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="GID" Type="int" Mode="In" />
          <Parameter Name="PID" Type="int" Mode="In" />
          <Parameter Name="RESULT" Type="int" Mode="InOut" />
        </Function>
        <Function Name="DoesUserHavePolicy" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="UID" Type="int" Mode="In" />
          <Parameter Name="PID" Type="int" Mode="In" />
          <Parameter Name="RESULT" Type="int" Mode="InOut" />
        </Function>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="WindchimeModel" Alias="Self" xmlns="http://schemas.microsoft.com/ado/2006/04/edm">
        <EntityContainer Name="WindchimeEntities">
          <EntitySet Name="CommentSet" EntityType="WindchimeModel.Comment" />
          <EntitySet Name="CreatorSet" EntityType="WindchimeModel.Creator" />
          <EntitySet Name="VersionSet" EntityType="WindchimeModel.Version" />
          <AssociationSet Name="Creators_Assets_FK1" Association="WindchimeModel.Creators_Assets_FK1">
            <End Role="Creators" EntitySet="CreatorSet" />
            <End Role="Assets" EntitySet="PermissionableEntities" />
          </AssociationSet>
          <AssociationSet Name="Creators_Comments_FK1" Association="WindchimeModel.Creators_Comments_FK1">
            <End Role="Creators" EntitySet="CreatorSet" />
            <End Role="Comments" EntitySet="CommentSet" />
          </AssociationSet>
          <AssociationSet Name="AssignmentCreators" Association="WindchimeModel.AssignmentCreators">
            <End Role="CreatorAssignment" EntitySet="PermissionableEntities" />
            <End Role="Creator" EntitySet="CreatorSet" /></AssociationSet>
          <AssociationSet Name="AssignmentEditors" Association="WindchimeModel.AssignmentEditors">
            <End Role="EditorAssignment" EntitySet="PermissionableEntities" />
            <End Role="Editor" EntitySet="CreatorSet" /></AssociationSet>
          <EntitySet Name="AssetTypeSet" EntityType="WindchimeModel.AssetType" />
          <AssociationSet Name="AssetTypes_Assets_FK1" Association="WindchimeModel.AssetTypes_Assets_FK1">
            <End Role="AssetTypes" EntitySet="AssetTypeSet" />
            <End Role="Asset" EntitySet="PermissionableEntities" /></AssociationSet>
          <AssociationSet Name="CollectionRelationships" Association="WindchimeModel.CollectionRelationships">
            <End Role="ChildCollection" EntitySet="PermissionableEntities" />
            <End Role="ParentCollection" EntitySet="PermissionableEntities" /></AssociationSet>
          <EntitySet Name="Groups" EntityType="WindchimeModel.Group" />
          <EntitySet Name="PermissionableEntities" EntityType="WindchimeModel.PermissionableEntity" />
          <EntitySet Name="PolicyEntries" EntityType="WindchimeModel.PolicyEntry" />
          <AssociationSet Name="Assets_Comments_FK1" Association="WindchimeModel.Assets_Comments_FK1">
            <End Role="PermissionableEntity" EntitySet="PermissionableEntities" />
            <End Role="Comment" EntitySet="CommentSet" /></AssociationSet>
          <AssociationSet Name="CollectionAssetMembership" Association="WindchimeModel.CollectionAssetMembership">
            <End Role="Asset" EntitySet="PermissionableEntities" />
            <End Role="Collection" EntitySet="PermissionableEntities" /></AssociationSet>
          <AssociationSet Name="Roles_RolePolicies_FK11" Association="WindchimeModel.Roles_RolePolicies_FK11">
            <End Role="Group" EntitySet="Groups" />
            <End Role="PolicyEntry" EntitySet="PolicyEntries" /></AssociationSet>
          <AssociationSet Name="GroupMemberships" Association="WindchimeModel.GroupMemberships">
            <End Role="Group" EntitySet="Groups" />
            <End Role="User" EntitySet="CreatorSet" /></AssociationSet>
          <AssociationSet Name="GroupRelationships" Association="WindchimeModel.GroupRelationships">
            <End Role="ParentGroup" EntitySet="Groups" />
            <End Role="ChildGroup" EntitySet="Groups" /></AssociationSet>
          <EntitySet Name="PermissionEntrySet" EntityType="WindchimeModel.PermissionEntry" />
          <AssociationSet Name="Assets_Versions_FK11" Association="WindchimeModel.Assets_Versions_FK11">
            <End Role="Asset" EntitySet="PermissionableEntities" />
            <End Role="Version" EntitySet="VersionSet" /></AssociationSet>
          <AssociationSet Name="Groups_AccessControlListEntries_FK11" Association="WindchimeModel.Groups_AccessControlListEntries_FK11">
            <End Role="Group" EntitySet="Groups" />
            <End Role="PermissionEntries" EntitySet="PermissionEntrySet" /></AssociationSet>
          <AssociationSet Name="PermissionableEntity_AccessControlListEntries_FK11" Association="WindchimeModel.PermissionableEntity_AccessControlListEntries_FK11">
            <End Role="PermissionableEntity" EntitySet="PermissionableEntities" />
            <End Role="PermissionEntries" EntitySet="PermissionEntrySet" /></AssociationSet>
          <AssociationSet Name="Versions_Versions_FK1" Association="WindchimeModel.Versions_Versions_FK1">
            <End Role="ParentVersion" EntitySet="VersionSet" />
            <End Role="ChildVersion" EntitySet="VersionSet" /></AssociationSet>
          <EntitySet Name="AssignmentType" EntityType="WindchimeModel.AssignmentType" />
          <AssociationSet Name="FK_Collections_AssignmentTypes" Association="WindchimeModel.FK_Collections_AssignmentTypes">
            <End Role="Collection" EntitySet="PermissionableEntities" />
            <End Role="AssignmentType" EntitySet="AssignmentType" /></AssociationSet>
          <EntitySet Name="TagsSet" EntityType="WindchimeModel.Tags" />
          <AssociationSet Name="EntityTags1" Association="WindchimeModel.EntityTags1">
            <End Role="PermissionableEntity" EntitySet="PermissionableEntities" />
            <End Role="Tags1" EntitySet="TagsSet" /></AssociationSet></EntityContainer>
        <EntityType Name="Asset" BaseType="WindchimeModel.PermissionableEntity">
          <Property Name="Headline" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
          <Property Name="Summary" Type="String" Nullable="false" MaxLength="Max" Unicode="false" FixedLength="false" />
          <Property Name="Approved" Type="Boolean" Nullable="false" />
          <Property Name="CompletedDate" Type="DateTime" />
          <NavigationProperty Name="Creator" Relationship="WindchimeModel.Creators_Assets_FK1" FromRole="Assets" ToRole="Creators" />
          <NavigationProperty Name="AssetType" Relationship="WindchimeModel.AssetTypes_Assets_FK1" FromRole="Asset" ToRole="AssetTypes" />
          <NavigationProperty Name="Collections" Relationship="WindchimeModel.CollectionAssetMembership" FromRole="Asset" ToRole="Collection" />
          <NavigationProperty Name="Versions" Relationship="WindchimeModel.Assets_Versions_FK11" FromRole="Asset" ToRole="Version" />
          </EntityType>
        <EntityType Name="Assignment" BaseType="WindchimeModel.Collection">
          <Property Name="DueDate" Type="DateTime" />
          <Property Name="StartDate" Type="DateTime" />
          <Property Name="Summary" Type="String" Nullable="false" MaxLength="500" Unicode="false" FixedLength="false" />
          <Property Name="Location" Type="String" MaxLength="150" Unicode="false" FixedLength="false" />
          <Property Name="CompletedDate" Type="DateTime" />
          <NavigationProperty Name="Creators" Relationship="WindchimeModel.AssignmentCreators" FromRole="CreatorAssignment" ToRole="Creator" />
          <NavigationProperty Name="Editors" Relationship="WindchimeModel.AssignmentEditors" FromRole="EditorAssignment" ToRole="Editor" />
          <Property Name="PublishPriority" Type="Int32" Nullable="true" /></EntityType>
        <EntityType Name="Category" BaseType="WindchimeModel.Collection">
          <Property Name="Summary" Type="String" Nullable="false" MaxLength="Max" Unicode="false" FixedLength="false" />
          </EntityType>
        <EntityType Name="Collection" BaseType="WindchimeModel.PermissionableEntity">
          <Property Name="Name" Type="String" Nullable="false" MaxLength="127" Unicode="true" FixedLength="false" />
          <NavigationProperty Name="Parents" Relationship="WindchimeModel.CollectionRelationships" FromRole="ChildCollection" ToRole="ParentCollection" />
          <NavigationProperty Name="Children" Relationship="WindchimeModel.CollectionRelationships" FromRole="ParentCollection" ToRole="ChildCollection" />
          <NavigationProperty Name="Assets" Relationship="WindchimeModel.CollectionAssetMembership" FromRole="Collection" ToRole="Asset" />
          <NavigationProperty Name="AssignmentType" Relationship="WindchimeModel.FK_Collections_AssignmentTypes" FromRole="Collection" ToRole="AssignmentType" /></EntityType>
        <EntityType Name="Comment">
          <Key>
            <PropertyRef Name="CommentID" />
            <PropertyRef Name="EntityID" /></Key>
          <Property Name="CommentID" Type="Int32" Nullable="false" />
          <Property Name="Text" Type="String" Nullable="false" MaxLength="Max" Unicode="false" FixedLength="false" />
          <NavigationProperty Name="Creators" Relationship="WindchimeModel.Creators_Comments_FK1" FromRole="Comments" ToRole="Creators" />
          <Property Name="EntityID" Type="Int32" Nullable="false" />
          <NavigationProperty Name="PermissionableEntities" Relationship="WindchimeModel.Assets_Comments_FK1" FromRole="Comment" ToRole="PermissionableEntity" /></EntityType>
        <EntityType Name="Creator">
          <Key>
            <PropertyRef Name="CreatorID" />
          </Key>
          <Property Name="CreatorID" Type="Int32" Nullable="false" />
          <Property Name="FirstName" Type="String" Nullable="false" MaxLength="45" Unicode="true" FixedLength="false" />
          <Property Name="LastName" Type="String" Nullable="false" MaxLength="45" Unicode="true" FixedLength="false" />
          <NavigationProperty Name="Assets" Relationship="WindchimeModel.Creators_Assets_FK1" FromRole="Creators" ToRole="Assets" />
          <NavigationProperty Name="Comments" Relationship="WindchimeModel.Creators_Comments_FK1" FromRole="Creators" ToRole="Comments" />
          </EntityType>
        <EntityType Name="BinaryVersion" BaseType="WindchimeModel.Version">
          <Property Name="Path" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
        </EntityType>
        <EntityType Name="Issue" BaseType="WindchimeModel.Collection">
          <Property Name="Date" Type="DateTime" Nullable="false" />
          <Property Name="Volume" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          </EntityType>
        <EntityType Name="TextVersion" BaseType="WindchimeModel.Version">
          <Property Name="Text" Type="String" Nullable="false" MaxLength="Max" Unicode="false" FixedLength="false" />
          </EntityType>
        <EntityType Name="User" BaseType="WindchimeModel.Creator">
          <Property Name="Username" Type="String" Nullable="false" MaxLength="45" Unicode="false" FixedLength="false" />
          <Property Name="Password" Type="String" Nullable="false" MaxLength="100" Unicode="false" FixedLength="false" />
          <Property Name="Address1" Type="String" MaxLength="75" Unicode="false" FixedLength="false" />
          <Property Name="Address2" Type="String" MaxLength="75" Unicode="false" FixedLength="false" />
          <Property Name="City" Type="String" MaxLength="35" Unicode="false" FixedLength="false" />
          <Property Name="State" Type="String" MaxLength="35" Unicode="false" FixedLength="false" />
          <Property Name="PostalCode" Type="String" MaxLength="20" Unicode="false" FixedLength="false" />
          <Property Name="Country" Type="String" MaxLength="10" Unicode="false" FixedLength="false" />
          <Property Name="MobilePhone" Type="Int32" />
          <Property Name="HomePhone" Type="Int32" />
          <NavigationProperty Name="CreatorAssignments" Relationship="WindchimeModel.AssignmentCreators" FromRole="Creator" ToRole="CreatorAssignment" />
          <NavigationProperty Name="EditorAssignments" Relationship="WindchimeModel.AssignmentEditors" FromRole="Editor" ToRole="EditorAssignment" />
          <Property Name="IsStaff" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="Groups" Relationship="WindchimeModel.GroupMemberships" FromRole="User" ToRole="Group" />
          <Property Name="Email" Type="String" Nullable="true" /></EntityType>
        <EntityType Name="Version" Abstract="true">
          <Key>
            <PropertyRef Name="VersionID" />
            </Key>
          <Property Name="VersionID" Type="Int32" Nullable="false" />
          <Property Name="CreatedDate" Type="DateTime" Nullable="false" />
          <Property Name="Log" Type="String" Nullable="false" />
          <NavigationProperty Name="Assets" Relationship="WindchimeModel.Assets_Versions_FK11" FromRole="Version" ToRole="Asset" />
          <NavigationProperty Name="Children" Relationship="WindchimeModel.Versions_Versions_FK1" FromRole="ParentVersion" ToRole="ChildVersion" />
          <NavigationProperty Name="Parent" Relationship="WindchimeModel.Versions_Versions_FK1" FromRole="ChildVersion" ToRole="ParentVersion" /></EntityType>
        <Association Name="Creators_Assets_FK1">
          <End Role="Creators" Type="WindchimeModel.Creator" Multiplicity="0..1" />
          <End Role="Assets" Type="WindchimeModel.Asset" Multiplicity="*" />
        </Association>
        <Association Name="Creators_Comments_FK1">
          <End Role="Creators" Type="WindchimeModel.Creator" Multiplicity="0..1" />
          <End Role="Comments" Type="WindchimeModel.Comment" Multiplicity="*" />
        </Association>
        <Association Name="AssignmentCreators">
          <End Type="WindchimeModel.Assignment" Role="CreatorAssignment" Multiplicity="*" />
          <End Type="WindchimeModel.User" Role="Creator" Multiplicity="*" /></Association>
        <Association Name="AssignmentEditors">
          <End Type="WindchimeModel.Assignment" Role="EditorAssignment" Multiplicity="*" />
          <End Type="WindchimeModel.User" Role="Editor" Multiplicity="*" /></Association>
        <EntityType Name="AssetType">
          <Key>
            <PropertyRef Name="TypeID" /></Key>
          <Property Name="TypeID" Type="Int32" Nullable="false" />
          <Property Name="Name" Type="String" Nullable="false" />
          <NavigationProperty Name="Assets" Relationship="WindchimeModel.AssetTypes_Assets_FK1" FromRole="AssetTypes" ToRole="Asset" /></EntityType>
        <Association Name="AssetTypes_Assets_FK1">
          <End Type="WindchimeModel.AssetType" Role="AssetTypes" Multiplicity="1" />
          <End Type="WindchimeModel.Asset" Role="Asset" Multiplicity="*" /></Association>
        <Association Name="CollectionRelationships">
          <End Type="WindchimeModel.Collection" Role="ChildCollection" Multiplicity="*" />
          <End Type="WindchimeModel.Collection" Role="ParentCollection" Multiplicity="*" /></Association>
        <EntityType Name="Group">
          <Key>
            <PropertyRef Name="GroupID" /></Key>
          <Property Name="GroupID" Type="Int32" Nullable="false" />
          <Property Name="Name" Type="String" Nullable="false" />
          <NavigationProperty Name="PolicyEntries" Relationship="WindchimeModel.Roles_RolePolicies_FK11" FromRole="Group" ToRole="PolicyEntry" />
          <NavigationProperty Name="Users" Relationship="WindchimeModel.GroupMemberships" FromRole="Group" ToRole="User" />
          <NavigationProperty Name="Children" Relationship="WindchimeModel.GroupRelationships" FromRole="ParentGroup" ToRole="ChildGroup" />
          <NavigationProperty Name="Parents" Relationship="WindchimeModel.GroupRelationships" FromRole="ChildGroup" ToRole="ParentGroup" />
          <Property Name="IsSpecial" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="PermissionEntries" Relationship="WindchimeModel.Groups_AccessControlListEntries_FK11" FromRole="Group" ToRole="PermissionEntries" /></EntityType>
        <EntityType Name="PermissionableEntity">
          <Key>
            <PropertyRef Name="EntityID" /></Key>
          <Property Name="EntityID" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Comments" Relationship="WindchimeModel.Assets_Comments_FK1" FromRole="PermissionableEntity" ToRole="Comment" />
          <NavigationProperty Name="PermissionEntries" Relationship="WindchimeModel.PermissionableEntity_AccessControlListEntries_FK11" FromRole="PermissionableEntity" ToRole="PermissionEntries" />
          <NavigationProperty Name="Tags" Relationship="WindchimeModel.EntityTags1" FromRole="PermissionableEntity" ToRole="Tags1" />
          <Property Name="Published" Type="Boolean" Nullable="false" /></EntityType>
        <EntityType Name="PolicyEntry">
          <Key>
            <PropertyRef Name="policy_int" />
            <PropertyRef Name="GroupID" /></Key>
          <Property Name="policy_int" Type="Int32" Nullable="false" a:GetterAccess="Private" xmlns:a="http://schemas.microsoft.com/ado/2006/04/codegeneration" a:SetterAccess="Private" />
          <Property Name="GroupID" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Groups" Relationship="WindchimeModel.Roles_RolePolicies_FK11" FromRole="PolicyEntry" ToRole="Group" /></EntityType>
        <Association Name="Assets_Comments_FK1">
          <End Type="WindchimeModel.PermissionableEntity" Role="PermissionableEntity" Multiplicity="1" />
          <End Type="WindchimeModel.Comment" Role="Comment" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="PermissionableEntity">
              <PropertyRef Name="EntityID" /></Principal>
            <Dependent Role="Comment">
              <PropertyRef Name="EntityID" /></Dependent></ReferentialConstraint></Association>
        <Association Name="CollectionAssetMembership">
          <End Type="WindchimeModel.Asset" Role="Asset" Multiplicity="*" />
          <End Type="WindchimeModel.Collection" Role="Collection" Multiplicity="*" /></Association>
        <Association Name="Roles_RolePolicies_FK11">
          <End Type="WindchimeModel.Group" Role="Group" Multiplicity="1" />
          <End Type="WindchimeModel.PolicyEntry" Role="PolicyEntry" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Group">
              <PropertyRef Name="GroupID" /></Principal>
            <Dependent Role="PolicyEntry">
              <PropertyRef Name="GroupID" /></Dependent></ReferentialConstraint></Association>
        <Association Name="GroupMemberships">
          <End Type="WindchimeModel.Group" Role="Group" Multiplicity="*" />
          <End Type="WindchimeModel.User" Role="User" Multiplicity="*" /></Association>
        <Association Name="GroupRelationships">
          <End Type="WindchimeModel.Group" Role="ParentGroup" Multiplicity="*" />
          <End Type="WindchimeModel.Group" Role="ChildGroup" Multiplicity="*" /></Association>
        <EntityType Name="PermissionEntry">
          <Key>
            <PropertyRef Name="GroupID" />
            <PropertyRef Name="EntityID" />
            <PropertyRef Name="Permission" /></Key>
          <Property Name="GroupID" Type="Int32" Nullable="false" />
          <Property Name="EntityID" Type="Int32" Nullable="false" />
          <Property Name="Permission" Type="Int32" Nullable="false" />
          <Property Name="IsDeny" Type="Boolean" Nullable="false" />
          <Property Name="DoesApplyToTarget" Type="Boolean" Nullable="false" />
          <Property Name="DoesApplyToCollections" Type="Boolean" Nullable="false" />
          <Property Name="DoesApplyToAssets" Type="Boolean" Nullable="false" />
          <NavigationProperty Name="Groups" Relationship="WindchimeModel.Groups_AccessControlListEntries_FK11" FromRole="PermissionEntries" ToRole="Group" />
          <NavigationProperty Name="PermissionableEntities" Relationship="WindchimeModel.PermissionableEntity_AccessControlListEntries_FK11" FromRole="PermissionEntries" ToRole="PermissionableEntity" /></EntityType>
        <Association Name="Assets_Versions_FK11">
          <End Type="WindchimeModel.Asset" Role="Asset" Multiplicity="1" />
          <End Type="WindchimeModel.Version" Role="Version" Multiplicity="*" />
          </Association>
        <Association Name="Groups_AccessControlListEntries_FK11">
          <End Type="WindchimeModel.Group" Role="Group" Multiplicity="1" />
          <End Type="WindchimeModel.PermissionEntry" Role="PermissionEntries" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Group">
              <PropertyRef Name="GroupID" /></Principal>
            <Dependent Role="PermissionEntries">
              <PropertyRef Name="GroupID" /></Dependent></ReferentialConstraint></Association>
        <Association Name="PermissionableEntity_AccessControlListEntries_FK11">
          <End Type="WindchimeModel.PermissionableEntity" Role="PermissionableEntity" Multiplicity="1" />
          <End Type="WindchimeModel.PermissionEntry" Role="PermissionEntries" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="PermissionableEntity">
              <PropertyRef Name="EntityID" /></Principal>
            <Dependent Role="PermissionEntries">
              <PropertyRef Name="EntityID" /></Dependent></ReferentialConstraint></Association>
        <Association Name="Versions_Versions_FK1">
          <End Type="WindchimeModel.Version" Role="ParentVersion" Multiplicity="0..1" />
          <End Type="WindchimeModel.Version" Role="ChildVersion" Multiplicity="*" /></Association>
        <EntityType Name="AssignmentType">
          <Key>
            <PropertyRef Name="AssignmentTypeID" /></Key>
          <Property Name="AssignmentTypeID" Type="Int32" Nullable="false" />
          <Property Name="Summary" Type="String" Nullable="true" />
          <NavigationProperty Name="Collections" Relationship="WindchimeModel.FK_Collections_AssignmentTypes" FromRole="AssignmentType" ToRole="Collection" /></EntityType>
        <Association Name="FK_Collections_AssignmentTypes">
          <End Type="WindchimeModel.Collection" Role="Collection" Multiplicity="1" />
          <End Type="WindchimeModel.AssignmentType" Role="AssignmentType" Multiplicity="0..1" />
          <ReferentialConstraint>
            <Principal Role="Collection">
              <PropertyRef Name="EntityID" /></Principal>
            <Dependent Role="AssignmentType">
              <PropertyRef Name="AssignmentTypeID" /></Dependent></ReferentialConstraint></Association>
        <EntityType Name="Tags">
          <Key>
            <PropertyRef Name="TagID" /></Key>
          <Property Name="TagID" Type="Int32" Nullable="false" />
          <Property Name="Tag" Type="String" Nullable="false" />
          <NavigationProperty Name="PermissionableEntities" Relationship="WindchimeModel.EntityTags1" FromRole="Tags1" ToRole="PermissionableEntity" /></EntityType>
        <Association Name="EntityTags1">
          <End Type="WindchimeModel.PermissionableEntity" Role="PermissionableEntity" Multiplicity="*" />
          <End Type="WindchimeModel.Tags" Role="Tags1" Multiplicity="*" /></Association></Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="urn:schemas-microsoft-com:windows:storage:mapping:CS">
        <EntityContainerMapping StorageEntityContainer="WindchimeModelStoreContainer" CdmEntityContainer="WindchimeEntities">
          <EntitySetMapping Name="CommentSet">
            <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.Comment)">
              <MappingFragment StoreEntitySet="Comments">
                <ScalarProperty Name="EntityID" ColumnName="EntityID" />
                <ScalarProperty Name="CommentID" ColumnName="CommentID" />
                <ScalarProperty Name="Text" ColumnName="Text" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="CreatorSet">
            <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.Creator)">
              <MappingFragment StoreEntitySet="Creators">
                <ScalarProperty Name="CreatorID" ColumnName="CreatorID" />
                <ScalarProperty Name="FirstName" ColumnName="FirstName" />
                <ScalarProperty Name="LastName" ColumnName="LastName" />
              </MappingFragment>
            </EntityTypeMapping>
          <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.User)">
              <MappingFragment StoreEntitySet="Users">
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="IsStaff" ColumnName="IsStaff" />
                <ScalarProperty Name="CreatorID" ColumnName="UserID" />
                <ScalarProperty Name="Username" ColumnName="Username" />
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="Address1" ColumnName="Address1" />
                <ScalarProperty Name="Address2" ColumnName="Address2" />
                <ScalarProperty Name="City" ColumnName="City" />
                <ScalarProperty Name="State" ColumnName="State" />
                <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
                <ScalarProperty Name="Country" ColumnName="Country" />
                <ScalarProperty Name="MobilePhone" ColumnName="MobilePhone" />
                <ScalarProperty Name="HomePhone" ColumnName="HomePhone" />
              </MappingFragment>
            </EntityTypeMapping></EntitySetMapping>
          <EntitySetMapping Name="VersionSet">
            <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.Version)">
              <MappingFragment StoreEntitySet="Versions">
                <ScalarProperty Name="Log" ColumnName="Log" />
                <ScalarProperty Name="VersionID" ColumnName="VersionID" />
                <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" />
              </MappingFragment>
            </EntityTypeMapping>
          <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.TextVersion)">
              <MappingFragment StoreEntitySet="TextVersions">
                <ScalarProperty Name="VersionID" ColumnName="VersionID" />
                <ScalarProperty Name="Text" ColumnName="Text" />
              </MappingFragment>
            </EntityTypeMapping>
            <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.BinaryVersion)">
              <MappingFragment StoreEntitySet="BinaryVersions">
                <ScalarProperty Name="VersionID" ColumnName="VersionID" />
                <ScalarProperty Name="Path" ColumnName="Path" /></MappingFragment></EntityTypeMapping></EntitySetMapping>
          <AssociationSetMapping Name="Creators_Comments_FK1" TypeName="WindchimeModel.Creators_Comments_FK1" StoreEntitySet="Comments">
            <EndProperty Name="Creators">
              <ScalarProperty Name="CreatorID" ColumnName="CreatorID" />
            </EndProperty>
            <EndProperty Name="Comments">
              <ScalarProperty Name="EntityID" ColumnName="EntityID" />
              <ScalarProperty Name="CommentID" ColumnName="CommentID" />
            </EndProperty>
          <Condition ColumnName="CreatorID" IsNull="false" /></AssociationSetMapping>
          <EntitySetMapping Name="AssetTypeSet">
            <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.AssetType)">
              <MappingFragment StoreEntitySet="AssetTypes">
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="TypeID" ColumnName="TypeID" /></MappingFragment></EntityTypeMapping></EntitySetMapping>
          <EntitySetMapping Name="Groups">
            <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.Group)">
              <MappingFragment StoreEntitySet="Groups">
                <ScalarProperty Name="IsSpecial" ColumnName="IsSpecial" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="GroupID" ColumnName="GroupID" /></MappingFragment></EntityTypeMapping></EntitySetMapping>
          <EntitySetMapping Name="PolicyEntries">
            <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.PolicyEntry)">
              <MappingFragment StoreEntitySet="PolicyEntries">
                <ScalarProperty Name="GroupID" ColumnName="GroupID" />
                <ScalarProperty Name="policy_int" ColumnName="Policy" />
                </MappingFragment></EntityTypeMapping></EntitySetMapping>
          <EntitySetMapping Name="PermissionableEntities">
            <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.PermissionableEntity)">
              <MappingFragment StoreEntitySet="PermissionableEntities">
                <ScalarProperty Name="Published" ColumnName="Published" />
                <ScalarProperty Name="EntityID" ColumnName="EntityID" /></MappingFragment></EntityTypeMapping><EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.Collection)">
              <MappingFragment StoreEntitySet="Collections">
                <ScalarProperty Name="EntityID" ColumnName="CollectionID" />
                <ScalarProperty Name="Name" ColumnName="Name" />
              </MappingFragment>
            </EntityTypeMapping><EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.Assignment)">
              <MappingFragment StoreEntitySet="Assignments">
                <ScalarProperty Name="PublishPriority" ColumnName="PublishPriority" />
                <ScalarProperty Name="EntityID" ColumnName="AssignmentID" />
                
                <ScalarProperty Name="DueDate" ColumnName="DueDate" />
                <ScalarProperty Name="StartDate" ColumnName="StartDate" />
                <ScalarProperty Name="Summary" ColumnName="Summary" />
                <ScalarProperty Name="Location" ColumnName="Location" />
                <ScalarProperty Name="CompletedDate" ColumnName="CompletedDate" />
              </MappingFragment>
            </EntityTypeMapping><EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.Issue)">
              <MappingFragment StoreEntitySet="Issues">
                <ScalarProperty Name="EntityID" ColumnName="IssueID" />
                
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Volume" ColumnName="Volume" />
              </MappingFragment>
            </EntityTypeMapping><EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.Category)">
              <MappingFragment StoreEntitySet="Categories">
                <ScalarProperty Name="EntityID" ColumnName="CategoryID" />
                
                <ScalarProperty Name="Summary" ColumnName="Summary" />
              </MappingFragment>
            </EntityTypeMapping><EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.Asset)">
              <MappingFragment StoreEntitySet="Assets">
                <ScalarProperty Name="EntityID" ColumnName="AssetID" />
                <ScalarProperty Name="Headline" ColumnName="Headline" />
                <ScalarProperty Name="Summary" ColumnName="Summary" />
                <ScalarProperty Name="Approved" ColumnName="Approved" />
                <ScalarProperty Name="CompletedDate" ColumnName="CompletedDate" />
              </MappingFragment>
            </EntityTypeMapping></EntitySetMapping>
          <AssociationSetMapping Name="AssignmentCreators" TypeName="WindchimeModel.AssignmentCreators" StoreEntitySet="AssignmentCreators" >
            <EndProperty Name="Creator">
              <ScalarProperty Name="CreatorID" ColumnName="UserID" /></EndProperty>
            <EndProperty Name="CreatorAssignment">
              <ScalarProperty Name="EntityID" ColumnName="AssignmentID" /></EndProperty></AssociationSetMapping>
          <AssociationSetMapping Name="AssignmentEditors" TypeName="WindchimeModel.AssignmentEditors" StoreEntitySet="AssignmentEditors" >
            <EndProperty Name="Editor">
              <ScalarProperty Name="CreatorID" ColumnName="UserID" /></EndProperty>
            <EndProperty Name="EditorAssignment">
              <ScalarProperty Name="EntityID" ColumnName="AssignmentID" /></EndProperty></AssociationSetMapping>
          <AssociationSetMapping Name="CollectionRelationships" TypeName="WindchimeModel.CollectionRelationships" StoreEntitySet="CollectionRelationships" >
            <EndProperty Name="ParentCollection">
              <ScalarProperty Name="EntityID" ColumnName="ParentCollectionID" /></EndProperty>
            <EndProperty Name="ChildCollection">
              <ScalarProperty Name="EntityID" ColumnName="ChildCollectionID" /></EndProperty></AssociationSetMapping>
          <AssociationSetMapping Name="Creators_Assets_FK1" TypeName="WindchimeModel.Creators_Assets_FK1" StoreEntitySet="Assets">
            <EndProperty Name="Assets">
              <ScalarProperty Name="EntityID" ColumnName="AssetID" /></EndProperty>
            <EndProperty Name="Creators">
              <ScalarProperty Name="CreatorID" ColumnName="CreatorID" /></EndProperty>
            <Condition ColumnName="CreatorID" IsNull="false" /></AssociationSetMapping>
          <AssociationSetMapping Name="AssetTypes_Assets_FK1" TypeName="WindchimeModel.AssetTypes_Assets_FK1" StoreEntitySet="Assets">
            <EndProperty Name="Asset">
              <ScalarProperty Name="EntityID" ColumnName="AssetID" /></EndProperty>
            <EndProperty Name="AssetTypes">
              <ScalarProperty Name="TypeID" ColumnName="TypeID" /></EndProperty></AssociationSetMapping>
          <AssociationSetMapping Name="Assets_Comments_FK1" TypeName="WindchimeModel.Assets_Comments_FK1" StoreEntitySet="Comments">
            <EndProperty Name="Comment">
              <ScalarProperty Name="CommentID" ColumnName="CommentID" />
              <ScalarProperty Name="EntityID" ColumnName="EntityID" /></EndProperty>
            <EndProperty Name="PermissionableEntity">
              <ScalarProperty Name="EntityID" ColumnName="EntityID" /></EndProperty></AssociationSetMapping>
          <AssociationSetMapping Name="CollectionAssetMembership" TypeName="WindchimeModel.CollectionAssetMembership" StoreEntitySet="CollectionAssetMembership">
            <EndProperty Name="Collection">
              <ScalarProperty Name="EntityID" ColumnName="CollectionID" /></EndProperty>
            <EndProperty Name="Asset">
              <ScalarProperty Name="EntityID" ColumnName="AssetID" /></EndProperty></AssociationSetMapping>
          <AssociationSetMapping Name="Roles_RolePolicies_FK11" TypeName="WindchimeModel.Roles_RolePolicies_FK11" StoreEntitySet="PolicyEntries">
            <EndProperty Name="PolicyEntry">
              <ScalarProperty Name="policy_int" ColumnName="Policy" />
              <ScalarProperty Name="GroupID" ColumnName="GroupID" /></EndProperty>
            <EndProperty Name="Group">
              <ScalarProperty Name="GroupID" ColumnName="GroupID" /></EndProperty></AssociationSetMapping>
          <AssociationSetMapping Name="GroupMemberships" TypeName="WindchimeModel.GroupMemberships" StoreEntitySet="GroupMemberships">
            <EndProperty Name="User">
              <ScalarProperty Name="CreatorID" ColumnName="UserID" /></EndProperty>
            <EndProperty Name="Group">
              <ScalarProperty Name="GroupID" ColumnName="GroupID" /></EndProperty></AssociationSetMapping>
          <AssociationSetMapping Name="GroupRelationships" TypeName="WindchimeModel.GroupRelationships" StoreEntitySet="GroupRelationships">
            <EndProperty Name="ChildGroup">
              <ScalarProperty Name="GroupID" ColumnName="ChildGroupID" /></EndProperty>
            <EndProperty Name="ParentGroup">
              <ScalarProperty Name="GroupID" ColumnName="ParentGroupID" /></EndProperty></AssociationSetMapping>
          <EntitySetMapping Name="PermissionEntrySet">
            <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.PermissionEntry)">
              <MappingFragment StoreEntitySet="PermissionEntries">
                <ScalarProperty Name="DoesApplyToAssets" ColumnName="DoesApplyToAssets" />
                <ScalarProperty Name="DoesApplyToCollections" ColumnName="DoesApplyToCollections" />
                <ScalarProperty Name="DoesApplyToTarget" ColumnName="DoesApplyToTarget" />
                <ScalarProperty Name="IsDeny" ColumnName="IsDeny" />
                <ScalarProperty Name="Permission" ColumnName="Permission" />
                <ScalarProperty Name="EntityID" ColumnName="EntityID" />
                <ScalarProperty Name="GroupID" ColumnName="GroupID" /></MappingFragment></EntityTypeMapping></EntitySetMapping>
          <AssociationSetMapping Name="Groups_AccessControlListEntries_FK11" TypeName="WindchimeModel.Groups_AccessControlListEntries_FK11" StoreEntitySet="PermissionEntries">
            <EndProperty Name="PermissionEntries">
              <ScalarProperty Name="Permission" ColumnName="Permission" />
              <ScalarProperty Name="EntityID" ColumnName="EntityID" />
              <ScalarProperty Name="GroupID" ColumnName="GroupID" /></EndProperty>
            <EndProperty Name="Group">
              <ScalarProperty Name="GroupID" ColumnName="GroupID" /></EndProperty></AssociationSetMapping>
          <AssociationSetMapping Name="PermissionableEntity_AccessControlListEntries_FK11" TypeName="WindchimeModel.PermissionableEntity_AccessControlListEntries_FK11" StoreEntitySet="PermissionEntries">
            <EndProperty Name="PermissionEntries">
              <ScalarProperty Name="Permission" ColumnName="Permission" />
              <ScalarProperty Name="EntityID" ColumnName="EntityID" />
              <ScalarProperty Name="GroupID" ColumnName="GroupID" /></EndProperty>
            <EndProperty Name="PermissionableEntity">
              <ScalarProperty Name="EntityID" ColumnName="EntityID" /></EndProperty></AssociationSetMapping>
          <AssociationSetMapping Name="Versions_Versions_FK1" TypeName="WindchimeModel.Versions_Versions_FK1" StoreEntitySet="Versions">
            <EndProperty Name="ChildVersion">
              <ScalarProperty Name="VersionID" ColumnName="VersionID" /></EndProperty>
            <EndProperty Name="ParentVersion">
              <ScalarProperty Name="VersionID" ColumnName="ParentVersionID" /></EndProperty>
            <Condition ColumnName="ParentVersionID" IsNull="false" /></AssociationSetMapping>
          <AssociationSetMapping Name="Assets_Versions_FK11" TypeName="WindchimeModel.Assets_Versions_FK11" StoreEntitySet="Versions">
            <EndProperty Name="Asset">
              <ScalarProperty Name="EntityID" ColumnName="AssetID" /></EndProperty>
            <EndProperty Name="Version">
              <ScalarProperty Name="VersionID" ColumnName="VersionID" /></EndProperty></AssociationSetMapping>
          <EntitySetMapping Name="AssignmentType">
            <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.AssignmentType)">
              <MappingFragment StoreEntitySet="AssignmentType">
                <ScalarProperty Name="Summary" ColumnName="Summary" />
                <ScalarProperty Name="AssignmentTypeID" ColumnName="AssignmentTypeID" /></MappingFragment></EntityTypeMapping></EntitySetMapping>
          <AssociationSetMapping Name="FK_Collections_AssignmentTypes" TypeName="WindchimeModel.FK_Collections_AssignmentTypes" StoreEntitySet="AssignmentType">
            <EndProperty Name="AssignmentType">
              <ScalarProperty Name="AssignmentTypeID" ColumnName="AssignmentTypeID" /></EndProperty>
            <EndProperty Name="Collection">
              <ScalarProperty Name="EntityID" ColumnName="AssignmentTypeID" /></EndProperty></AssociationSetMapping>
          <EntitySetMapping Name="TagsSet">
            <EntityTypeMapping TypeName="IsTypeOf(WindchimeModel.Tags)">
              <MappingFragment StoreEntitySet="Tags">
                <ScalarProperty Name="Tag" ColumnName="Tag" />
                <ScalarProperty Name="TagID" ColumnName="TagID" /></MappingFragment></EntityTypeMapping></EntitySetMapping>
          <AssociationSetMapping Name="EntityTags1" TypeName="WindchimeModel.EntityTags1" StoreEntitySet="EntityTags">
            <EndProperty Name="Tags1">
              <ScalarProperty Name="TagID" ColumnName="TagID" /></EndProperty>
            <EndProperty Name="PermissionableEntity">
              <ScalarProperty Name="EntityID" ColumnName="EntityID" /></EndProperty></AssociationSetMapping></EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <edmx:Designer xmlns="http://schemas.microsoft.com/ado/2007/06/edmx">
    <edmx:Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </edmx:Connection>
    <edmx:Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
      </DesignerInfoPropertySet>
    </edmx:Options>
    <!-- Diagram content (shape and connector positions) -->
    <edmx:Diagrams>
      <Diagram Name="WindchimeModel" ZoomLevel="73">
        <EntityTypeShape EntityType="WindchimeModel.Asset" Width="1.5" PointX="3" PointY="8.75" Height="2.2496956380208317" IsExpanded="true" />
        <EntityTypeShape EntityType="WindchimeModel.Assignment" Width="1.5" PointX="9.5" PointY="10.5" Height="2.2496956380208335" IsExpanded="true" />
        <EntityTypeShape EntityType="WindchimeModel.Category" Width="1.5" PointX="5.25" PointY="8.375" Height="1.2110807291666665" IsExpanded="true" />
        <EntityTypeShape EntityType="WindchimeModel.Collection" Width="1.5" PointX="8" PointY="8.5" Height="1.5956835937499996" IsExpanded="true" />
        <EntityTypeShape EntityType="WindchimeModel.Comment" Width="1.5" PointX="0.5" PointY="7.25" Height="1.9802864583333335" IsExpanded="true" />
        <EntityTypeShape EntityType="WindchimeModel.Creator" Width="1.5" PointX="0.5" PointY="10.25" Height="1.9802864583333335" IsExpanded="true" />
        <EntityTypeShape EntityType="WindchimeModel.BinaryVersion" Width="1.5" PointX="3.625" PointY="14.875" Height="1.2110807291666674" IsExpanded="true" />
        <EntityTypeShape EntityType="WindchimeModel.Issue" Width="1.5" PointX="10" PointY="7.875" Height="1.2636116536458335" IsExpanded="true" />
        <EntityTypeShape EntityType="WindchimeModel.TextVersion" Width="1.5" PointX="6.75" PointY="15" Height="1.2110807291666674" IsExpanded="true" />
        <EntityTypeShape EntityType="WindchimeModel.User" Width="1.5" PointX="8.875" PointY="13.625" Height="3.7109993489583353" IsExpanded="true" />
        <EntityTypeShape EntityType="WindchimeModel.Version" Width="1.5" PointX="5.125" PointY="12" Height="1.9210009765624996" IsExpanded="true" />
        <InheritanceConnector EntityType="WindchimeModel.Assignment" ManuallyRouted="false">
          <ConnectorPoint PointX="8.71875" PointY="10.256653645833332" />
          <ConnectorPoint PointX="8.71875" PointY="11.624847819010416" />
          <ConnectorPoint PointX="9.5" PointY="11.624847819010416" />
          </InheritanceConnector>
        <InheritanceConnector EntityType="WindchimeModel.BinaryVersion" ManuallyRouted="false">
          <ConnectorPoint PointX="5.90625" PointY="13.9210009765625" />
          <ConnectorPoint PointX="5.90625" PointY="15.424632161458334" />
          <ConnectorPoint PointX="5.125" PointY="15.424632161458334" /></InheritanceConnector>
        <InheritanceConnector EntityType="WindchimeModel.TextVersion" ManuallyRouted="false">
          <ConnectorPoint PointX="6.2968775" PointY="13.9210009765625" />
          <ConnectorPoint PointX="6.2968775" PointY="15.793200742187501" />
          <ConnectorPoint PointX="6.75" PointY="15.793200742187501" /></InheritanceConnector>
        <InheritanceConnector EntityType="WindchimeModel.User" ManuallyRouted="false">
          <ConnectorPoint PointX="1.25" PointY="12.230286458333334" />
          <ConnectorPoint PointX="1.25" PointY="16.900940755208335" />
          <ConnectorPoint PointX="8.875" PointY="16.900940755208335" />
          </InheritanceConnector>
        <AssociationConnector Association="WindchimeModel.Creators_Assets_FK1" ManuallyRouted="false">
          <ConnectorPoint PointX="2" PointY="10.624847819010416" />
          <ConnectorPoint PointX="3" PointY="10.624847819010416" />
          </AssociationConnector>
        <AssociationConnector Association="WindchimeModel.Creators_Comments_FK1" ManuallyRouted="false">
          <ConnectorPoint PointX="1.25" PointY="10.25" />
          <ConnectorPoint PointX="1.25" PointY="9.2302864583333335" />
          </AssociationConnector>
        <AssociationConnector Association="WindchimeModel.AssignmentCreators" ManuallyRouted="false">
          <ConnectorPoint PointX="9.7500129594569458" PointY="12.749695638020834" />
          <ConnectorPoint PointX="9.7500129594569458" PointY="13.625" />
          </AssociationConnector>
        <AssociationConnector Association="WindchimeModel.AssignmentEditors" ManuallyRouted="false">
          <ConnectorPoint PointX="10.125006479728473" PointY="12.749695638020834" />
          <ConnectorPoint PointX="10.125006479728473" PointY="13.625" />
          </AssociationConnector>
        <InheritanceConnector EntityType="WindchimeModel.Issue" ManuallyRouted="false">
          <ConnectorPoint PointX="9.5" PointY="8.8515168965960953" />
          <ConnectorPoint PointX="9.75" PointY="8.8515168965960953" />
          <ConnectorPoint PointX="9.75" PointY="8.8193058268229159" />
          <ConnectorPoint PointX="10" PointY="8.8193058268229159" /></InheritanceConnector>
        <EntityTypeShape EntityType="WindchimeModel.AssetType" Width="1.5" PointX="2.125" PointY="12.75" Height="1.59568359375" />
        <AssociationConnector Association="WindchimeModel.AssetTypes_Assets_FK1" >
          <ConnectorPoint PointX="3.3125" PointY="12.75" />
          <ConnectorPoint PointX="3.3125" PointY="10.999695638020832" />
          </AssociationConnector>
        <AssociationConnector Association="WindchimeModel.CollectionRelationships" ManuallyRouted="false" >
          <ConnectorPoint PointX="8.5319230769230767" PointY="10.256653645833332" />
          <ConnectorPoint PointX="8.5319230769230767" PointY="10.506653645833332" />
          <ConnectorPoint PointX="8.6354166666666661" PointY="10.506653645833332" />
          <ConnectorPoint PointX="8.8020833333333339" PointY="10.506653645833332" />
          <ConnectorPoint PointX="8.9784615384615378" PointY="10.506653645833332" />
          <ConnectorPoint PointX="8.9784615384615378" PointY="10.256653645833332" /></AssociationConnector>
        <InheritanceConnector EntityType="WindchimeModel.Category" ManuallyRouted="false">
          <ConnectorPoint PointX="8" PointY="9.0978214227534586" />
          <ConnectorPoint PointX="7.375" PointY="9.0978214227534586" />
          <ConnectorPoint PointX="7.375" PointY="8.9813616746341935" />
          <ConnectorPoint PointX="6.75" PointY="8.9813616746341935" /></InheritanceConnector>
        <EntityTypeShape EntityType="WindchimeModel.Group" Width="1.5" PointX="12.25" PointY="10.375" Height="2.2496956380208335" />
        <EntityTypeShape EntityType="WindchimeModel.PermissionableEntity" Width="2.625" PointX="2.375" PointY="6.5" Height="1.7566536458333335" />
        <EntityTypeShape EntityType="WindchimeModel.PolicyEntry" Width="1.5" PointX="12.875" PointY="13.75" Height="1.7879850260416674" />
        <InheritanceConnector EntityType="WindchimeModel.Collection" ManuallyRouted="false">
          <ConnectorPoint PointX="5" PointY="7.8446442179617488" />
          <ConnectorPoint PointX="8.4671398755356222" PointY="7.8446442179617488" />
          <ConnectorPoint PointX="8.4671398755356222" PointY="8.5" />
          </InheritanceConnector>
        <InheritanceConnector EntityType="WindchimeModel.Asset" ManuallyRouted="false">
          <ConnectorPoint PointX="3.75" PointY="8.2566536458333335" />
          <ConnectorPoint PointX="3.75" PointY="8.75" />
          </InheritanceConnector>
        <AssociationConnector Association="WindchimeModel.Assets_Comments_FK1" >
          <ConnectorPoint PointX="2.375" PointY="7.7533268229166667" />
          <ConnectorPoint PointX="2" PointY="7.7533268229166667" />
          </AssociationConnector>
        <AssociationConnector Association="WindchimeModel.CollectionAssetMembership" >
          <ConnectorPoint PointX="4.5" PointY="9.896708984375" />
          <ConnectorPoint PointX="8" PointY="9.896708984375" />
          </AssociationConnector>
        <AssociationConnector Association="WindchimeModel.Roles_RolePolicies_FK11" >
          <ConnectorPoint PointX="13.3125" PointY="12.624695638020834" />
          <ConnectorPoint PointX="13.3125" PointY="13.75" /></AssociationConnector>
        <AssociationConnector Association="WindchimeModel.GroupMemberships" >
          <ConnectorPoint PointX="12.53125" PointY="12.624695638020834" />
          <ConnectorPoint PointX="12.53125" PointY="16.132792968750003" />
          <ConnectorPoint PointX="10.375" PointY="16.132792968750003" /></AssociationConnector>
        <AssociationConnector Association="WindchimeModel.GroupRelationships" ManuallyRouted="false" >
          <ConnectorPoint PointX="12.781923076923077" PointY="10.375" />
          <ConnectorPoint PointX="12.781923076923077" PointY="10.125" />
          <ConnectorPoint PointX="13.228461538461538" PointY="10.125" />
          <ConnectorPoint PointX="13.228461538461538" PointY="10.375" /></AssociationConnector>
        <EntityTypeShape EntityType="WindchimeModel.PermissionEntry" Width="2" PointX="14.5" PointY="8.25" Height="2.4140429687499996" />
        <AssociationConnector Association="WindchimeModel.Assets_Versions_FK11" >
          <ConnectorPoint PointX="4.09375" PointY="10.999695638020832" />
          <ConnectorPoint PointX="4.09375" PointY="12.34375" />
          <ConnectorPoint PointX="5.125" PointY="12.34375" /></AssociationConnector>
        <AssociationConnector Association="WindchimeModel.Groups_AccessControlListEntries_FK11" >
          <ConnectorPoint PointX="13.75" PointY="11.644369803385416" />
          <ConnectorPoint PointX="15.5" PointY="11.644369803385416" />
          <ConnectorPoint PointX="15.5" PointY="10.66404296875" /></AssociationConnector>
        <AssociationConnector Association="WindchimeModel.PermissionableEntity_AccessControlListEntries_FK11" >
          <ConnectorPoint PointX="5" PointY="7.4639794921875" />
          <ConnectorPoint PointX="8.9134514177379085" PointY="7.4639794921874989" />
          <ConnectorPoint PointX="9.0801180844045764" PointY="7.4639794921875" />
          <ConnectorPoint PointX="15.5" PointY="7.4639794921875" />
          <ConnectorPoint PointX="15.5" PointY="8.25" /></AssociationConnector>
        <AssociationConnector Association="WindchimeModel.Versions_Versions_FK1" >
          <ConnectorPoint PointX="5.6569230769230767" PointY="12" />
          <ConnectorPoint PointX="5.6569230769230767" PointY="11.75" />
          <ConnectorPoint PointX="6.1034615384615378" PointY="11.75" />
          <ConnectorPoint PointX="6.1034615384615378" PointY="12" /></AssociationConnector>
        <EntityTypeShape EntityType="WindchimeModel.AssignmentType" Width="1.625" PointX="10.25" PointY="5.625" Height="1.4279589843749996" />
        <AssociationConnector Association="WindchimeModel.FK_Collections_AssignmentTypes" >
          <ConnectorPoint PointX="8.9967847510712424" PointY="8.5" />
          <ConnectorPoint PointX="8.9967847510712424" PointY="6.3389794921875" />
          <ConnectorPoint PointX="10.25" PointY="6.3389794921875" /></AssociationConnector>
        <EntityTypeShape EntityType="WindchimeModel.Tags" Width="1.5" PointX="5.875" PointY="5.5" Height="1.4279589843749996" />
        <AssociationConnector Association="WindchimeModel.EntityTags1" >
          <ConnectorPoint PointX="5" PointY="6.7139794921875" />
          <ConnectorPoint PointX="5.875" PointY="6.7139794921875" />
          </AssociationConnector></Diagram></edmx:Diagrams>
  </edmx:Designer>
</edmx:Edmx>