Changeset 899b19d for resTools_backend/backend/Migrations

Timestamp:

07/10/22 10:27:45 (2 years ago)

Author:

Danilo <danilo.najkov@…>

Branches:

master

Children:

a26f6a1

Parents:

cc4db18

Message:

reviews full feature

Location:

resTools_backend/backend/Migrations

Files:

• 20220706122821_Add-Reviews.Designer.cs (added)
• 20220706122821_Add-Reviews.cs (added)
• DataContextModelSnapshot.cs (modified) (4 diffs)

resTools_backend/backend/Migrations/DataContextModelSnapshot.cs

@@ -131 +131 @@
                 });
 
+            modelBuilder.Entity("backend.Entities.Review", b =>
+                {
+                    b.Property<int>("Id")
+                        .ValueGeneratedOnAdd()
+                        .HasColumnType("integer");
+
+                    NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
+
+                    b.Property<DateTime>("CreatedAt")
+                        .HasColumnType("timestamp with time zone");
+
+                    b.Property<string>("Description")
+                        .IsRequired()
+                        .HasColumnType("text");
+
+                    b.Property<int>("RestaurantId")
+                        .HasColumnType("integer");
+
+                    b.Property<int>("Stars")
+                        .HasColumnType("integer");
+
+                    b.Property<string>("Title")
+                        .IsRequired()
+                        .HasColumnType("text");
+
+                    b.Property<int>("UserId")
+                        .HasColumnType("integer");
+
+                    b.HasKey("Id");
+
+                    b.HasIndex("RestaurantId");
+
+                    b.HasIndex("UserId");
+
+                    b.ToTable("Reviews");
+                });
+
             modelBuilder.Entity("backend.Entities.User", b =>
                 {
@@ -142 +179 @@
                         .IsRequired()
                         .HasColumnType("text");
+
+                    b.Property<bool>("IsAdmin")
+                        .HasColumnType("boolean");
 
                     b.Property<string>("Password")
@@ -183 +223 @@
                 });
 
+            modelBuilder.Entity("backend.Entities.Review", b =>
+                {
+                    b.HasOne("backend.Entities.Restaurant", "Restaurant")
+                        .WithMany("Reviews")
+                        .HasForeignKey("RestaurantId")
+                        .OnDelete(DeleteBehavior.Cascade)
+                        .IsRequired();
+
+                    b.HasOne("backend.Entities.User", "User")
+                        .WithMany()
+                        .HasForeignKey("UserId")
+                        .OnDelete(DeleteBehavior.Cascade)
+                        .IsRequired();
+
+                    b.Navigation("Restaurant");
+
+                    b.Navigation("User");
+                });
+
             modelBuilder.Entity("backend.Entities.Restaurant", b =>
                 {
@@ -188 +247 @@
 
                     b.Navigation("Reservations");
+
+                    b.Navigation("Reviews");
                 });