Changeset 70a9f6d for iknow-api/Migrations/AppDbContextModelSnapshot.cs

Timestamp:

12/10/25 15:12:34 (10 months ago)

Author:

imbrsk <boris696boris@…>

Branches:

master

Children:

61fd94e

Parents:

33c69d6

Message:

feat: Add ActiveSemesters model and update related entities

• Introduced ActiveSemesters model with properties: id, year, and Type.
• Updated EnrolledSemesters model to include new properties: CratedAt, LastChange, Veryfied, Node, and StudentComment.
• Modified Payment model to change the primary key and updated table name to Payments.
• Added Signature property to SemesterSubject model and updated table name to SemesterSubjects.
• Created new migration to reflect changes in the database schema.
• Updated User model to include a reference to Payments.

File:

• iknow-api/Migrations/AppDbContextModelSnapshot.cs (modified) (8 diffs)

iknow-api/Migrations/AppDbContextModelSnapshot.cs

@@ -23 +23 @@
             NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder);
 
+            modelBuilder.Entity("iknow_api.Models.ActiveSemesters", b =>
+                {
+                    b.Property<int>("id")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("integer");
+
+                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("id"));
+
+                    b.Property<int>("Type")
+                        .HasColumnType("integer");
+
+                    b.Property<int>("year")
+                        .HasColumnType("integer");
+
+                    b.HasKey("id");
+
+                    b.ToTable("ActiveSemesters");
+                });
+
             modelBuilder.Entity("iknow_api.Models.ContactInfo", b =>
                 {
@@ -97 +116 @@
                 {
                     b.Property<int>("Id")
-                        .ValueGeneratedOnAdd()
-                        .HasColumnType("integer");
-
-                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
+                        .HasColumnType("integer");
+
+                    b.Property<DateTime>("CratedAt")
+                        .HasColumnType("timestamp with time zone");
+
+                    b.Property<DateTime>("LastChange")
+                        .HasColumnType("timestamp with time zone");
 
                     b.Property<int>("MajorId")
                         .HasColumnType("integer");
 
+                    b.Property<string>("Node")
+                        .HasColumnType("text");
+
                     b.Property<int>("QuotaType")
                         .HasColumnType("integer");
 
-                    b.Property<int>("Type")
-                        .HasColumnType("integer");
+                    b.Property<string>("StudentComment")
+                        .HasColumnType("text");
 
                     b.Property<int>("UserId")
                         .HasColumnType("integer");
 
-                    b.Property<int>("Year")
-                        .HasColumnType("integer");
+                    b.Property<DateTime>("Veryfied")
+                        .HasColumnType("timestamp with time zone");
 
                     b.HasKey("Id");
@@ -276 +301 @@
             modelBuilder.Entity("iknow_api.Models.Payment", b =>
                 {
+                    b.Property<int>("Id")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("integer");
+
+                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
+
+                    b.Property<int>("EnrollmentInfoId")
+                        .HasColumnType("integer");
+
                     b.Property<int>("UserId")
                         .HasColumnType("integer");
 
-                    b.Property<int>("EnrollmentInfoId")
-                        .HasColumnType("integer");
-
-                    b.Property<int>("Id")
-                        .HasColumnType("integer");
-
-                    b.HasKey("UserId", "EnrollmentInfoId");
+                    b.HasKey("Id");
 
                     b.HasIndex("EnrollmentInfoId");
 
-                    b.ToTable("Payment");
+                    b.HasIndex("UserId");
+
+                    b.ToTable("Payments");
                 });
 
@@ -333 +363 @@
                         .HasColumnType("integer");
 
+                    b.Property<bool>("Signature")
+                        .HasColumnType("boolean");
+
                     b.Property<int>("SubjectId")
                         .HasColumnType("integer");
@@ -349 +382 @@
                     b.HasIndex("UserId");
 
-                    b.ToTable("SemesterSubject");
+                    b.ToTable("SemesterSubjects");
                 });
 
@@ -476 +509 @@
             modelBuilder.Entity("iknow_api.Models.EnrolledSemesters", b =>
                 {
+                    b.HasOne("iknow_api.Models.ActiveSemesters", "Semester")
+                        .WithMany("EnrolledSemesters")
+                        .HasForeignKey("Id")
+                        .OnDelete(DeleteBehavior.Restrict)
+                        .IsRequired();
+
                     b.HasOne("iknow_api.Models.Major", "Major")
                         .WithMany()
@@ -489 +528 @@
 
                     b.Navigation("Major");
+
+                    b.Navigation("Semester");
 
                     b.Navigation("User");
@@ -637 +678 @@
                 });
 
+            modelBuilder.Entity("iknow_api.Models.ActiveSemesters", b =>
+                {
+                    b.Navigation("EnrolledSemesters");
+                });
+
             modelBuilder.Entity("iknow_api.Models.Documents", b =>
                 {