Mr.Combet Webshell
Your IP :
216.73.216.136
Server IP :
103.233.58.157
Server :
Windows NT WIN-4PGF72KEHKB 10.0 build 17763 (Windows Server 2016) AMD64
Server Software :
Microsoft-IIS/10.0
PHP Version :
7.3.25
Add File :
Submit
Add Directory :
Submit
Dir :
C:
/
inetpub
/
wwwroot
/
HRDC
/
HRDC
/
Models
/
View File Name :
modelHRDC.edmx
<?xml version="1.0" encoding="utf-8"?> <edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx"> <!-- EF Runtime content --> <edmx:Runtime> <!-- SSDL content --> <edmx:StorageModels> <Schema Namespace="dbHRDCModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl"> <EntityType Name="__MigrationHistory"> <Key> <PropertyRef Name="MigrationId" /> <PropertyRef Name="ContextKey" /> </Key> <Property Name="MigrationId" Type="nvarchar" MaxLength="150" Nullable="false" /> <Property Name="ContextKey" Type="nvarchar" MaxLength="300" Nullable="false" /> <Property Name="Model" Type="varbinary(max)" Nullable="false" /> <Property Name="ProductVersion" Type="nvarchar" MaxLength="32" Nullable="false" /> </EntityType> <EntityType Name="AspNetRoles"> <Key> <PropertyRef Name="Id" /> </Key> <Property Name="Id" Type="nvarchar" MaxLength="128" Nullable="false" /> <Property Name="Name" Type="nvarchar" MaxLength="256" Nullable="false" /> </EntityType> <EntityType Name="AspNetUserClaims"> <Key> <PropertyRef Name="Id" /> </Key> <Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="UserId" Type="nvarchar" MaxLength="128" Nullable="false" /> <Property Name="ClaimType" Type="nvarchar(max)" /> <Property Name="ClaimValue" Type="nvarchar(max)" /> </EntityType> <EntityType Name="AspNetUserLogins"> <Key> <PropertyRef Name="LoginProvider" /> <PropertyRef Name="ProviderKey" /> <PropertyRef Name="UserId" /> </Key> <Property Name="LoginProvider" Type="nvarchar" MaxLength="128" Nullable="false" /> <Property Name="ProviderKey" Type="nvarchar" MaxLength="128" Nullable="false" /> <Property Name="UserId" Type="nvarchar" MaxLength="128" Nullable="false" /> </EntityType> <EntityType Name="AspNetUserRoles"> <Key> <PropertyRef Name="UserId" /> <PropertyRef Name="RoleId" /> </Key> <Property Name="UserId" Type="nvarchar" MaxLength="128" Nullable="false" /> <Property Name="RoleId" Type="nvarchar" MaxLength="128" Nullable="false" /> </EntityType> <EntityType Name="AspNetUsers"> <Key> <PropertyRef Name="Id" /> </Key> <Property Name="Id" Type="nvarchar" MaxLength="128" Nullable="false" /> <Property Name="Email" Type="nvarchar" MaxLength="256" /> <Property Name="EmailConfirmed" Type="bit" Nullable="false" /> <Property Name="PasswordHash" Type="nvarchar(max)" /> <Property Name="SecurityStamp" Type="nvarchar(max)" /> <Property Name="PhoneNumber" Type="nvarchar(max)" /> <Property Name="PhoneNumberConfirmed" Type="bit" Nullable="false" /> <Property Name="TwoFactorEnabled" Type="bit" Nullable="false" /> <Property Name="LockoutEndDateUtc" Type="datetime" /> <Property Name="LockoutEnabled" Type="bit" Nullable="false" /> <Property Name="AccessFailedCount" Type="int" Nullable="false" /> <Property Name="UserName" Type="nvarchar" MaxLength="256" Nullable="false" /> </EntityType> <EntityType Name="Award"> <Key> <PropertyRef Name="AwardID" /> </Key> <Property Name="AwardID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="AwardTitle" Type="nvarchar" MaxLength="100" /> <Property Name="AwardImage" Type="varchar" MaxLength="100" /> <Property Name="AwardDescription" Type="varchar" MaxLength="100" /> <Property Name="AwardDetail" Type="ntext" /> <Property Name="AwardPublishDate" Type="datetime" /> <Property Name="Tags" Type="varchar" MaxLength="100" /> <Property Name="CreatedBy" Type="int" /> <Property Name="CreatedDate" Type="datetime" /> <Property Name="UpdatedBy" Type="int" /> <Property Name="UpdatedDate" Type="datetime" /> <Property Name="Remarks" Type="nvarchar" MaxLength="200" /> </EntityType> <EntityType Name="EarthquakeResponse"> <Key> <PropertyRef Name="EarthquakeResponseID" /> </Key> <Property Name="EarthquakeResponseID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="ResponseTitle" Type="nvarchar" MaxLength="100" /> <Property Name="ResponseImage" Type="varchar" MaxLength="100" /> <Property Name="ResponseDescription" Type="varchar" MaxLength="100" /> <Property Name="ResponseDetail" Type="ntext" /> <Property Name="ResponsePublishDate" Type="datetime" /> <Property Name="CreatedBy" Type="int" /> <Property Name="CreatedDate" Type="datetime" /> <Property Name="UpdatedBy" Type="int" /> <Property Name="UpdatedDate" Type="datetime" /> <Property Name="Tags" Type="varchar" MaxLength="100" /> <Property Name="Remarks" Type="nvarchar" MaxLength="200" /> </EntityType> <EntityType Name="Gallery"> <Key> <PropertyRef Name="GalleryID" /> </Key> <Property Name="GalleryID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="AlbumID" Type="int" /> <Property Name="ImageURL" Type="varchar" MaxLength="100" /> <Property Name="ImageCaption" Type="varchar" MaxLength="100" /> </EntityType> <EntityType Name="GalleryAlbum"> <Key> <PropertyRef Name="AlbumID" /> </Key> <Property Name="AlbumID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="AlbumName" Type="varchar" MaxLength="100" /> <Property Name="AlbumDescription" Type="varchar" MaxLength="100" /> <Property Name="AlbumPublishDate" Type="datetime" /> <Property Name="AlbumImageURL" Type="varchar" MaxLength="100" /> <Property Name="CreatedBy" Type="int" /> <Property Name="CreatedDate" Type="datetime" /> <Property Name="UpdatedBy" Type="int" /> <Property Name="UpdatedDate" Type="datetime" /> <Property Name="Tags" Type="varchar" MaxLength="100" /> </EntityType> <EntityType Name="MainBanner"> <Key> <PropertyRef Name="MainBannerID" /> </Key> <Property Name="MainBannerID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="BannerTitle" Type="nvarchar" MaxLength="100" /> <Property Name="BannerImage" Type="varchar" MaxLength="100" /> <Property Name="BannerDescription" Type="varchar" MaxLength="100" /> <Property Name="BannerDetail" Type="ntext" /> <Property Name="BannerPublishDate" Type="datetime" /> <Property Name="CreatedBy" Type="int" /> <Property Name="CreatedDate" Type="datetime" /> <Property Name="UpdatedBy" Type="int" /> <Property Name="UpdatedDate" Type="datetime" /> <Property Name="Tags" Type="varchar" MaxLength="100" /> <Property Name="Remarks" Type="nvarchar" MaxLength="200" /> </EntityType> <EntityType Name="OtherContent"> <Key> <PropertyRef Name="ContentID" /> </Key> <Property Name="ContentID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="ContentTitle" Type="nvarchar" MaxLength="50" /> <Property Name="ContentImage" Type="varchar" MaxLength="100" /> <Property Name="ContentDescription" Type="varchar" MaxLength="100" /> <Property Name="ContentDetail" Type="ntext" /> <Property Name="ContentPublishDate" Type="datetime" /> <Property Name="CreatedBy" Type="int" /> <Property Name="CreatedDate" Type="datetime" /> <Property Name="UpdatedBy" Type="int" /> <Property Name="UpdatedDate" Type="datetime" /> <Property Name="Tags" Type="varchar" MaxLength="100" /> <Property Name="Remarks" Type="nvarchar" MaxLength="200" /> </EntityType> <EntityType Name="OurPrograms"> <Key> <PropertyRef Name="ProgramID" /> </Key> <Property Name="ProgramID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="ProgramTitle" Type="nvarchar" MaxLength="50" /> <Property Name="ProgramImage" Type="varchar" MaxLength="100" /> <Property Name="ProgramDescription" Type="varchar" MaxLength="100" /> <Property Name="ProgramDetail" Type="ntext" /> <Property Name="ProgramPublishDate" Type="datetime" /> <Property Name="CreatedBy" Type="int" /> <Property Name="CreatedDate" Type="datetime" /> <Property Name="UpdatedBy" Type="int" /> <Property Name="UpdatedDate" Type="datetime" /> <Property Name="Tags" Type="varchar" MaxLength="100" /> <Property Name="Remarks" Type="nvarchar" MaxLength="200" /> </EntityType> <EntityType Name="SuccessStories"> <Key> <PropertyRef Name="SuccessStoryID" /> </Key> <Property Name="SuccessStoryID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="SuccessStoryTitle" Type="nvarchar" MaxLength="100" /> <Property Name="SuccessStoryImage" Type="varchar" MaxLength="100" /> <Property Name="SuccessStoryDescription" Type="varchar" MaxLength="100" /> <Property Name="SuccessStoryDetail" Type="ntext" /> <Property Name="SuccessStoryPublishDate" Type="datetime" /> <Property Name="Tags" Type="varchar" MaxLength="100" /> <Property Name="CreatedBy" Type="int" /> <Property Name="CreatedDate" Type="datetime" /> <Property Name="UpdatedBy" Type="int" /> <Property Name="UpdatedDate" Type="datetime" /> <Property Name="Remarks" Type="nvarchar" MaxLength="200" /> </EntityType> <EntityType Name="sysdiagrams"> <Key> <PropertyRef Name="diagram_id" /> </Key> <Property Name="name" Type="nvarchar" MaxLength="128" Nullable="false" /> <Property Name="principal_id" Type="int" Nullable="false" /> <Property Name="diagram_id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="version" Type="int" /> <Property Name="definition" Type="varbinary(max)" /> </EntityType> <EntityType Name="TagLinks"> <Key> <PropertyRef Name="TagLinkID" /> </Key> <Property Name="TagLinkID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="TagID" Type="int" /> <Property Name="URL" Type="varchar" MaxLength="500" /> <Property Name="Title" Type="varchar" MaxLength="100" /> <Property Name="Type" Type="varchar" MaxLength="50" /> <Property Name="TypeID" Type="int" /> </EntityType> <EntityType Name="Tags"> <Key> <PropertyRef Name="TagID" /> </Key> <Property Name="TagID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="TagName" Type="varchar" MaxLength="50" /> <Property Name="Remarks" Type="varchar" MaxLength="500" /> </EntityType> <EntityType Name="Team"> <Key> <PropertyRef Name="TeamID" /> </Key> <Property Name="TeamID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="TeamTitle" Type="nvarchar" MaxLength="50" /> <Property Name="TeamImage" Type="varchar" MaxLength="100" /> <Property Name="TeamDescription" Type="varchar" MaxLength="100" /> <Property Name="TeamDetail" Type="ntext" /> <Property Name="TeamPublishDate" Type="datetime" /> <Property Name="CreatedBy" Type="int" /> <Property Name="CreatedDate" Type="datetime" /> <Property Name="UpdatedBy" Type="int" /> <Property Name="UpdatedDate" Type="datetime" /> <Property Name="Tags" Type="varchar" MaxLength="100" /> <Property Name="Remarks" Type="nvarchar" MaxLength="200" /> </EntityType> <EntityType Name="Video"> <Key> <PropertyRef Name="VideoID" /> </Key> <Property Name="VideoID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> <Property Name="VideoURL" Type="varchar" MaxLength="100" /> <Property Name="VideoCaption" Type="varchar" MaxLength="100" /> <Property Name="VideoPublishDate" Type="datetime" /> <Property Name="CreatedBy" Type="int" /> <Property Name="CreatedDate" Type="datetime" /> <Property Name="UpdatedBy" Type="int" /> <Property Name="UpdatedDate" Type="datetime" /> <Property Name="Tags" Type="varchar" MaxLength="100" /> <Property Name="Remarks" Type="nvarchar" MaxLength="200" /> </EntityType> <Association Name="FK_dbo_AspNetUserClaims_dbo_AspNetUsers_UserId"> <End Role="AspNetUsers" Type="Self.AspNetUsers" Multiplicity="1"> <OnDelete Action="Cascade" /> </End> <End Role="AspNetUserClaims" Type="Self.AspNetUserClaims" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="AspNetUsers"> <PropertyRef Name="Id" /> </Principal> <Dependent Role="AspNetUserClaims"> <PropertyRef Name="UserId" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_dbo_AspNetUserLogins_dbo_AspNetUsers_UserId"> <End Role="AspNetUsers" Type="Self.AspNetUsers" Multiplicity="1"> <OnDelete Action="Cascade" /> </End> <End Role="AspNetUserLogins" Type="Self.AspNetUserLogins" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="AspNetUsers"> <PropertyRef Name="Id" /> </Principal> <Dependent Role="AspNetUserLogins"> <PropertyRef Name="UserId" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_dbo_AspNetUserRoles_dbo_AspNetRoles_RoleId"> <End Role="AspNetRoles" Type="Self.AspNetRoles" Multiplicity="1"> <OnDelete Action="Cascade" /> </End> <End Role="AspNetUserRoles" Type="Self.AspNetUserRoles" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="AspNetRoles"> <PropertyRef Name="Id" /> </Principal> <Dependent Role="AspNetUserRoles"> <PropertyRef Name="RoleId" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_dbo_AspNetUserRoles_dbo_AspNetUsers_UserId"> <End Role="AspNetUsers" Type="Self.AspNetUsers" Multiplicity="1"> <OnDelete Action="Cascade" /> </End> <End Role="AspNetUserRoles" Type="Self.AspNetUserRoles" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="AspNetUsers"> <PropertyRef Name="Id" /> </Principal> <Dependent Role="AspNetUserRoles"> <PropertyRef Name="UserId" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_Gallery_GalleryAlbum"> <End Role="GalleryAlbum" Type="Self.GalleryAlbum" Multiplicity="0..1" /> <End Role="Gallery" Type="Self.Gallery" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="GalleryAlbum"> <PropertyRef Name="AlbumID" /> </Principal> <Dependent Role="Gallery"> <PropertyRef Name="AlbumID" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_TagLinks_Tags"> <End Role="Tags" Type="Self.Tags" Multiplicity="0..1" /> <End Role="TagLinks" Type="Self.TagLinks" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="Tags"> <PropertyRef Name="TagID" /> </Principal> <Dependent Role="TagLinks"> <PropertyRef Name="TagID" /> </Dependent> </ReferentialConstraint> </Association> <EntityContainer Name="dbHRDCModelStoreContainer"> <EntitySet Name="__MigrationHistory" EntityType="Self.__MigrationHistory" Schema="dbo" store:Type="Tables" /> <EntitySet Name="AspNetRoles" EntityType="Self.AspNetRoles" Schema="dbo" store:Type="Tables" /> <EntitySet Name="AspNetUserClaims" EntityType="Self.AspNetUserClaims" Schema="dbo" store:Type="Tables" /> <EntitySet Name="AspNetUserLogins" EntityType="Self.AspNetUserLogins" Schema="dbo" store:Type="Tables" /> <EntitySet Name="AspNetUserRoles" EntityType="Self.AspNetUserRoles" Schema="dbo" store:Type="Tables" /> <EntitySet Name="AspNetUsers" EntityType="Self.AspNetUsers" Schema="dbo" store:Type="Tables" /> <EntitySet Name="Award" EntityType="Self.Award" Schema="dbo" store:Type="Tables" /> <EntitySet Name="EarthquakeResponse" EntityType="Self.EarthquakeResponse" Schema="dbo" store:Type="Tables" /> <EntitySet Name="Gallery" EntityType="Self.Gallery" Schema="dbo" store:Type="Tables" /> <EntitySet Name="GalleryAlbum" EntityType="Self.GalleryAlbum" Schema="dbo" store:Type="Tables" /> <EntitySet Name="MainBanner" EntityType="Self.MainBanner" Schema="dbo" store:Type="Tables" /> <EntitySet Name="OtherContent" EntityType="Self.OtherContent" Schema="dbo" store:Type="Tables" /> <EntitySet Name="OurPrograms" EntityType="Self.OurPrograms" Schema="dbo" store:Type="Tables" /> <EntitySet Name="SuccessStories" EntityType="Self.SuccessStories" Schema="dbo" store:Type="Tables" /> <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" /> <EntitySet Name="TagLinks" EntityType="Self.TagLinks" Schema="dbo" store:Type="Tables" /> <EntitySet Name="Tags" EntityType="Self.Tags" Schema="dbo" store:Type="Tables" /> <EntitySet Name="Team" EntityType="Self.Team" Schema="dbo" store:Type="Tables" /> <EntitySet Name="Video" EntityType="Self.Video" Schema="dbo" store:Type="Tables" /> <AssociationSet Name="FK_dbo_AspNetUserClaims_dbo_AspNetUsers_UserId" Association="Self.FK_dbo_AspNetUserClaims_dbo_AspNetUsers_UserId"> <End Role="AspNetUsers" EntitySet="AspNetUsers" /> <End Role="AspNetUserClaims" EntitySet="AspNetUserClaims" /> </AssociationSet> <AssociationSet Name="FK_dbo_AspNetUserLogins_dbo_AspNetUsers_UserId" Association="Self.FK_dbo_AspNetUserLogins_dbo_AspNetUsers_UserId"> <End Role="AspNetUsers" EntitySet="AspNetUsers" /> <End Role="AspNetUserLogins" EntitySet="AspNetUserLogins" /> </AssociationSet> <AssociationSet Name="FK_dbo_AspNetUserRoles_dbo_AspNetRoles_RoleId" Association="Self.FK_dbo_AspNetUserRoles_dbo_AspNetRoles_RoleId"> <End Role="AspNetRoles" EntitySet="AspNetRoles" /> <End Role="AspNetUserRoles" EntitySet="AspNetUserRoles" /> </AssociationSet> <AssociationSet Name="FK_dbo_AspNetUserRoles_dbo_AspNetUsers_UserId" Association="Self.FK_dbo_AspNetUserRoles_dbo_AspNetUsers_UserId"> <End Role="AspNetUsers" EntitySet="AspNetUsers" /> <End Role="AspNetUserRoles" EntitySet="AspNetUserRoles" /> </AssociationSet> <AssociationSet Name="FK_Gallery_GalleryAlbum" Association="Self.FK_Gallery_GalleryAlbum"> <End Role="GalleryAlbum" EntitySet="GalleryAlbum" /> <End Role="Gallery" EntitySet="Gallery" /> </AssociationSet> <AssociationSet Name="FK_TagLinks_Tags" Association="Self.FK_TagLinks_Tags"> <End Role="Tags" EntitySet="Tags" /> <End Role="TagLinks" EntitySet="TagLinks" /> </AssociationSet> </EntityContainer> </Schema></edmx:StorageModels> <!-- CSDL content --> <edmx:ConceptualModels> <Schema Namespace="dbHRDCModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm"> <EntityContainer Name="dbHRDCEntities" annotation:LazyLoadingEnabled="true"> <EntitySet Name="C__MigrationHistory" EntityType="dbHRDCModel.C__MigrationHistory" /> <EntitySet Name="AspNetRoles" EntityType="dbHRDCModel.AspNetRole" /> <EntitySet Name="AspNetUserClaims" EntityType="dbHRDCModel.AspNetUserClaim" /> <EntitySet Name="AspNetUserLogins" EntityType="dbHRDCModel.AspNetUserLogin" /> <EntitySet Name="AspNetUsers" EntityType="dbHRDCModel.AspNetUser" /> <AssociationSet Name="FK_dbo_AspNetUserClaims_dbo_AspNetUsers_UserId" Association="dbHRDCModel.FK_dbo_AspNetUserClaims_dbo_AspNetUsers_UserId"> <End Role="AspNetUser" EntitySet="AspNetUsers" /> <End Role="AspNetUserClaim" EntitySet="AspNetUserClaims" /> </AssociationSet> <AssociationSet Name="FK_dbo_AspNetUserLogins_dbo_AspNetUsers_UserId" Association="dbHRDCModel.FK_dbo_AspNetUserLogins_dbo_AspNetUsers_UserId"> <End Role="AspNetUser" EntitySet="AspNetUsers" /> <End Role="AspNetUserLogin" EntitySet="AspNetUserLogins" /> </AssociationSet> <AssociationSet Name="AspNetUserRoles" Association="dbHRDCModel.AspNetUserRoles"> <End Role="AspNetRole" EntitySet="AspNetRoles" /> <End Role="AspNetUser" EntitySet="AspNetUsers" /> </AssociationSet> <EntitySet Name="Awards" EntityType="dbHRDCModel.Award" /> <EntitySet Name="Galleries" EntityType="dbHRDCModel.Gallery" /> <EntitySet Name="MainBanners" EntityType="dbHRDCModel.MainBanner" /> <EntitySet Name="OtherContents" EntityType="dbHRDCModel.OtherContent" /> <EntitySet Name="OurPrograms" EntityType="dbHRDCModel.OurProgram" /> <EntitySet Name="SuccessStories" EntityType="dbHRDCModel.SuccessStory" /> <EntitySet Name="sysdiagrams" EntityType="dbHRDCModel.sysdiagram" /> <EntitySet Name="Teams" EntityType="dbHRDCModel.Team" /> <EntitySet Name="Videos" EntityType="dbHRDCModel.Video" /> <EntitySet Name="EarthquakeResponses" EntityType="dbHRDCModel.EarthquakeResponse" /> <EntitySet Name="GalleryAlbums" EntityType="dbHRDCModel.GalleryAlbum" /> <AssociationSet Name="FK_Gallery_GalleryAlbum" Association="dbHRDCModel.FK_Gallery_GalleryAlbum"> <End Role="GalleryAlbum" EntitySet="GalleryAlbums" /> <End Role="Gallery" EntitySet="Galleries" /> </AssociationSet> <EntitySet Name="TagLinks" EntityType="dbHRDCModel.TagLink" /> <EntitySet Name="Tags" EntityType="dbHRDCModel.Tag" /> <AssociationSet Name="FK_TagLinks_Tags" Association="dbHRDCModel.FK_TagLinks_Tags"> <End Role="Tag" EntitySet="Tags" /> <End Role="TagLink" EntitySet="TagLinks" /> </AssociationSet> </EntityContainer> <EntityType Name="C__MigrationHistory"> <Key> <PropertyRef Name="MigrationId" /> <PropertyRef Name="ContextKey" /> </Key> <Property Name="MigrationId" Type="String" Nullable="false" MaxLength="150" FixedLength="false" Unicode="true" /> <Property Name="ContextKey" Type="String" Nullable="false" MaxLength="300" FixedLength="false" Unicode="true" /> <Property Name="Model" Type="Binary" Nullable="false" MaxLength="Max" FixedLength="false" /> <Property Name="ProductVersion" Type="String" Nullable="false" MaxLength="32" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="AspNetRole"> <Key> <PropertyRef Name="Id" /> </Key> <Property Name="Id" Type="String" Nullable="false" MaxLength="128" FixedLength="false" Unicode="true" /> <Property Name="Name" Type="String" Nullable="false" MaxLength="256" FixedLength="false" Unicode="true" /> <NavigationProperty Name="AspNetUsers" Relationship="dbHRDCModel.AspNetUserRoles" FromRole="AspNetRole" ToRole="AspNetUser" /> </EntityType> <EntityType Name="AspNetUserClaim"> <Key> <PropertyRef Name="Id" /> </Key> <Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="UserId" Type="String" Nullable="false" MaxLength="128" FixedLength="false" Unicode="true" /> <Property Name="ClaimType" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="ClaimValue" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <NavigationProperty Name="AspNetUser" Relationship="dbHRDCModel.FK_dbo_AspNetUserClaims_dbo_AspNetUsers_UserId" FromRole="AspNetUserClaim" ToRole="AspNetUser" /> </EntityType> <EntityType Name="AspNetUserLogin"> <Key> <PropertyRef Name="LoginProvider" /> <PropertyRef Name="ProviderKey" /> <PropertyRef Name="UserId" /> </Key> <Property Name="LoginProvider" Type="String" Nullable="false" MaxLength="128" FixedLength="false" Unicode="true" /> <Property Name="ProviderKey" Type="String" Nullable="false" MaxLength="128" FixedLength="false" Unicode="true" /> <Property Name="UserId" Type="String" Nullable="false" MaxLength="128" FixedLength="false" Unicode="true" /> <NavigationProperty Name="AspNetUser" Relationship="dbHRDCModel.FK_dbo_AspNetUserLogins_dbo_AspNetUsers_UserId" FromRole="AspNetUserLogin" ToRole="AspNetUser" /> </EntityType> <EntityType Name="AspNetUser"> <Key> <PropertyRef Name="Id" /> </Key> <Property Name="Id" Type="String" Nullable="false" MaxLength="128" FixedLength="false" Unicode="true" /> <Property Name="Email" Type="String" MaxLength="256" FixedLength="false" Unicode="true" /> <Property Name="EmailConfirmed" Type="Boolean" Nullable="false" /> <Property Name="PasswordHash" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="SecurityStamp" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="PhoneNumber" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="PhoneNumberConfirmed" Type="Boolean" Nullable="false" /> <Property Name="TwoFactorEnabled" Type="Boolean" Nullable="false" /> <Property Name="LockoutEndDateUtc" Type="DateTime" Precision="3" /> <Property Name="LockoutEnabled" Type="Boolean" Nullable="false" /> <Property Name="AccessFailedCount" Type="Int32" Nullable="false" /> <Property Name="UserName" Type="String" Nullable="false" MaxLength="256" FixedLength="false" Unicode="true" /> <NavigationProperty Name="AspNetUserClaims" Relationship="dbHRDCModel.FK_dbo_AspNetUserClaims_dbo_AspNetUsers_UserId" FromRole="AspNetUser" ToRole="AspNetUserClaim" /> <NavigationProperty Name="AspNetUserLogins" Relationship="dbHRDCModel.FK_dbo_AspNetUserLogins_dbo_AspNetUsers_UserId" FromRole="AspNetUser" ToRole="AspNetUserLogin" /> <NavigationProperty Name="AspNetRoles" Relationship="dbHRDCModel.AspNetUserRoles" FromRole="AspNetUser" ToRole="AspNetRole" /> </EntityType> <Association Name="FK_dbo_AspNetUserClaims_dbo_AspNetUsers_UserId"> <End Type="dbHRDCModel.AspNetUser" Role="AspNetUser" Multiplicity="1"> <OnDelete Action="Cascade" /> </End> <End Type="dbHRDCModel.AspNetUserClaim" Role="AspNetUserClaim" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="AspNetUser"> <PropertyRef Name="Id" /> </Principal> <Dependent Role="AspNetUserClaim"> <PropertyRef Name="UserId" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="FK_dbo_AspNetUserLogins_dbo_AspNetUsers_UserId"> <End Type="dbHRDCModel.AspNetUser" Role="AspNetUser" Multiplicity="1"> <OnDelete Action="Cascade" /> </End> <End Type="dbHRDCModel.AspNetUserLogin" Role="AspNetUserLogin" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="AspNetUser"> <PropertyRef Name="Id" /> </Principal> <Dependent Role="AspNetUserLogin"> <PropertyRef Name="UserId" /> </Dependent> </ReferentialConstraint> </Association> <Association Name="AspNetUserRoles"> <End Type="dbHRDCModel.AspNetRole" Role="AspNetRole" Multiplicity="*" /> <End Type="dbHRDCModel.AspNetUser" Role="AspNetUser" Multiplicity="*" /> </Association> <EntityType Name="Award"> <Key> <PropertyRef Name="AwardID" /> </Key> <Property Name="AwardID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="AwardTitle" Type="String" MaxLength="100" FixedLength="false" Unicode="true" /> <Property Name="AwardImage" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="AwardDescription" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="AwardDetail" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="AwardPublishDate" Type="DateTime" Precision="3" /> <Property Name="Tags" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="CreatedBy" Type="Int32" /> <Property Name="CreatedDate" Type="DateTime" Precision="3" /> <Property Name="UpdatedBy" Type="Int32" /> <Property Name="UpdatedDate" Type="DateTime" Precision="3" /> <Property Name="Remarks" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="Gallery"> <Key> <PropertyRef Name="GalleryID" /> </Key> <Property Name="GalleryID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="AlbumID" Type="Int32" /> <Property Name="ImageURL" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="ImageCaption" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <NavigationProperty Name="GalleryAlbum" Relationship="dbHRDCModel.FK_Gallery_GalleryAlbum" FromRole="Gallery" ToRole="GalleryAlbum" /> </EntityType> <EntityType Name="MainBanner"> <Key> <PropertyRef Name="MainBannerID" /> </Key> <Property Name="MainBannerID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="BannerTitle" Type="String" MaxLength="100" FixedLength="false" Unicode="true" /> <Property Name="BannerImage" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="BannerDescription" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="BannerDetail" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="BannerPublishDate" Type="DateTime" Precision="3" /> <Property Name="CreatedBy" Type="Int32" /> <Property Name="CreatedDate" Type="DateTime" Precision="3" /> <Property Name="UpdatedBy" Type="Int32" /> <Property Name="UpdatedDate" Type="DateTime" Precision="3" /> <Property Name="Tags" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="Remarks" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="OtherContent"> <Key> <PropertyRef Name="ContentID" /> </Key> <Property Name="ContentID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="ContentTitle" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="ContentImage" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="ContentDescription" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="ContentDetail" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="ContentPublishDate" Type="DateTime" Precision="3" /> <Property Name="CreatedBy" Type="Int32" /> <Property Name="CreatedDate" Type="DateTime" Precision="3" /> <Property Name="UpdatedBy" Type="Int32" /> <Property Name="UpdatedDate" Type="DateTime" Precision="3" /> <Property Name="Tags" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="Remarks" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="OurProgram"> <Key> <PropertyRef Name="ProgramID" /> </Key> <Property Name="ProgramID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="ProgramTitle" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="ProgramImage" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="ProgramDescription" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="ProgramDetail" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="ProgramPublishDate" Type="DateTime" Precision="3" /> <Property Name="CreatedBy" Type="Int32" /> <Property Name="CreatedDate" Type="DateTime" Precision="3" /> <Property Name="UpdatedBy" Type="Int32" /> <Property Name="UpdatedDate" Type="DateTime" Precision="3" /> <Property Name="Tags" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="Remarks" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="SuccessStory"> <Key> <PropertyRef Name="SuccessStoryID" /> </Key> <Property Name="SuccessStoryID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="SuccessStoryTitle" Type="String" MaxLength="100" FixedLength="false" Unicode="true" /> <Property Name="SuccessStoryImage" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="SuccessStoryDescription" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="SuccessStoryDetail" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="SuccessStoryPublishDate" Type="DateTime" Precision="3" /> <Property Name="Tags" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="CreatedBy" Type="Int32" /> <Property Name="CreatedDate" Type="DateTime" Precision="3" /> <Property Name="UpdatedBy" Type="Int32" /> <Property Name="UpdatedDate" Type="DateTime" Precision="3" /> <Property Name="Remarks" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="sysdiagram"> <Key> <PropertyRef Name="diagram_id" /> </Key> <Property Name="name" Type="String" Nullable="false" MaxLength="128" FixedLength="false" Unicode="true" /> <Property Name="principal_id" Type="Int32" Nullable="false" /> <Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="version" Type="Int32" /> <Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" /> </EntityType> <EntityType Name="Team"> <Key> <PropertyRef Name="TeamID" /> </Key> <Property Name="TeamID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="TeamTitle" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> <Property Name="TeamImage" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="TeamDescription" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="TeamDetail" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="TeamPublishDate" Type="DateTime" Precision="3" /> <Property Name="CreatedBy" Type="Int32" /> <Property Name="CreatedDate" Type="DateTime" Precision="3" /> <Property Name="UpdatedBy" Type="Int32" /> <Property Name="UpdatedDate" Type="DateTime" Precision="3" /> <Property Name="Tags" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="Remarks" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="Video"> <Key> <PropertyRef Name="VideoID" /> </Key> <Property Name="VideoID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="VideoURL" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="VideoCaption" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="VideoPublishDate" Type="DateTime" Precision="3" /> <Property Name="CreatedBy" Type="Int32" /> <Property Name="CreatedDate" Type="DateTime" Precision="3" /> <Property Name="UpdatedBy" Type="Int32" /> <Property Name="UpdatedDate" Type="DateTime" Precision="3" /> <Property Name="Tags" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="Remarks" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="EarthquakeResponse"> <Key> <PropertyRef Name="EarthquakeResponseID" /> </Key> <Property Name="EarthquakeResponseID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="ResponseTitle" Type="String" MaxLength="100" FixedLength="false" Unicode="true" /> <Property Name="ResponseImage" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="ResponseDescription" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="ResponseDetail" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" /> <Property Name="ResponsePublishDate" Type="DateTime" Precision="3" /> <Property Name="CreatedBy" Type="Int32" /> <Property Name="CreatedDate" Type="DateTime" Precision="3" /> <Property Name="UpdatedBy" Type="Int32" /> <Property Name="UpdatedDate" Type="DateTime" Precision="3" /> <Property Name="Tags" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="Remarks" Type="String" MaxLength="200" FixedLength="false" Unicode="true" /> </EntityType> <EntityType Name="GalleryAlbum"> <Key> <PropertyRef Name="AlbumID" /> </Key> <Property Name="AlbumID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="AlbumName" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="AlbumDescription" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="AlbumPublishDate" Type="DateTime" Precision="3" /> <Property Name="AlbumImageURL" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="CreatedBy" Type="Int32" /> <Property Name="CreatedDate" Type="DateTime" Precision="3" /> <Property Name="UpdatedBy" Type="Int32" /> <Property Name="UpdatedDate" Type="DateTime" Precision="3" /> <Property Name="Tags" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <NavigationProperty Name="Galleries" Relationship="dbHRDCModel.FK_Gallery_GalleryAlbum" FromRole="GalleryAlbum" ToRole="Gallery" /> </EntityType> <Association Name="FK_Gallery_GalleryAlbum"> <End Type="dbHRDCModel.GalleryAlbum" Role="GalleryAlbum" Multiplicity="0..1" /> <End Type="dbHRDCModel.Gallery" Role="Gallery" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="GalleryAlbum"> <PropertyRef Name="AlbumID" /> </Principal> <Dependent Role="Gallery"> <PropertyRef Name="AlbumID" /> </Dependent> </ReferentialConstraint> </Association> <EntityType Name="TagLink"> <Key> <PropertyRef Name="TagLinkID" /> </Key> <Property Name="TagLinkID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="TagID" Type="Int32" /> <Property Name="URL" Type="String" MaxLength="500" FixedLength="false" Unicode="false" /> <NavigationProperty Name="Tag" Relationship="dbHRDCModel.FK_TagLinks_Tags" FromRole="TagLink" ToRole="Tag" /> <Property Name="Title" Type="String" MaxLength="100" FixedLength="false" Unicode="false" /> <Property Name="Type" Type="String" MaxLength="50" FixedLength="false" Unicode="false" /> <Property Name="TypeID" Type="Int32" /> </EntityType> <EntityType Name="Tag"> <Key> <PropertyRef Name="TagID" /> </Key> <Property Name="TagID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> <Property Name="TagName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" /> <Property Name="Remarks" Type="String" MaxLength="500" FixedLength="false" Unicode="false" /> <NavigationProperty Name="TagLinks" Relationship="dbHRDCModel.FK_TagLinks_Tags" FromRole="Tag" ToRole="TagLink" /> </EntityType> <Association Name="FK_TagLinks_Tags"> <End Type="dbHRDCModel.Tag" Role="Tag" Multiplicity="0..1" /> <End Type="dbHRDCModel.TagLink" Role="TagLink" Multiplicity="*" /> <ReferentialConstraint> <Principal Role="Tag"> <PropertyRef Name="TagID" /> </Principal> <Dependent Role="TagLink"> <PropertyRef Name="TagID" /> </Dependent> </ReferentialConstraint> </Association> </Schema> </edmx:ConceptualModels> <!-- C-S mapping content --> <edmx:Mappings> <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs"> <EntityContainerMapping StorageEntityContainer="dbHRDCModelStoreContainer" CdmEntityContainer="dbHRDCEntities"> <EntitySetMapping Name="C__MigrationHistory"> <EntityTypeMapping TypeName="dbHRDCModel.C__MigrationHistory"> <MappingFragment StoreEntitySet="__MigrationHistory"> <ScalarProperty Name="ProductVersion" ColumnName="ProductVersion" /> <ScalarProperty Name="Model" ColumnName="Model" /> <ScalarProperty Name="ContextKey" ColumnName="ContextKey" /> <ScalarProperty Name="MigrationId" ColumnName="MigrationId" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="AspNetRoles"> <EntityTypeMapping TypeName="dbHRDCModel.AspNetRole"> <MappingFragment StoreEntitySet="AspNetRoles"> <ScalarProperty Name="Name" ColumnName="Name" /> <ScalarProperty Name="Id" ColumnName="Id" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="AspNetUserClaims"> <EntityTypeMapping TypeName="dbHRDCModel.AspNetUserClaim"> <MappingFragment StoreEntitySet="AspNetUserClaims"> <ScalarProperty Name="ClaimValue" ColumnName="ClaimValue" /> <ScalarProperty Name="ClaimType" ColumnName="ClaimType" /> <ScalarProperty Name="UserId" ColumnName="UserId" /> <ScalarProperty Name="Id" ColumnName="Id" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="AspNetUserLogins"> <EntityTypeMapping TypeName="dbHRDCModel.AspNetUserLogin"> <MappingFragment StoreEntitySet="AspNetUserLogins"> <ScalarProperty Name="UserId" ColumnName="UserId" /> <ScalarProperty Name="ProviderKey" ColumnName="ProviderKey" /> <ScalarProperty Name="LoginProvider" ColumnName="LoginProvider" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="AspNetUsers"> <EntityTypeMapping TypeName="dbHRDCModel.AspNetUser"> <MappingFragment StoreEntitySet="AspNetUsers"> <ScalarProperty Name="UserName" ColumnName="UserName" /> <ScalarProperty Name="AccessFailedCount" ColumnName="AccessFailedCount" /> <ScalarProperty Name="LockoutEnabled" ColumnName="LockoutEnabled" /> <ScalarProperty Name="LockoutEndDateUtc" ColumnName="LockoutEndDateUtc" /> <ScalarProperty Name="TwoFactorEnabled" ColumnName="TwoFactorEnabled" /> <ScalarProperty Name="PhoneNumberConfirmed" ColumnName="PhoneNumberConfirmed" /> <ScalarProperty Name="PhoneNumber" ColumnName="PhoneNumber" /> <ScalarProperty Name="SecurityStamp" ColumnName="SecurityStamp" /> <ScalarProperty Name="PasswordHash" ColumnName="PasswordHash" /> <ScalarProperty Name="EmailConfirmed" ColumnName="EmailConfirmed" /> <ScalarProperty Name="Email" ColumnName="Email" /> <ScalarProperty Name="Id" ColumnName="Id" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <AssociationSetMapping Name="AspNetUserRoles" TypeName="dbHRDCModel.AspNetUserRoles" StoreEntitySet="AspNetUserRoles"> <EndProperty Name="AspNetUser"> <ScalarProperty Name="Id" ColumnName="UserId" /> </EndProperty> <EndProperty Name="AspNetRole"> <ScalarProperty Name="Id" ColumnName="RoleId" /> </EndProperty> </AssociationSetMapping> <EntitySetMapping Name="Awards"> <EntityTypeMapping TypeName="dbHRDCModel.Award"> <MappingFragment StoreEntitySet="Award"> <ScalarProperty Name="Remarks" ColumnName="Remarks" /> <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" /> <ScalarProperty Name="UpdatedBy" ColumnName="UpdatedBy" /> <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" /> <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" /> <ScalarProperty Name="Tags" ColumnName="Tags" /> <ScalarProperty Name="AwardPublishDate" ColumnName="AwardPublishDate" /> <ScalarProperty Name="AwardDetail" ColumnName="AwardDetail" /> <ScalarProperty Name="AwardDescription" ColumnName="AwardDescription" /> <ScalarProperty Name="AwardImage" ColumnName="AwardImage" /> <ScalarProperty Name="AwardTitle" ColumnName="AwardTitle" /> <ScalarProperty Name="AwardID" ColumnName="AwardID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="Galleries"> <EntityTypeMapping TypeName="dbHRDCModel.Gallery"> <MappingFragment StoreEntitySet="Gallery"> <ScalarProperty Name="ImageCaption" ColumnName="ImageCaption" /> <ScalarProperty Name="ImageURL" ColumnName="ImageURL" /> <ScalarProperty Name="AlbumID" ColumnName="AlbumID" /> <ScalarProperty Name="GalleryID" ColumnName="GalleryID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="MainBanners"> <EntityTypeMapping TypeName="dbHRDCModel.MainBanner"> <MappingFragment StoreEntitySet="MainBanner"> <ScalarProperty Name="Remarks" ColumnName="Remarks" /> <ScalarProperty Name="Tags" ColumnName="Tags" /> <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" /> <ScalarProperty Name="UpdatedBy" ColumnName="UpdatedBy" /> <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" /> <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" /> <ScalarProperty Name="BannerPublishDate" ColumnName="BannerPublishDate" /> <ScalarProperty Name="BannerDetail" ColumnName="BannerDetail" /> <ScalarProperty Name="BannerDescription" ColumnName="BannerDescription" /> <ScalarProperty Name="BannerImage" ColumnName="BannerImage" /> <ScalarProperty Name="BannerTitle" ColumnName="BannerTitle" /> <ScalarProperty Name="MainBannerID" ColumnName="MainBannerID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="OtherContents"> <EntityTypeMapping TypeName="dbHRDCModel.OtherContent"> <MappingFragment StoreEntitySet="OtherContent"> <ScalarProperty Name="Remarks" ColumnName="Remarks" /> <ScalarProperty Name="Tags" ColumnName="Tags" /> <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" /> <ScalarProperty Name="UpdatedBy" ColumnName="UpdatedBy" /> <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" /> <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" /> <ScalarProperty Name="ContentPublishDate" ColumnName="ContentPublishDate" /> <ScalarProperty Name="ContentDetail" ColumnName="ContentDetail" /> <ScalarProperty Name="ContentDescription" ColumnName="ContentDescription" /> <ScalarProperty Name="ContentImage" ColumnName="ContentImage" /> <ScalarProperty Name="ContentTitle" ColumnName="ContentTitle" /> <ScalarProperty Name="ContentID" ColumnName="ContentID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="OurPrograms"> <EntityTypeMapping TypeName="dbHRDCModel.OurProgram"> <MappingFragment StoreEntitySet="OurPrograms"> <ScalarProperty Name="Remarks" ColumnName="Remarks" /> <ScalarProperty Name="Tags" ColumnName="Tags" /> <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" /> <ScalarProperty Name="UpdatedBy" ColumnName="UpdatedBy" /> <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" /> <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" /> <ScalarProperty Name="ProgramPublishDate" ColumnName="ProgramPublishDate" /> <ScalarProperty Name="ProgramDetail" ColumnName="ProgramDetail" /> <ScalarProperty Name="ProgramDescription" ColumnName="ProgramDescription" /> <ScalarProperty Name="ProgramImage" ColumnName="ProgramImage" /> <ScalarProperty Name="ProgramTitle" ColumnName="ProgramTitle" /> <ScalarProperty Name="ProgramID" ColumnName="ProgramID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="SuccessStories"> <EntityTypeMapping TypeName="dbHRDCModel.SuccessStory"> <MappingFragment StoreEntitySet="SuccessStories"> <ScalarProperty Name="Remarks" ColumnName="Remarks" /> <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" /> <ScalarProperty Name="UpdatedBy" ColumnName="UpdatedBy" /> <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" /> <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" /> <ScalarProperty Name="Tags" ColumnName="Tags" /> <ScalarProperty Name="SuccessStoryPublishDate" ColumnName="SuccessStoryPublishDate" /> <ScalarProperty Name="SuccessStoryDetail" ColumnName="SuccessStoryDetail" /> <ScalarProperty Name="SuccessStoryDescription" ColumnName="SuccessStoryDescription" /> <ScalarProperty Name="SuccessStoryImage" ColumnName="SuccessStoryImage" /> <ScalarProperty Name="SuccessStoryTitle" ColumnName="SuccessStoryTitle" /> <ScalarProperty Name="SuccessStoryID" ColumnName="SuccessStoryID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="sysdiagrams"> <EntityTypeMapping TypeName="dbHRDCModel.sysdiagram"> <MappingFragment StoreEntitySet="sysdiagrams"> <ScalarProperty Name="definition" ColumnName="definition" /> <ScalarProperty Name="version" ColumnName="version" /> <ScalarProperty Name="diagram_id" ColumnName="diagram_id" /> <ScalarProperty Name="principal_id" ColumnName="principal_id" /> <ScalarProperty Name="name" ColumnName="name" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="Teams"> <EntityTypeMapping TypeName="dbHRDCModel.Team"> <MappingFragment StoreEntitySet="Team"> <ScalarProperty Name="Remarks" ColumnName="Remarks" /> <ScalarProperty Name="Tags" ColumnName="Tags" /> <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" /> <ScalarProperty Name="UpdatedBy" ColumnName="UpdatedBy" /> <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" /> <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" /> <ScalarProperty Name="TeamPublishDate" ColumnName="TeamPublishDate" /> <ScalarProperty Name="TeamDetail" ColumnName="TeamDetail" /> <ScalarProperty Name="TeamDescription" ColumnName="TeamDescription" /> <ScalarProperty Name="TeamImage" ColumnName="TeamImage" /> <ScalarProperty Name="TeamTitle" ColumnName="TeamTitle" /> <ScalarProperty Name="TeamID" ColumnName="TeamID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="Videos"> <EntityTypeMapping TypeName="dbHRDCModel.Video"> <MappingFragment StoreEntitySet="Video"> <ScalarProperty Name="Remarks" ColumnName="Remarks" /> <ScalarProperty Name="Tags" ColumnName="Tags" /> <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" /> <ScalarProperty Name="UpdatedBy" ColumnName="UpdatedBy" /> <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" /> <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" /> <ScalarProperty Name="VideoPublishDate" ColumnName="VideoPublishDate" /> <ScalarProperty Name="VideoCaption" ColumnName="VideoCaption" /> <ScalarProperty Name="VideoURL" ColumnName="VideoURL" /> <ScalarProperty Name="VideoID" ColumnName="VideoID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="EarthquakeResponses"> <EntityTypeMapping TypeName="dbHRDCModel.EarthquakeResponse"> <MappingFragment StoreEntitySet="EarthquakeResponse"> <ScalarProperty Name="Remarks" ColumnName="Remarks" /> <ScalarProperty Name="Tags" ColumnName="Tags" /> <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" /> <ScalarProperty Name="UpdatedBy" ColumnName="UpdatedBy" /> <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" /> <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" /> <ScalarProperty Name="ResponsePublishDate" ColumnName="ResponsePublishDate" /> <ScalarProperty Name="ResponseDetail" ColumnName="ResponseDetail" /> <ScalarProperty Name="ResponseDescription" ColumnName="ResponseDescription" /> <ScalarProperty Name="ResponseImage" ColumnName="ResponseImage" /> <ScalarProperty Name="ResponseTitle" ColumnName="ResponseTitle" /> <ScalarProperty Name="EarthquakeResponseID" ColumnName="EarthquakeResponseID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="GalleryAlbums"> <EntityTypeMapping TypeName="dbHRDCModel.GalleryAlbum"> <MappingFragment StoreEntitySet="GalleryAlbum"> <ScalarProperty Name="Tags" ColumnName="Tags" /> <ScalarProperty Name="UpdatedDate" ColumnName="UpdatedDate" /> <ScalarProperty Name="UpdatedBy" ColumnName="UpdatedBy" /> <ScalarProperty Name="CreatedDate" ColumnName="CreatedDate" /> <ScalarProperty Name="CreatedBy" ColumnName="CreatedBy" /> <ScalarProperty Name="AlbumImageURL" ColumnName="AlbumImageURL" /> <ScalarProperty Name="AlbumPublishDate" ColumnName="AlbumPublishDate" /> <ScalarProperty Name="AlbumDescription" ColumnName="AlbumDescription" /> <ScalarProperty Name="AlbumName" ColumnName="AlbumName" /> <ScalarProperty Name="AlbumID" ColumnName="AlbumID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="TagLinks"> <EntityTypeMapping TypeName="dbHRDCModel.TagLink"> <MappingFragment StoreEntitySet="TagLinks"> <ScalarProperty Name="TypeID" ColumnName="TypeID" /> <ScalarProperty Name="Type" ColumnName="Type" /> <ScalarProperty Name="Title" ColumnName="Title" /> <ScalarProperty Name="URL" ColumnName="URL" /> <ScalarProperty Name="TagID" ColumnName="TagID" /> <ScalarProperty Name="TagLinkID" ColumnName="TagLinkID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> <EntitySetMapping Name="Tags"> <EntityTypeMapping TypeName="dbHRDCModel.Tag"> <MappingFragment StoreEntitySet="Tags"> <ScalarProperty Name="Remarks" ColumnName="Remarks" /> <ScalarProperty Name="TagName" ColumnName="TagName" /> <ScalarProperty Name="TagID" ColumnName="TagID" /> </MappingFragment> </EntityTypeMapping> </EntitySetMapping> </EntityContainerMapping> </Mapping> </edmx:Mappings> </edmx:Runtime> <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) --> <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx"> <Connection> <DesignerInfoPropertySet> <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" /> </DesignerInfoPropertySet> </Connection> <Options> <DesignerInfoPropertySet> <DesignerProperty Name="ValidateOnBuild" Value="true" /> <DesignerProperty Name="EnablePluralization" Value="true" /> <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" /> <DesignerProperty Name="UseLegacyProvider" Value="false" /> <DesignerProperty Name="CodeGenerationStrategy" Value="None" /> </DesignerInfoPropertySet> </Options> <!-- Diagram content (shape and connector positions) --> <Diagrams></Diagrams> </Designer> </edmx:Edmx>