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