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 -->
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">
10 <PropertyRef Name="id" />
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" />
19 <EntityType Name="ProjectTasks">
21 <PropertyRef Name="id" />
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" />
32 <EntityType Name="sysdiagrams">
34 <PropertyRef Name="diagram_id" />
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)" />
42 <EntityType Name="TaskStatuses">
44 <PropertyRef Name="id" />
46 <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
47 <Property Name="status" Type="nvarchar" MaxLength="50" />
49 <EntityType Name="UserRoles">
51 <PropertyRef Name="id" />
53 <Property Name="id" Type="int" Nullable="false" />
54 <Property Name="role" Type="nchar" MaxLength="10" Nullable="false" />
56 <EntityType Name="Users">
58 <PropertyRef Name="id" />
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" />
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" />
72 <Dependent Role="Projects">
73 <PropertyRef Name="user_id" />
75 </ReferentialConstraint>
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" />
84 <Dependent Role="ProjectTasks">
85 <PropertyRef Name="project_id" />
87 </ReferentialConstraint>
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" />
96 <Dependent Role="ProjectTasks">
97 <PropertyRef Name="task_status_id" />
99 </ReferentialConstraint>
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" />
108 <Dependent Role="ProjectTasks">
109 <PropertyRef Name="user_id" />
111 </ReferentialConstraint>
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" />
120 <Dependent Role="Users">
121 <PropertyRef Name="role_id" />
123 </ReferentialConstraint>
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" />
136 <AssociationSet Name="FK_Tasks_Projects" Association="Self.FK_Tasks_Projects">
137 <End Role="Projects" EntitySet="Projects" />
138 <End Role="ProjectTasks" EntitySet="ProjectTasks" />
140 <AssociationSet Name="FK_Tasks_TaskStatuses" Association="Self.FK_Tasks_TaskStatuses">
141 <End Role="TaskStatuses" EntitySet="TaskStatuses" />
142 <End Role="ProjectTasks" EntitySet="ProjectTasks" />
144 <AssociationSet Name="FK_Tasks_Users" Association="Self.FK_Tasks_Users">
145 <End Role="Users" EntitySet="Users" />
146 <End Role="ProjectTasks" EntitySet="ProjectTasks" />
148 <AssociationSet Name="FK_Users_UserRoles" Association="Self.FK_Users_UserRoles">
149 <End Role="UserRoles" EntitySet="UserRoles" />
150 <End Role="Users" EntitySet="Users" />
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">
160 <PropertyRef Name="id" />
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" />
171 <EntityType Name="ProjectTask">
173 <PropertyRef Name="id" />
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" />
187 <EntityType Name="sysdiagram">
189 <PropertyRef Name="diagram_id" />
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" />
197 <EntityType Name="TaskStatus">
199 <PropertyRef Name="id" />
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" />
205 <EntityType Name="UserRole">
207 <PropertyRef Name="id" />
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" />
213 <EntityType Name="User">
215 <PropertyRef Name="id" />
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" />
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" />
232 <Dependent Role="Projects">
233 <PropertyRef Name="user_id" />
235 </ReferentialConstraint>
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" />
244 <Dependent Role="ProjectTasks">
245 <PropertyRef Name="project_id" />
247 </ReferentialConstraint>
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" />
256 <Dependent Role="ProjectTasks">
257 <PropertyRef Name="task_status_id" />
259 </ReferentialConstraint>
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" />
268 <Dependent Role="ProjectTasks">
269 <PropertyRef Name="user_id" />
271 </ReferentialConstraint>
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" />
280 <Dependent Role="Users">
281 <PropertyRef Name="role_id" />
283 </ReferentialConstraint>
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" />
296 <AssociationSet Name="FK_Tasks_Projects" Association="Self.FK_Tasks_Projects">
297 <End Role="Projects" EntitySet="Projects" />
298 <End Role="ProjectTasks" EntitySet="ProjectTasks" />
300 <AssociationSet Name="FK_Tasks_TaskStatuses" Association="Self.FK_Tasks_TaskStatuses">
301 <End Role="TaskStatuses" EntitySet="TaskStatuses" />
302 <End Role="ProjectTasks" EntitySet="ProjectTasks" />
304 <AssociationSet Name="FK_Tasks_Users" Association="Self.FK_Tasks_Users">
305 <End Role="Users" EntitySet="Users" />
306 <End Role="ProjectTasks" EntitySet="ProjectTasks" />
308 <AssociationSet Name="FK_Users_UserRoles" Association="Self.FK_Users_UserRoles">
309 <End Role="UserRoles" EntitySet="UserRoles" />
310 <End Role="Users" EntitySet="Users" />
314 </edmx:ConceptualModels>
315 <!-- C-S mapping content -->
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" />
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" />
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" />
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" />
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" />
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" />
382 </EntityContainerMapping>
386 <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
387 <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
389 <DesignerInfoPropertySet>
390 <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
391 </DesignerInfoPropertySet>
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>
402 <!-- Diagram content (shape and connector positions) -->
403 <Diagrams></Diagrams>