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