1  // <auto-generated />
  2  using System;
  3  using Microsoft.EntityFrameworkCore;
  4  using Microsoft.EntityFrameworkCore.Infrastructure;
  5  using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
  6  using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata;
  7  using _5uhr.Data;
  8  
  9  #nullable disable
 10  
 11  namespace _5uhr.Migrations
 12  {
 13      [DbContext(typeof(ApplicationDbContext))]
 14      partial class ApplicationDbContextModelSnapshot : 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  
 25              modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRole", b =>
 26                  {
 27                      b.Property<string>("Id")
 28                          .HasColumnType("text");
 29  
 30                      b.Property<string>("ConcurrencyStamp")
 31                          .IsConcurrencyToken()
 32                          .HasColumnType("text");
 33  
 34                      b.Property<string>("Name")
 35                          .HasMaxLength(256)
 36                          .HasColumnType("character varying(256)");
 37  
 38                      b.Property<string>("NormalizedName")
 39                          .HasMaxLength(256)
 40                          .HasColumnType("character varying(256)");
 41  
 42                      b.HasKey("Id");
 43  
 44                      b.HasIndex("NormalizedName")
 45                          .IsUnique()
 46                          .HasDatabaseName("RoleNameIndex");
 47  
 48                      b.ToTable("AspNetRoles", (string)null);
 49                  });
 50  
 51              modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
 52                  {
 53                      b.Property<int>("Id")
 54                          .ValueGeneratedOnAdd()
 55                          .HasColumnType("integer");
 56  
 57                      NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
 58  
 59                      b.Property<string>("ClaimType")
 60                          .HasColumnType("text");
 61  
 62                      b.Property<string>("ClaimValue")
 63                          .HasColumnType("text");
 64  
 65                      b.Property<string>("RoleId")
 66                          .IsRequired()
 67                          .HasColumnType("text");
 68  
 69                      b.HasKey("Id");
 70  
 71                      b.HasIndex("RoleId");
 72  
 73                      b.ToTable("AspNetRoleClaims", (string)null);
 74                  });
 75  
 76              modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUser", b =>
 77                  {
 78                      b.Property<string>("Id")
 79                          .HasColumnType("text");
 80  
 81                      b.Property<int>("AccessFailedCount")
 82                          .HasColumnType("integer");
 83  
 84                      b.Property<string>("ConcurrencyStamp")
 85                          .IsConcurrencyToken()
 86                          .HasColumnType("text");
 87  
 88                      b.Property<string>("Email")
 89                          .HasMaxLength(256)
 90                          .HasColumnType("character varying(256)");
 91  
 92                      b.Property<bool>("EmailConfirmed")
 93                          .HasColumnType("boolean");
 94  
 95                      b.Property<bool>("LockoutEnabled")
 96                          .HasColumnType("boolean");
 97  
 98                      b.Property<DateTimeOffset?>("LockoutEnd")
 99                          .HasColumnType("timestamp with time zone");
100  
101                      b.Property<string>("NormalizedEmail")
102                          .HasMaxLength(256)
103                          .HasColumnType("character varying(256)");
104  
105                      b.Property<string>("NormalizedUserName")
106                          .HasMaxLength(256)
107                          .HasColumnType("character varying(256)");
108  
109                      b.Property<string>("PasswordHash")
110                          .HasColumnType("text");
111  
112                      b.Property<string>("PhoneNumber")
113                          .HasColumnType("text");
114  
115                      b.Property<bool>("PhoneNumberConfirmed")
116                          .HasColumnType("boolean");
117  
118                      b.Property<string>("SecurityStamp")
119                          .HasColumnType("text");
120  
121                      b.Property<bool>("TwoFactorEnabled")
122                          .HasColumnType("boolean");
123  
124                      b.Property<string>("UserName")
125                          .HasMaxLength(256)
126                          .HasColumnType("character varying(256)");
127  
128                      b.HasKey("Id");
129  
130                      b.HasIndex("NormalizedEmail")
131                          .HasDatabaseName("EmailIndex");
132  
133                      b.HasIndex("NormalizedUserName")
134                          .IsUnique()
135                          .HasDatabaseName("UserNameIndex");
136  
137                      b.ToTable("AspNetUsers", (string)null);
138                  });
139  
140              modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
141                  {
142                      b.Property<int>("Id")
143                          .ValueGeneratedOnAdd()
144                          .HasColumnType("integer");
145  
146                      NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id"));
147  
148                      b.Property<string>("ClaimType")
149                          .HasColumnType("text");
150  
151                      b.Property<string>("ClaimValue")
152                          .HasColumnType("text");
153  
154                      b.Property<string>("UserId")
155                          .IsRequired()
156                          .HasColumnType("text");
157  
158                      b.HasKey("Id");
159  
160                      b.HasIndex("UserId");
161  
162                      b.ToTable("AspNetUserClaims", (string)null);
163                  });
164  
165              modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
166                  {
167                      b.Property<string>("LoginProvider")
168                          .HasMaxLength(128)
169                          .HasColumnType("character varying(128)");
170  
171                      b.Property<string>("ProviderKey")
172                          .HasMaxLength(128)
173                          .HasColumnType("character varying(128)");
174  
175                      b.Property<string>("ProviderDisplayName")
176                          .HasColumnType("text");
177  
178                      b.Property<string>("UserId")
179                          .IsRequired()
180                          .HasColumnType("text");
181  
182                      b.HasKey("LoginProvider", "ProviderKey");
183  
184                      b.HasIndex("UserId");
185  
186                      b.ToTable("AspNetUserLogins", (string)null);
187                  });
188  
189              modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
190                  {
191                      b.Property<string>("UserId")
192                          .HasColumnType("text");
193  
194                      b.Property<string>("RoleId")
195                          .HasColumnType("text");
196  
197                      b.HasKey("UserId", "RoleId");
198  
199                      b.HasIndex("RoleId");
200  
201                      b.ToTable("AspNetUserRoles", (string)null);
202                  });
203  
204              modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
205                  {
206                      b.Property<string>("UserId")
207                          .HasColumnType("text");
208  
209                      b.Property<string>("LoginProvider")
210                          .HasMaxLength(128)
211                          .HasColumnType("character varying(128)");
212  
213                      b.Property<string>("Name")
214                          .HasMaxLength(128)
215                          .HasColumnType("character varying(128)");
216  
217                      b.Property<string>("Value")
218                          .HasColumnType("text");
219  
220                      b.HasKey("UserId", "LoginProvider", "Name");
221  
222                      b.ToTable("AspNetUserTokens", (string)null);
223                  });
224  
225              modelBuilder.Entity("_5uhr.Data.CheckIn", b =>
226                  {
227                      b.Property<Guid>("Id")
228                          .ValueGeneratedOnAdd()
229                          .HasColumnType("uuid");
230  
231                      b.Property<DateTimeOffset>("CheckInTime")
232                          .HasColumnType("timestamp with time zone");
233  
234                      b.Property<string>("ClaimedCheckpoint")
235                          .IsRequired()
236                          .HasColumnType("VARCHAR(4)");
237  
238                      b.Property<Guid>("DayOfCheckInId")
239                          .HasColumnType("uuid");
240  
241                      b.Property<Guid>("MemberThatCheckedInId")
242                          .HasColumnType("uuid");
243  
244                      b.HasKey("Id");
245  
246                      b.HasIndex("DayOfCheckInId");
247  
248                      b.HasIndex("MemberThatCheckedInId");
249  
250                      b.ToTable("CheckIn");
251                  });
252  
253              modelBuilder.Entity("_5uhr.Data.Configuration", b =>
254                  {
255                      b.Property<Guid>("Id")
256                          .ValueGeneratedOnAdd()
257                          .HasColumnType("uuid");
258  
259                      b.Property<decimal>("CheckInChannelId")
260                          .HasColumnType("numeric(20,0)");
261  
262                      b.Property<decimal>("GuildId")
263                          .HasColumnType("numeric(20,0)");
264  
265                      b.Property<decimal>("LeaderboardChannelId")
266                          .HasColumnType("numeric(20,0)");
267  
268                      b.HasKey("Id");
269  
270                      b.ToTable("Configurations");
271                  });
272  
273              modelBuilder.Entity("_5uhr.Data.GangDay", b =>
274                  {
275                      b.Property<Guid>("Id")
276                          .ValueGeneratedOnAdd()
277                          .HasColumnType("uuid");
278  
279                      b.Property<decimal?>("MessageForCheckIn4")
280                          .HasColumnType("numeric(20,0)");
281  
282                      b.Property<decimal?>("MessageForCheckIn5")
283                          .HasColumnType("numeric(20,0)");
284  
285                      b.Property<decimal?>("MessageForPreCheckInsId")
286                          .HasColumnType("numeric(20,0)");
287  
288                      b.Property<Guid?>("NextId")
289                          .HasColumnType("uuid");
290  
291                      b.Property<DateTime>("Start")
292                          .HasColumnType("timestamp with time zone");
293  
294                      b.HasKey("Id");
295  
296                      b.HasIndex("NextId")
297                          .IsUnique();
298  
299                      b.ToTable("Days");
300                  });
301  
302              modelBuilder.Entity("_5uhr.Data.Member", b =>
303                  {
304                      b.Property<Guid>("Id")
305                          .ValueGeneratedOnAdd()
306                          .HasColumnType("uuid");
307  
308                      b.Property<decimal?>("DiscordUserId")
309                          .HasColumnType("numeric(20,0)");
310  
311                      b.Property<string>("FriendlyName")
312                          .HasColumnType("text");
313  
314                      b.Property<int>("ImportedCheckIns4Uhr")
315                          .HasColumnType("integer");
316  
317                      b.Property<int>("ImportedCheckIns5Uhr")
318                          .HasColumnType("integer");
319  
320                      b.HasKey("Id");
321  
322                      b.ToTable("Member");
323                  });
324  
325              modelBuilder.Entity("_5uhr.Data.PreCheckIn", b =>
326                  {
327                      b.Property<Guid>("Id")
328                          .ValueGeneratedOnAdd()
329                          .HasColumnType("uuid");
330  
331                      b.Property<int>("ClaimedCheckpoint")
332                          .HasColumnType("integer");
333  
334                      b.Property<Guid>("DayId")
335                          .HasColumnType("uuid");
336  
337                      b.Property<Guid>("MemberThatPreCheckedInId")
338                          .HasColumnType("uuid");
339  
340                      b.Property<DateTimeOffset>("Timestamp")
341                          .HasColumnType("timestamp with time zone");
342  
343                      b.HasKey("Id");
344  
345                      b.HasIndex("DayId");
346  
347                      b.HasIndex("MemberThatPreCheckedInId");
348  
349                      b.ToTable("PreCheckIns");
350                  });
351  
352              modelBuilder.Entity("_5uhr.Data.Report", b =>
353                  {
354                      b.Property<Guid>("Id")
355                          .ValueGeneratedOnAdd()
356                          .HasColumnType("uuid");
357  
358                      b.Property<Guid>("CheckInThatWasReportedId")
359                          .HasColumnType("uuid");
360  
361                      b.Property<string>("EvidenceString")
362                          .IsRequired()
363                          .HasColumnType("text");
364  
365                      b.Property<Guid>("MemberThatReportedId")
366                          .HasColumnType("uuid");
367  
368                      b.Property<string>("Reason")
369                          .IsRequired()
370                          .HasColumnType("text");
371  
372                      b.Property<DateTimeOffset>("ReportTime")
373                          .HasColumnType("timestamp with time zone");
374  
375                      b.HasKey("Id");
376  
377                      b.HasIndex("CheckInThatWasReportedId");
378  
379                      b.HasIndex("MemberThatReportedId");
380  
381                      b.ToTable("Reports");
382                  });
383  
384              modelBuilder.Entity("_5uhr.Data.Verification", b =>
385                  {
386                      b.Property<Guid>("Id")
387                          .ValueGeneratedOnAdd()
388                          .HasColumnType("uuid");
389  
390                      b.Property<Guid>("CheckInThatWasVerifiedId")
391                          .HasColumnType("uuid");
392  
393                      b.Property<Guid>("MemberThatVerifiedId")
394                          .HasColumnType("uuid");
395  
396                      b.Property<DateTimeOffset>("VerificationTime")
397                          .HasColumnType("timestamp with time zone");
398  
399                      b.HasKey("Id");
400  
401                      b.HasIndex("CheckInThatWasVerifiedId");
402  
403                      b.HasIndex("MemberThatVerifiedId");
404  
405                      b.ToTable("Verifications");
406                  });
407  
408              modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
409                  {
410                      b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null)
411                          .WithMany()
412                          .HasForeignKey("RoleId")
413                          .OnDelete(DeleteBehavior.Cascade)
414                          .IsRequired();
415                  });
416  
417              modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
418                  {
419                      b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser", null)
420                          .WithMany()
421                          .HasForeignKey("UserId")
422                          .OnDelete(DeleteBehavior.Cascade)
423                          .IsRequired();
424                  });
425  
426              modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
427                  {
428                      b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser", null)
429                          .WithMany()
430                          .HasForeignKey("UserId")
431                          .OnDelete(DeleteBehavior.Cascade)
432                          .IsRequired();
433                  });
434  
435              modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
436                  {
437                      b.HasOne("Microsoft.AspNetCore.Identity.IdentityRole", null)
438                          .WithMany()
439                          .HasForeignKey("RoleId")
440                          .OnDelete(DeleteBehavior.Cascade)
441                          .IsRequired();
442  
443                      b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser", null)
444                          .WithMany()
445                          .HasForeignKey("UserId")
446                          .OnDelete(DeleteBehavior.Cascade)
447                          .IsRequired();
448                  });
449  
450              modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
451                  {
452                      b.HasOne("Microsoft.AspNetCore.Identity.IdentityUser", null)
453                          .WithMany()
454                          .HasForeignKey("UserId")
455                          .OnDelete(DeleteBehavior.Cascade)
456                          .IsRequired();
457                  });
458  
459              modelBuilder.Entity("_5uhr.Data.CheckIn", b =>
460                  {
461                      b.HasOne("_5uhr.Data.GangDay", "DayOfCheckIn")
462                          .WithMany("CheckIns")
463                          .HasForeignKey("DayOfCheckInId")
464                          .OnDelete(DeleteBehavior.Cascade)
465                          .IsRequired();
466  
467                      b.HasOne("_5uhr.Data.Member", "MemberThatCheckedIn")
468                          .WithMany("CheckIns")
469                          .HasForeignKey("MemberThatCheckedInId")
470                          .OnDelete(DeleteBehavior.Cascade)
471                          .IsRequired();
472  
473                      b.Navigation("DayOfCheckIn");
474  
475                      b.Navigation("MemberThatCheckedIn");
476                  });
477  
478              modelBuilder.Entity("_5uhr.Data.GangDay", b =>
479                  {
480                      b.HasOne("_5uhr.Data.GangDay", "Next")
481                          .WithOne("Previous")
482                          .HasForeignKey("_5uhr.Data.GangDay", "NextId");
483  
484                      b.Navigation("Next");
485                  });
486  
487              modelBuilder.Entity("_5uhr.Data.PreCheckIn", b =>
488                  {
489                      b.HasOne("_5uhr.Data.GangDay", "Day")
490                          .WithMany("PreCheckIns")
491                          .HasForeignKey("DayId")
492                          .OnDelete(DeleteBehavior.Cascade)
493                          .IsRequired();
494  
495                      b.HasOne("_5uhr.Data.Member", "MemberThatPreCheckedIn")
496                          .WithMany("PreCheckIns")
497                          .HasForeignKey("MemberThatPreCheckedInId")
498                          .OnDelete(DeleteBehavior.Cascade)
499                          .IsRequired();
500  
501                      b.Navigation("Day");
502  
503                      b.Navigation("MemberThatPreCheckedIn");
504                  });
505  
506              modelBuilder.Entity("_5uhr.Data.Report", b =>
507                  {
508                      b.HasOne("_5uhr.Data.CheckIn", "CheckInThatWasReported")
509                          .WithMany("Reports")
510                          .HasForeignKey("CheckInThatWasReportedId")
511                          .OnDelete(DeleteBehavior.Cascade)
512                          .IsRequired();
513  
514                      b.HasOne("_5uhr.Data.Member", "MemberThatReported")
515                          .WithMany("ReportsFiled")
516                          .HasForeignKey("MemberThatReportedId")
517                          .OnDelete(DeleteBehavior.Cascade)
518                          .IsRequired();
519  
520                      b.Navigation("CheckInThatWasReported");
521  
522                      b.Navigation("MemberThatReported");
523                  });
524  
525              modelBuilder.Entity("_5uhr.Data.Verification", b =>
526                  {
527                      b.HasOne("_5uhr.Data.CheckIn", "CheckInThatWasVerified")
528                          .WithMany("Verifications")
529                          .HasForeignKey("CheckInThatWasVerifiedId")
530                          .OnDelete(DeleteBehavior.Cascade)
531                          .IsRequired();
532  
533                      b.HasOne("_5uhr.Data.Member", "MemberThatVerified")
534                          .WithMany("VerificationsGiven")
535                          .HasForeignKey("MemberThatVerifiedId")
536                          .OnDelete(DeleteBehavior.Cascade)
537                          .IsRequired();
538  
539                      b.Navigation("CheckInThatWasVerified");
540  
541                      b.Navigation("MemberThatVerified");
542                  });
543  
544              modelBuilder.Entity("_5uhr.Data.CheckIn", b =>
545                  {
546                      b.Navigation("Reports");
547  
548                      b.Navigation("Verifications");
549                  });
550  
551              modelBuilder.Entity("_5uhr.Data.GangDay", b =>
552                  {
553                      b.Navigation("CheckIns");
554  
555                      b.Navigation("PreCheckIns");
556  
557                      b.Navigation("Previous");
558                  });
559  
560              modelBuilder.Entity("_5uhr.Data.Member", b =>
561                  {
562                      b.Navigation("CheckIns");
563  
564                      b.Navigation("PreCheckIns");
565  
566                      b.Navigation("ReportsFiled");
567  
568                      b.Navigation("VerificationsGiven");
569                  });
570  #pragma warning restore 612, 618
571          }
572      }
573  }