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="ProjectUsers">
34 <PropertyRef Name="id" />
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" />
40 <EntityType Name="sysdiagrams">
42 <PropertyRef Name="diagram_id" />
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)" />
50 <EntityType Name="TaskStatuses">
52 <PropertyRef Name="int" />
54 <Property Name="int" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
55 <Property Name="status" Type="nvarchar" MaxLength="50" />
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" />
64 <Dependent Role="Projects">
65 <PropertyRef Name="user_id" />
67 </ReferentialConstraint>
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" />
76 <Dependent Role="ProjectTasks">
77 <PropertyRef Name="project_id" />
79 </ReferentialConstraint>
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" />
88 <Dependent Role="ProjectTasks">
89 <PropertyRef Name="task_status_id" />
91 </ReferentialConstraint>
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" />
100 <Dependent Role="ProjectTasks">
101 <PropertyRef Name="user_id" />
103 </ReferentialConstraint>
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" />
115 <AssociationSet Name="FK_Tasks_Projects" Association="Self.FK_Tasks_Projects">
116 <End Role="Projects" EntitySet="Projects" />
117 <End Role="ProjectTasks" EntitySet="ProjectTasks" />
119 <AssociationSet Name="FK_Tasks_TaskStatuses" Association="Self.FK_Tasks_TaskStatuses">
120 <End Role="TaskStatuses" EntitySet="TaskStatuses" />
121 <End Role="ProjectTasks" EntitySet="ProjectTasks" />
123 <AssociationSet Name="FK_Tasks_Users" Association="Self.FK_Tasks_Users">
124 <End Role="ProjectUsers" EntitySet="ProjectUsers" />
125 <End Role="ProjectTasks" EntitySet="ProjectTasks" />
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">
134 <PropertyRef Name="id" />
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" />
145 <EntityType Name="ProjectTask">
147 <PropertyRef Name="id" />
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" />
161 <EntityType Name="ProjectUser">
163 <PropertyRef Name="id" />
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" />
171 <EntityType Name="sysdiagram">
173 <PropertyRef Name="diagram_id" />
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" />
181 <EntityType Name="TaskStatus">
183 <PropertyRef Name="int" />
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" />
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" />
196 <Dependent Role="Projects">
197 <PropertyRef Name="user_id" />
199 </ReferentialConstraint>
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" />
208 <Dependent Role="ProjectTasks">
209 <PropertyRef Name="project_id" />
211 </ReferentialConstraint>
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" />
220 <Dependent Role="ProjectTasks">
221 <PropertyRef Name="task_status_id" />
223 </ReferentialConstraint>
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" />
232 <Dependent Role="ProjectTasks">
233 <PropertyRef Name="user_id" />
235 </ReferentialConstraint>
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" />
247 <AssociationSet Name="FK_Tasks_Projects" Association="Self.FK_Tasks_Projects">
248 <End Role="Projects" EntitySet="Projects" />
249 <End Role="ProjectTasks" EntitySet="ProjectTasks" />
251 <AssociationSet Name="FK_Tasks_TaskStatuses" Association="Self.FK_Tasks_TaskStatuses">
252 <End Role="TaskStatuses" EntitySet="TaskStatuses" />
253 <End Role="ProjectTasks" EntitySet="ProjectTasks" />
255 <AssociationSet Name="FK_Tasks_Users" Association="Self.FK_Tasks_Users">
256 <End Role="ProjectUsers" EntitySet="ProjectUsers" />
257 <End Role="ProjectTasks" EntitySet="ProjectTasks" />
261 </edmx:ConceptualModels>
262 <!-- C-S mapping content -->
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" />
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" />
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" />
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" />
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" />
320 </EntityContainerMapping>
324 <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
325 <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
327 <DesignerInfoPropertySet>
328 <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
329 </DesignerInfoPropertySet>
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>
340 <!-- Diagram content (shape and connector positions) -->
341 <Diagrams></Diagrams>