source: iknow-api/Migrations/AppDbContextModelSnapshot.cs@ 2d64b2e

Last change on this file since 2d64b2e was 2d64b2e, checked in by imbrsk <boris696boris@…>, 10 months ago

Refactor model properties for consistency and clarity
  • Property mode set to 100644
File size: 23.0 KB
RevLine 
[2859225]1// <auto-generated />
2using System;
3using Microsoft.EntityFrameworkCore;
4using Microsoft.EntityFrameworkCore.Infrastructure;
5using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
6using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
[e49c3ed]7using iknow_api.Data;
[2859225]8
9#nullable disable
10
11namespace iknow_api.Migrations
12{
13 [DbContext(typeof(AppDbContext))]
14 partial class AppDbContextModelSnapshot : ModelSnapshot
15 {
16 protected override void BuildModel(ModelBuilder modelBuilder)
17 {
18#pragma warning disable 612, 618
19 modelBuilder
20 .HasAnnotation("ProductVersion", "9.0.10")
21 .HasAnnotation("Relational:MaxIdentifierLength", 63);
22
23 NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
24
[cab02ad]25 modelBuilder.Entity("iknow_api.Models.ContactInfo", b =>
26 {
27 b.Property<int>("Id")
28 .ValueGeneratedOnAdd()
29 .HasColumnType("integer");
30
31 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
32
[2d64b2e]33 b.Property<string>("Address")
[cab02ad]34 .HasColumnType("text");
35
[2d64b2e]36 b.Property<string>("City")
[cab02ad]37 .HasColumnType("text");
38
[2d64b2e]39 b.Property<string>("MicrosoftEmail")
[cab02ad]40 .HasColumnType("text");
41
[2d64b2e]42 b.Property<string>("Municipality")
[cab02ad]43 .HasColumnType("text");
44
[2d64b2e]45 b.Property<string>("PhoneNumber")
[cab02ad]46 .HasColumnType("text");
47
[2d64b2e]48 b.Property<int>("UserId")
49 .HasColumnType("integer");
50
[cab02ad]51 b.HasKey("Id");
52
[b38c39c]53 b.HasIndex("UserId")
54 .IsUnique();
[cab02ad]55
56 b.ToTable("ContactInfo");
57 });
58
[c2f79d7]59 modelBuilder.Entity("iknow_api.Models.DependencySubject", b =>
60 {
61 b.Property<int>("SubjectId")
62 .HasColumnType("integer");
63
64 b.Property<int>("DependencyId")
65 .HasColumnType("integer");
66
67 b.HasKey("SubjectId", "DependencyId");
68
69 b.HasIndex("DependencyId");
70
71 b.ToTable("DependencySubjects");
72 });
73
74 modelBuilder.Entity("iknow_api.Models.Documents", b =>
75 {
76 b.Property<int>("Id")
77 .ValueGeneratedOnAdd()
78 .HasColumnType("integer");
79
80 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
81
[2d64b2e]82 b.Property<string>("Body")
[c2f79d7]83 .HasColumnType("text");
84
[2d64b2e]85 b.Property<int>("Cost")
[c2f79d7]86 .HasColumnType("integer");
87
[2d64b2e]88 b.Property<string>("Name")
[c2f79d7]89 .HasColumnType("text");
90
91 b.HasKey("Id");
92
93 b.ToTable("Documents");
94 });
95
96 modelBuilder.Entity("iknow_api.Models.EnrolledSemesters", b =>
97 {
98 b.Property<int>("Id")
99 .ValueGeneratedOnAdd()
100 .HasColumnType("integer");
101
102 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
103
104 b.Property<int>("MajorId")
105 .HasColumnType("integer");
106
107 b.Property<int>("QuotaType")
108 .HasColumnType("integer");
109
110 b.Property<int>("Type")
111 .HasColumnType("integer");
112
113 b.Property<int>("UserId")
114 .HasColumnType("integer");
115
116 b.Property<int>("Year")
117 .HasColumnType("integer");
118
119 b.HasKey("Id");
120
121 b.HasIndex("MajorId");
122
123 b.HasIndex("UserId");
124
125 b.ToTable("EnrolledSemesters");
126 });
127
[cab02ad]128 modelBuilder.Entity("iknow_api.Models.EnrollmentInfo", b =>
129 {
130 b.Property<int>("Id")
131 .ValueGeneratedOnAdd()
132 .HasColumnType("integer");
133
134 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
135
[c2f79d7]136 b.Property<int>("MajorId")
137 .HasColumnType("integer");
138
[2d64b2e]139 b.Property<string>("StudyStatus")
140 .HasColumnType("text");
141
142 b.Property<string>("StudyType")
143 .HasColumnType("text");
144
[cab02ad]145 b.Property<int>("UserId")
146 .HasColumnType("integer");
147
148 b.Property<int>("enrollmentYear")
149 .HasColumnType("integer");
150
[c2f79d7]151 b.Property<int>("quota")
[cab02ad]152 .HasColumnType("integer");
153
154 b.HasKey("Id");
155
[c2f79d7]156 b.HasIndex("MajorId");
157
[b38c39c]158 b.HasIndex("UserId")
159 .IsUnique();
[cab02ad]160
161 b.ToTable("EnrollmentInfo");
162 });
163
164 modelBuilder.Entity("iknow_api.Models.HighSchool", b =>
165 {
166 b.Property<int>("Id")
167 .ValueGeneratedOnAdd()
168 .HasColumnType("integer");
169
170 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
171
172 b.Property<float>("GPA")
173 .HasColumnType("real");
174
[2d64b2e]175 b.Property<int>("HighSchoolType")
[cab02ad]176 .HasColumnType("integer");
177
[2d64b2e]178 b.Property<string>("StudyLanguage")
179 .HasColumnType("text");
180
181 b.Property<int>("UserId")
[cab02ad]182 .HasColumnType("integer");
183
184 b.HasKey("Id");
185
[b38c39c]186 b.HasIndex("UserId")
187 .IsUnique();
[cab02ad]188
189 b.ToTable("HighSchool");
[f8af32b]190 });
191
[c2f79d7]192 modelBuilder.Entity("iknow_api.Models.Major", b =>
193 {
194 b.Property<int>("Id")
195 .ValueGeneratedOnAdd()
196 .HasColumnType("integer");
197
198 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
199
200 b.Property<string>("Name")
201 .HasColumnType("text");
202
203 b.HasKey("Id");
204
205 b.ToTable("Majors");
206
207 b.HasData(
208 new
209 {
210 Id = 1,
211 Name = "PIT"
212 },
213 new
214 {
215 Id = 2,
216 Name = "SIIS"
217 },
218 new
219 {
220 Id = 3,
221 Name = "SEIS"
222 },
223 new
224 {
225 Id = 4,
226 Name = "KN"
227 });
228 });
229
230 modelBuilder.Entity("iknow_api.Models.MajorSubjects", b =>
231 {
232 b.Property<int>("MajorId")
233 .HasColumnType("integer");
234
235 b.Property<int>("SubjectId")
236 .HasColumnType("integer");
237
[2d64b2e]238 b.Property<int>("Accreditation")
[c2f79d7]239 .HasColumnType("integer");
240
241 b.Property<int>("MandatorySemester")
242 .HasColumnType("integer");
243
244 b.HasKey("MajorId", "SubjectId");
245
246 b.HasIndex("SubjectId");
247
248 b.ToTable("MajorSubjects");
249 });
250
251 modelBuilder.Entity("iknow_api.Models.PassedSubject", b =>
252 {
253 b.Property<int>("Id")
254 .ValueGeneratedOnAdd()
255 .HasColumnType("integer");
256
257 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
258
259 b.Property<DateTime>("DatePassed")
260 .HasColumnType("timestamp with time zone");
261
262 b.Property<int>("Grade")
263 .HasColumnType("integer");
264
265 b.Property<int>("SemesterSubjectId")
266 .HasColumnType("integer");
267
268 b.HasKey("Id");
269
270 b.HasIndex("SemesterSubjectId")
271 .IsUnique();
272
273 b.ToTable("PassedSubjects");
274 });
275
276 modelBuilder.Entity("iknow_api.Models.Payment", b =>
277 {
278 b.Property<int>("UserId")
279 .HasColumnType("integer");
280
281 b.Property<int>("EnrollmentInfoId")
282 .HasColumnType("integer");
283
284 b.Property<int>("Id")
285 .HasColumnType("integer");
286
287 b.HasKey("UserId", "EnrollmentInfoId");
288
289 b.HasIndex("EnrollmentInfoId");
290
291 b.ToTable("Payment");
292 });
293
[f8af32b]294 modelBuilder.Entity("iknow_api.Models.RefreshToken", b =>
295 {
296 b.Property<int>("Id")
297 .ValueGeneratedOnAdd()
298 .HasColumnType("integer");
299
300 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
301
[3347c1b]302 b.Property<DateTime>("ExpiresAt")
303 .HasColumnType("timestamp with time zone");
304
305 b.Property<bool>("IsValid")
306 .HasColumnType("boolean");
307
308 b.Property<string>("Token")
309 .HasColumnType("text");
310
311 b.Property<int>("UserId")
312 .HasColumnType("integer");
313
314 b.HasKey("Id");
315
316 b.HasIndex("UserId");
317
318 b.ToTable("RefreshToken");
[cab02ad]319 });
320
[c2f79d7]321 modelBuilder.Entity("iknow_api.Models.SemesterSubject", b =>
322 {
323 b.Property<int>("Id")
324 .ValueGeneratedOnAdd()
325 .HasColumnType("integer");
326
327 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
328
329 b.Property<int>("EnrolledSemesterId")
330 .HasColumnType("integer");
331
332 b.Property<int>("ProfessorId")
333 .HasColumnType("integer");
334
335 b.Property<int>("SubjectId")
336 .HasColumnType("integer");
337
338 b.Property<int>("UserId")
339 .HasColumnType("integer");
340
341 b.HasKey("Id");
342
343 b.HasIndex("EnrolledSemesterId");
344
345 b.HasIndex("ProfessorId");
346
347 b.HasIndex("SubjectId");
348
349 b.HasIndex("UserId");
350
351 b.ToTable("SemesterSubject");
352 });
353
354 modelBuilder.Entity("iknow_api.Models.Subject", b =>
355 {
356 b.Property<int>("Id")
357 .ValueGeneratedOnAdd()
358 .HasColumnType("integer");
359
360 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
361
362 b.Property<int?>("AwardedCredits")
363 .HasColumnType("integer");
364
365 b.Property<string>("Code")
366 .HasColumnType("text");
367
368 b.Property<int?>("DependencyCredit")
369 .HasColumnType("integer");
370
371 b.Property<string>("Name")
372 .HasColumnType("text");
373
374 b.HasKey("Id");
375
376 b.ToTable("Subjects");
377 });
378
[cab02ad]379 modelBuilder.Entity("iknow_api.Models.User", b =>
[2859225]380 {
381 b.Property<int>("Id")
382 .ValueGeneratedOnAdd()
383 .HasColumnType("integer");
384
385 NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
386
387 b.Property<DateTime>("Bday")
388 .HasColumnType("timestamp with time zone");
389
[2d64b2e]390 b.Property<string>("Citizenship")
391 .HasColumnType("text");
392
[2859225]393 b.Property<DateTime>("CreatedAt")
394 .HasColumnType("timestamp with time zone");
395
[3592476]396 b.Property<string>("EMBG")
397 .HasColumnType("text");
398
[2859225]399 b.Property<string>("Email")
400 .HasColumnType("text");
401
[2d64b2e]402 b.Property<string>("Gender")
403 .HasColumnType("text");
404
[2859225]405 b.Property<string>("Index")
406 .HasColumnType("text");
407
[2d64b2e]408 b.Property<string>("MiddleName")
409 .HasColumnType("text");
410
[2859225]411 b.Property<string>("Name")
412 .HasColumnType("text");
413
[2d64b2e]414 b.Property<string>("Nationality")
415 .HasColumnType("text");
416
[5b42c8d]417 b.Property<string>("PasswordHash")
[2859225]418 .HasColumnType("text");
419
420 b.Property<int>("Role")
421 .HasColumnType("integer");
422
423 b.Property<string>("Surname")
424 .HasColumnType("text");
425
426 b.HasKey("Id");
427
[9a57e89]428 b.ToTable("User");
[2859225]429 });
[cab02ad]430
[c2f79d7]431 modelBuilder.Entity("iknow_api.Models.UserDocuments", b =>
432 {
433 b.Property<int>("UserId")
434 .HasColumnType("integer");
435
436 b.Property<int>("DocumentId")
437 .HasColumnType("integer");
438
439 b.HasKey("UserId", "DocumentId");
440
441 b.HasIndex("DocumentId");
442
443 b.ToTable("UserDocuments");
444 });
445
[cab02ad]446 modelBuilder.Entity("iknow_api.Models.ContactInfo", b =>
447 {
448 b.HasOne("iknow_api.Models.User", "User")
[b38c39c]449 .WithOne("ContactInfo")
450 .HasForeignKey("iknow_api.Models.ContactInfo", "UserId")
[cab02ad]451 .OnDelete(DeleteBehavior.Cascade)
452 .IsRequired();
453
454 b.Navigation("User");
455 });
456
[c2f79d7]457 modelBuilder.Entity("iknow_api.Models.DependencySubject", b =>
458 {
459 b.HasOne("iknow_api.Models.Subject", "Dependency")
460 .WithMany("Dependents")
461 .HasForeignKey("DependencyId")
462 .OnDelete(DeleteBehavior.Restrict)
463 .IsRequired();
464
465 b.HasOne("iknow_api.Models.Subject", "Subject")
466 .WithMany("Dependencies")
467 .HasForeignKey("SubjectId")
468 .OnDelete(DeleteBehavior.Restrict)
469 .IsRequired();
470
471 b.Navigation("Dependency");
472
473 b.Navigation("Subject");
474 });
475
476 modelBuilder.Entity("iknow_api.Models.EnrolledSemesters", b =>
477 {
478 b.HasOne("iknow_api.Models.Major", "Major")
479 .WithMany()
480 .HasForeignKey("MajorId")
481 .OnDelete(DeleteBehavior.Cascade)
482 .IsRequired();
483
484 b.HasOne("iknow_api.Models.User", "User")
485 .WithMany()
486 .HasForeignKey("UserId")
487 .OnDelete(DeleteBehavior.Cascade)
488 .IsRequired();
489
490 b.Navigation("Major");
491
492 b.Navigation("User");
493 });
494
[cab02ad]495 modelBuilder.Entity("iknow_api.Models.EnrollmentInfo", b =>
496 {
[c2f79d7]497 b.HasOne("iknow_api.Models.Major", "Major")
498 .WithMany()
499 .HasForeignKey("MajorId")
500 .OnDelete(DeleteBehavior.Cascade)
501 .IsRequired();
502
[cab02ad]503 b.HasOne("iknow_api.Models.User", "User")
[b38c39c]504 .WithOne("EnrollmentInfo")
505 .HasForeignKey("iknow_api.Models.EnrollmentInfo", "UserId")
[cab02ad]506 .OnDelete(DeleteBehavior.Cascade)
507 .IsRequired();
508
[c2f79d7]509 b.Navigation("Major");
510
[cab02ad]511 b.Navigation("User");
512 });
513
514 modelBuilder.Entity("iknow_api.Models.HighSchool", b =>
515 {
516 b.HasOne("iknow_api.Models.User", "User")
[b38c39c]517 .WithOne("HighSchool")
518 .HasForeignKey("iknow_api.Models.HighSchool", "UserId")
[cab02ad]519 .OnDelete(DeleteBehavior.Cascade)
520 .IsRequired();
521
522 b.Navigation("User");
523 });
[b38c39c]524
[c2f79d7]525 modelBuilder.Entity("iknow_api.Models.MajorSubjects", b =>
526 {
527 b.HasOne("iknow_api.Models.Major", "Majors")
528 .WithMany("Subjects")
529 .HasForeignKey("MajorId")
530 .OnDelete(DeleteBehavior.Cascade)
531 .IsRequired();
532
533 b.HasOne("iknow_api.Models.Subject", "Subjects")
534 .WithMany("Majors")
535 .HasForeignKey("SubjectId")
536 .OnDelete(DeleteBehavior.Cascade)
537 .IsRequired();
538
539 b.Navigation("Majors");
540
541 b.Navigation("Subjects");
542 });
543
544 modelBuilder.Entity("iknow_api.Models.PassedSubject", b =>
545 {
546 b.HasOne("iknow_api.Models.SemesterSubject", "SemesterSubject")
547 .WithOne("PassedSubject")
548 .HasForeignKey("iknow_api.Models.PassedSubject", "SemesterSubjectId")
549 .OnDelete(DeleteBehavior.Cascade)
550 .IsRequired();
551
552 b.Navigation("SemesterSubject");
553 });
554
555 modelBuilder.Entity("iknow_api.Models.Payment", b =>
556 {
557 b.HasOne("iknow_api.Models.EnrolledSemesters", "EnrolledSemesters")
558 .WithMany("Users")
559 .HasForeignKey("EnrollmentInfoId")
560 .OnDelete(DeleteBehavior.Cascade)
561 .IsRequired();
562
563 b.HasOne("iknow_api.Models.User", "User")
564 .WithMany("EnrolledSemesters")
565 .HasForeignKey("UserId")
566 .OnDelete(DeleteBehavior.Cascade)
567 .IsRequired();
568
569 b.Navigation("EnrolledSemesters");
570
571 b.Navigation("User");
572 });
573
[f8af32b]574 modelBuilder.Entity("iknow_api.Models.RefreshToken", b =>
575 {
576 b.HasOne("iknow_api.Models.User", "User")
577 .WithMany()
578 .HasForeignKey("UserId")
579 .OnDelete(DeleteBehavior.Cascade)
580 .IsRequired();
581
582 b.Navigation("User");
583 });
584
[c2f79d7]585 modelBuilder.Entity("iknow_api.Models.SemesterSubject", b =>
586 {
587 b.HasOne("iknow_api.Models.EnrolledSemesters", "EnrolledSemester")
588 .WithMany("SemesterSubjects")
589 .HasForeignKey("EnrolledSemesterId")
590 .OnDelete(DeleteBehavior.Restrict)
591 .IsRequired();
592
593 b.HasOne("iknow_api.Models.User", "Professor")
594 .WithMany("TeachingSubjects")
595 .HasForeignKey("ProfessorId")
596 .OnDelete(DeleteBehavior.Restrict)
597 .IsRequired();
598
599 b.HasOne("iknow_api.Models.Subject", "Subject")
600 .WithMany("SemesterSubjects")
601 .HasForeignKey("SubjectId")
602 .OnDelete(DeleteBehavior.Restrict)
603 .IsRequired();
604
605 b.HasOne("iknow_api.Models.User", "User")
606 .WithMany("EnrolledSemesterUserSubjects")
607 .HasForeignKey("UserId")
608 .OnDelete(DeleteBehavior.Restrict)
609 .IsRequired();
610
611 b.Navigation("EnrolledSemester");
612
613 b.Navigation("Professor");
614
615 b.Navigation("Subject");
616
617 b.Navigation("User");
618 });
619
620 modelBuilder.Entity("iknow_api.Models.UserDocuments", b =>
621 {
622 b.HasOne("iknow_api.Models.Documents", "Documents")
623 .WithMany("User")
624 .HasForeignKey("DocumentId")
625 .OnDelete(DeleteBehavior.Cascade)
626 .IsRequired();
627
628 b.HasOne("iknow_api.Models.User", "User")
629 .WithMany("Documents")
630 .HasForeignKey("UserId")
631 .OnDelete(DeleteBehavior.Cascade)
632 .IsRequired();
633
634 b.Navigation("Documents");
635
636 b.Navigation("User");
637 });
638
639 modelBuilder.Entity("iknow_api.Models.Documents", b =>
640 {
641 b.Navigation("User");
642 });
643
644 modelBuilder.Entity("iknow_api.Models.EnrolledSemesters", b =>
645 {
646 b.Navigation("SemesterSubjects");
647
648 b.Navigation("Users");
649 });
650
651 modelBuilder.Entity("iknow_api.Models.Major", b =>
652 {
653 b.Navigation("Subjects");
654 });
655
656 modelBuilder.Entity("iknow_api.Models.SemesterSubject", b =>
657 {
658 b.Navigation("PassedSubject");
659 });
660
661 modelBuilder.Entity("iknow_api.Models.Subject", b =>
662 {
663 b.Navigation("Dependencies");
664
665 b.Navigation("Dependents");
666
667 b.Navigation("Majors");
668
669 b.Navigation("SemesterSubjects");
670 });
671
[b38c39c]672 modelBuilder.Entity("iknow_api.Models.User", b =>
673 {
674 b.Navigation("ContactInfo");
675
[c2f79d7]676 b.Navigation("Documents");
677
678 b.Navigation("EnrolledSemesterUserSubjects");
679
680 b.Navigation("EnrolledSemesters");
681
[b38c39c]682 b.Navigation("EnrollmentInfo");
683
684 b.Navigation("HighSchool");
[c2f79d7]685
686 b.Navigation("TeachingSubjects");
[b38c39c]687 });
[2859225]688#pragma warning restore 612, 618
689 }
690 }
691}
Note: See TracBrowser for help on using the repository browser.