Projects/Models/Model.edmx

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
   3   <!-- EF Runtime content -->
   4   <edmx:Runtime>
   5     <!-- SSDL content -->
   6     <edmx:StorageModels>
   7       <Schema Namespace="ProjectsDBModel.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">
   8         <EntityType Name="Projects">
   9           <Key>
  10             <PropertyRef Name="id" />
  11           </Key>
  12           <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  13           <Property Name="user_id" Type="int" />
  14           <Property Name="name" Type="nvarchar" MaxLength="50" />
  15           <Property Name="description" Type="text" />
  16           <Property Name="created_at" Type="datetime2" Precision="7" />
  17           <Property Name="updated_at" Type="datetime2" Precision="7" />
  18         </EntityType>
  19         <EntityType Name="ProjectTasks">
  20           <Key>
  21             <PropertyRef Name="id" />
  22           </Key>
  23           <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  24           <Property Name="project_id" Type="int" Nullable="false" />
  25           <Property Name="name" Type="nvarchar" MaxLength="50" Nullable="false" />
  26           <Property Name="description" Type="nvarchar(max)" />
  27           <Property Name="created_at" Type="datetime2" Precision="7" />
  28           <Property Name="updated_at" Type="datetime2" Precision="7" />
  29           <Property Name="task_status_id" Type="int" />
  30           <Property Name="user_id" Type="int" />
  31         </EntityType>
  32         <EntityType Name="sysdiagrams">
  33           <Key>
  34             <PropertyRef Name="diagram_id" />
  35           </Key>
  36           <Property Name="name" Type="nvarchar" MaxLength="128" Nullable="false" />
  37           <Property Name="principal_id" Type="int" Nullable="false" />
  38           <Property Name="diagram_id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  39           <Property Name="version" Type="int" />
  40           <Property Name="definition" Type="varbinary(max)" />
  41         </EntityType>
  42         <EntityType Name="TaskStatuses">
  43           <Key>
  44             <PropertyRef Name="id" />
  45           </Key>
  46           <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  47           <Property Name="status" Type="nvarchar" MaxLength="50" />
  48         </EntityType>
  49         <EntityType Name="UserRoles">
  50           <Key>
  51             <PropertyRef Name="id" />
  52           </Key>
  53           <Property Name="id" Type="int" Nullable="false" />
  54           <Property Name="role" Type="nchar" MaxLength="10" Nullable="false" />
  55         </EntityType>
  56         <EntityType Name="Users">
  57           <Key>
  58             <PropertyRef Name="id" />
  59           </Key>
  60           <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  61           <Property Name="login" Type="nvarchar" MaxLength="50" Nullable="false" />
  62           <Property Name="password" Type="nvarchar" MaxLength="50" Nullable="false" />
  63           <Property Name="role_id" Type="int" Nullable="false" />
  64         </EntityType>
  65         <Association Name="FK_Projects_Users">
  66           <End Role="Users" Type="Self.Users" Multiplicity="0..1" />
  67           <End Role="Projects" Type="Self.Projects" Multiplicity="*" />
  68           <ReferentialConstraint>
  69             <Principal Role="Users">
  70               <PropertyRef Name="id" />
  71             </Principal>
  72             <Dependent Role="Projects">
  73               <PropertyRef Name="user_id" />
  74             </Dependent>
  75           </ReferentialConstraint>
  76         </Association>
  77         <Association Name="FK_Tasks_Projects">
  78           <End Role="Projects" Type="Self.Projects" Multiplicity="1" />
  79           <End Role="ProjectTasks" Type="Self.ProjectTasks" Multiplicity="*" />
  80           <ReferentialConstraint>
  81             <Principal Role="Projects">
  82               <PropertyRef Name="id" />
  83             </Principal>
  84             <Dependent Role="ProjectTasks">
  85               <PropertyRef Name="project_id" />
  86             </Dependent>
  87           </ReferentialConstraint>
  88         </Association>
  89         <Association Name="FK_Tasks_TaskStatuses">
  90           <End Role="TaskStatuses" Type="Self.TaskStatuses" Multiplicity="0..1" />
  91           <End Role="ProjectTasks" Type="Self.ProjectTasks" Multiplicity="*" />
  92           <ReferentialConstraint>
  93             <Principal Role="TaskStatuses">
  94               <PropertyRef Name="id" />
  95             </Principal>
  96             <Dependent Role="ProjectTasks">
  97               <PropertyRef Name="task_status_id" />
  98             </Dependent>
  99           </ReferentialConstraint>
 100         </Association>
 101         <Association Name="FK_Tasks_Users">
 102           <End Role="Users" Type="Self.Users" Multiplicity="0..1" />
 103           <End Role="ProjectTasks" Type="Self.ProjectTasks" Multiplicity="*" />
 104           <ReferentialConstraint>
 105             <Principal Role="Users">
 106               <PropertyRef Name="id" />
 107             </Principal>
 108             <Dependent Role="ProjectTasks">
 109               <PropertyRef Name="user_id" />
 110             </Dependent>
 111           </ReferentialConstraint>
 112         </Association>
 113         <Association Name="FK_Users_UserRoles">
 114           <End Role="UserRoles" Type="Self.UserRoles" Multiplicity="1" />
 115           <End Role="Users" Type="Self.Users" Multiplicity="*" />
 116           <ReferentialConstraint>
 117             <Principal Role="UserRoles">
 118               <PropertyRef Name="id" />
 119             </Principal>
 120             <Dependent Role="Users">
 121               <PropertyRef Name="role_id" />
 122             </Dependent>
 123           </ReferentialConstraint>
 124         </Association>
 125         <EntityContainer Name="ProjectsDBModelStoreContainer">
 126           <EntitySet Name="Projects" EntityType="Self.Projects" Schema="dbo" store:Type="Tables" />
 127           <EntitySet Name="ProjectTasks" EntityType="Self.ProjectTasks" Schema="dbo" store:Type="Tables" />
 128           <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" />
 129           <EntitySet Name="TaskStatuses" EntityType="Self.TaskStatuses" Schema="dbo" store:Type="Tables" />
 130           <EntitySet Name="UserRoles" EntityType="Self.UserRoles" Schema="dbo" store:Type="Tables" />
 131           <EntitySet Name="Users" EntityType="Self.Users" Schema="dbo" store:Type="Tables" />
 132           <AssociationSet Name="FK_Projects_Users" Association="Self.FK_Projects_Users">
 133             <End Role="Users" EntitySet="Users" />
 134             <End Role="Projects" EntitySet="Projects" />
 135           </AssociationSet>
 136           <AssociationSet Name="FK_Tasks_Projects" Association="Self.FK_Tasks_Projects">
 137             <End Role="Projects" EntitySet="Projects" />
 138             <End Role="ProjectTasks" EntitySet="ProjectTasks" />
 139           </AssociationSet>
 140           <AssociationSet Name="FK_Tasks_TaskStatuses" Association="Self.FK_Tasks_TaskStatuses">
 141             <End Role="TaskStatuses" EntitySet="TaskStatuses" />
 142             <End Role="ProjectTasks" EntitySet="ProjectTasks" />
 143           </AssociationSet>
 144           <AssociationSet Name="FK_Tasks_Users" Association="Self.FK_Tasks_Users">
 145             <End Role="Users" EntitySet="Users" />
 146             <End Role="ProjectTasks" EntitySet="ProjectTasks" />
 147           </AssociationSet>
 148           <AssociationSet Name="FK_Users_UserRoles" Association="Self.FK_Users_UserRoles">
 149             <End Role="UserRoles" EntitySet="UserRoles" />
 150             <End Role="Users" EntitySet="Users" />
 151           </AssociationSet>
 152         </EntityContainer>
 153       </Schema>
 154     </edmx:StorageModels>
 155     <!-- CSDL content -->
 156     <edmx:ConceptualModels>
 157       <Schema Namespace="ProjectsDBModel" 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">
 158         <EntityType Name="Project">
 159           <Key>
 160             <PropertyRef Name="id" />
 161           </Key>
 162           <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
 163           <Property Name="user_id" Type="Int32" />
 164           <Property Name="name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
 165           <Property Name="description" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
 166           <Property Name="created_at" Type="DateTime" Precision="7" />
 167           <Property Name="updated_at" Type="DateTime" Precision="7" />
 168           <NavigationProperty Name="User" Relationship="Self.FK_Projects_Users" FromRole="Projects" ToRole="Users" />
 169           <NavigationProperty Name="ProjectTasks" Relationship="Self.FK_Tasks_Projects" FromRole="Projects" ToRole="ProjectTasks" />
 170         </EntityType>
 171         <EntityType Name="ProjectTask">
 172           <Key>
 173             <PropertyRef Name="id" />
 174           </Key>
 175           <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
 176           <Property Name="project_id" Type="Int32" Nullable="false" />
 177           <Property Name="name" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
 178           <Property Name="description" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
 179           <Property Name="created_at" Type="DateTime" Precision="7" />
 180           <Property Name="updated_at" Type="DateTime" Precision="7" />
 181           <Property Name="task_status_id" Type="Int32" />
 182           <Property Name="user_id" Type="Int32" />
 183           <NavigationProperty Name="Project" Relationship="Self.FK_Tasks_Projects" FromRole="ProjectTasks" ToRole="Projects" />
 184           <NavigationProperty Name="TaskStatus" Relationship="Self.FK_Tasks_TaskStatuses" FromRole="ProjectTasks" ToRole="TaskStatuses" />
 185           <NavigationProperty Name="User" Relationship="Self.FK_Tasks_Users" FromRole="ProjectTasks" ToRole="Users" />
 186         </EntityType>
 187         <EntityType Name="sysdiagram">
 188           <Key>
 189             <PropertyRef Name="diagram_id" />
 190           </Key>
 191           <Property Name="name" Type="String" MaxLength="128" FixedLength="false" Unicode="true" Nullable="false" />
 192           <Property Name="principal_id" Type="Int32" Nullable="false" />
 193           <Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
 194           <Property Name="version" Type="Int32" />
 195           <Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" />
 196         </EntityType>
 197         <EntityType Name="TaskStatus">
 198           <Key>
 199             <PropertyRef Name="id" />
 200           </Key>
 201           <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
 202           <Property Name="status" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
 203           <NavigationProperty Name="ProjectTasks" Relationship="Self.FK_Tasks_TaskStatuses" FromRole="TaskStatuses" ToRole="ProjectTasks" />
 204         </EntityType>
 205         <EntityType Name="UserRole">
 206           <Key>
 207             <PropertyRef Name="id" />
 208           </Key>
 209           <Property Name="id" Type="Int32" Nullable="false" />
 210           <Property Name="role" Type="String" MaxLength="10" FixedLength="true" Unicode="true" Nullable="false" />
 211           <NavigationProperty Name="Users" Relationship="Self.FK_Users_UserRoles" FromRole="UserRoles" ToRole="Users" />
 212         </EntityType>
 213         <EntityType Name="User">
 214           <Key>
 215             <PropertyRef Name="id" />
 216           </Key>
 217           <Property Name="id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
 218           <Property Name="login" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
 219           <Property Name="password" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
 220           <Property Name="role_id" Type="Int32" Nullable="false" />
 221           <NavigationProperty Name="Projects" Relationship="Self.FK_Projects_Users" FromRole="Users" ToRole="Projects" />
 222           <NavigationProperty Name="ProjectTasks" Relationship="Self.FK_Tasks_Users" FromRole="Users" ToRole="ProjectTasks" />
 223           <NavigationProperty Name="UserRole" Relationship="Self.FK_Users_UserRoles" FromRole="Users" ToRole="UserRoles" />
 224         </EntityType>
 225         <Association Name="FK_Projects_Users">
 226           <End Role="Users" Type="Self.User" Multiplicity="0..1" />
 227           <End Role="Projects" Type="Self.Project" Multiplicity="*" />
 228           <ReferentialConstraint>
 229             <Principal Role="Users">
 230               <PropertyRef Name="id" />
 231             </Principal>
 232             <Dependent Role="Projects">
 233               <PropertyRef Name="user_id" />
 234             </Dependent>
 235           </ReferentialConstraint>
 236         </Association>
 237         <Association Name="FK_Tasks_Projects">
 238           <End Role="Projects" Type="Self.Project" Multiplicity="1" />
 239           <End Role="ProjectTasks" Type="Self.ProjectTask" Multiplicity="*" />
 240           <ReferentialConstraint>
 241             <Principal Role="Projects">
 242               <PropertyRef Name="id" />
 243             </Principal>
 244             <Dependent Role="ProjectTasks">
 245               <PropertyRef Name="project_id" />
 246             </Dependent>
 247           </ReferentialConstraint>
 248         </Association>
 249         <Association Name="FK_Tasks_TaskStatuses">
 250           <End Role="TaskStatuses" Type="Self.TaskStatus" Multiplicity="0..1" />
 251           <End Role="ProjectTasks" Type="Self.ProjectTask" Multiplicity="*" />
 252           <ReferentialConstraint>
 253             <Principal Role="TaskStatuses">
 254               <PropertyRef Name="id" />
 255             </Principal>
 256             <Dependent Role="ProjectTasks">
 257               <PropertyRef Name="task_status_id" />
 258             </Dependent>
 259           </ReferentialConstraint>
 260         </Association>
 261         <Association Name="FK_Tasks_Users">
 262           <End Role="Users" Type="Self.User" Multiplicity="0..1" />
 263           <End Role="ProjectTasks" Type="Self.ProjectTask" Multiplicity="*" />
 264           <ReferentialConstraint>
 265             <Principal Role="Users">
 266               <PropertyRef Name="id" />
 267             </Principal>
 268             <Dependent Role="ProjectTasks">
 269               <PropertyRef Name="user_id" />
 270             </Dependent>
 271           </ReferentialConstraint>
 272         </Association>
 273         <Association Name="FK_Users_UserRoles">
 274           <End Role="UserRoles" Type="Self.UserRole" Multiplicity="1" />
 275           <End Role="Users" Type="Self.User" Multiplicity="*" />
 276           <ReferentialConstraint>
 277             <Principal Role="UserRoles">
 278               <PropertyRef Name="id" />
 279             </Principal>
 280             <Dependent Role="Users">
 281               <PropertyRef Name="role_id" />
 282             </Dependent>
 283           </ReferentialConstraint>
 284         </Association>
 285         <EntityContainer Name="ProjectsDBEntities" annotation:LazyLoadingEnabled="true">
 286           <EntitySet Name="Projects" EntityType="Self.Project" />
 287           <EntitySet Name="ProjectTasks" EntityType="Self.ProjectTask" />
 288           <EntitySet Name="sysdiagrams" EntityType="Self.sysdiagram" />
 289           <EntitySet Name="TaskStatuses" EntityType="Self.TaskStatus" />
 290           <EntitySet Name="UserRoles" EntityType="Self.UserRole" />
 291           <EntitySet Name="Users" EntityType="Self.User" />
 292           <AssociationSet Name="FK_Projects_Users" Association="Self.FK_Projects_Users">
 293             <End Role="Users" EntitySet="Users" />
 294             <End Role="Projects" EntitySet="Projects" />
 295           </AssociationSet>
 296           <AssociationSet Name="FK_Tasks_Projects" Association="Self.FK_Tasks_Projects">
 297             <End Role="Projects" EntitySet="Projects" />
 298             <End Role="ProjectTasks" EntitySet="ProjectTasks" />
 299           </AssociationSet>
 300           <AssociationSet Name="FK_Tasks_TaskStatuses" Association="Self.FK_Tasks_TaskStatuses">
 301             <End Role="TaskStatuses" EntitySet="TaskStatuses" />
 302             <End Role="ProjectTasks" EntitySet="ProjectTasks" />
 303           </AssociationSet>
 304           <AssociationSet Name="FK_Tasks_Users" Association="Self.FK_Tasks_Users">
 305             <End Role="Users" EntitySet="Users" />
 306             <End Role="ProjectTasks" EntitySet="ProjectTasks" />
 307           </AssociationSet>
 308           <AssociationSet Name="FK_Users_UserRoles" Association="Self.FK_Users_UserRoles">
 309             <End Role="UserRoles" EntitySet="UserRoles" />
 310             <End Role="Users" EntitySet="Users" />
 311           </AssociationSet>
 312         </EntityContainer>
 313       </Schema>
 314     </edmx:ConceptualModels>
 315     <!-- C-S mapping content -->
 316     <edmx:Mappings>
 317       <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
 318         <EntityContainerMapping StorageEntityContainer="ProjectsDBModelStoreContainer" CdmEntityContainer="ProjectsDBEntities">
 319           <EntitySetMapping Name="Projects">
 320             <EntityTypeMapping TypeName="ProjectsDBModel.Project">
 321               <MappingFragment StoreEntitySet="Projects">
 322                 <ScalarProperty Name="id" ColumnName="id" />
 323                 <ScalarProperty Name="user_id" ColumnName="user_id" />
 324                 <ScalarProperty Name="name" ColumnName="name" />
 325                 <ScalarProperty Name="description" ColumnName="description" />
 326                 <ScalarProperty Name="created_at" ColumnName="created_at" />
 327                 <ScalarProperty Name="updated_at" ColumnName="updated_at" />
 328               </MappingFragment>
 329             </EntityTypeMapping>
 330           </EntitySetMapping>
 331           <EntitySetMapping Name="ProjectTasks">
 332             <EntityTypeMapping TypeName="ProjectsDBModel.ProjectTask">
 333               <MappingFragment StoreEntitySet="ProjectTasks">
 334                 <ScalarProperty Name="id" ColumnName="id" />
 335                 <ScalarProperty Name="project_id" ColumnName="project_id" />
 336                 <ScalarProperty Name="name" ColumnName="name" />
 337                 <ScalarProperty Name="description" ColumnName="description" />
 338                 <ScalarProperty Name="created_at" ColumnName="created_at" />
 339                 <ScalarProperty Name="updated_at" ColumnName="updated_at" />
 340                 <ScalarProperty Name="task_status_id" ColumnName="task_status_id" />
 341                 <ScalarProperty Name="user_id" ColumnName="user_id" />
 342               </MappingFragment>
 343             </EntityTypeMapping>
 344           </EntitySetMapping>
 345           <EntitySetMapping Name="sysdiagrams">
 346             <EntityTypeMapping TypeName="ProjectsDBModel.sysdiagram">
 347               <MappingFragment StoreEntitySet="sysdiagrams">
 348                 <ScalarProperty Name="name" ColumnName="name" />
 349                 <ScalarProperty Name="principal_id" ColumnName="principal_id" />
 350                 <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
 351                 <ScalarProperty Name="version" ColumnName="version" />
 352                 <ScalarProperty Name="definition" ColumnName="definition" />
 353               </MappingFragment>
 354             </EntityTypeMapping>
 355           </EntitySetMapping>
 356           <EntitySetMapping Name="TaskStatuses">
 357             <EntityTypeMapping TypeName="ProjectsDBModel.TaskStatus">
 358               <MappingFragment StoreEntitySet="TaskStatuses">
 359                 <ScalarProperty Name="id" ColumnName="id" />
 360                 <ScalarProperty Name="status" ColumnName="status" />
 361               </MappingFragment>
 362             </EntityTypeMapping>
 363           </EntitySetMapping>
 364           <EntitySetMapping Name="UserRoles">
 365             <EntityTypeMapping TypeName="ProjectsDBModel.UserRole">
 366               <MappingFragment StoreEntitySet="UserRoles">
 367                 <ScalarProperty Name="id" ColumnName="id" />
 368                 <ScalarProperty Name="role" ColumnName="role" />
 369               </MappingFragment>
 370             </EntityTypeMapping>
 371           </EntitySetMapping>
 372           <EntitySetMapping Name="Users">
 373             <EntityTypeMapping TypeName="ProjectsDBModel.User">
 374               <MappingFragment StoreEntitySet="Users">
 375                 <ScalarProperty Name="id" ColumnName="id" />
 376                 <ScalarProperty Name="login" ColumnName="login" />
 377                 <ScalarProperty Name="password" ColumnName="password" />
 378                 <ScalarProperty Name="role_id" ColumnName="role_id" />
 379               </MappingFragment>
 380             </EntityTypeMapping>
 381           </EntitySetMapping>
 382         </EntityContainerMapping>
 383       </Mapping>
 384     </edmx:Mappings>
 385   </edmx:Runtime>
 386   <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
 387   <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
 388     <Connection>
 389       <DesignerInfoPropertySet>
 390         <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
 391       </DesignerInfoPropertySet>
 392     </Connection>
 393     <Options>
 394       <DesignerInfoPropertySet>
 395         <DesignerProperty Name="ValidateOnBuild" Value="true" />
 396         <DesignerProperty Name="EnablePluralization" Value="true" />
 397         <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
 398         <DesignerProperty Name="UseLegacyProvider" Value="false" />
 399         <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
 400       </DesignerInfoPropertySet>
 401     </Options>
 402     <!-- Diagram content (shape and connector positions) -->
 403     <Diagrams></Diagrams>
 404   </Designer>
 405 </edmx:Edmx>