OrderConfiguration.cs 2.6 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. using Domain.Entities.Store;
  2. using Microsoft.EntityFrameworkCore;
  3. using Microsoft.EntityFrameworkCore.Metadata.Builders;
  4. namespace Infrastructure.Persistence.Configurations.Store;
  5. public sealed class OrderConfiguration : IEntityTypeConfiguration<Order>
  6. {
  7. public void Configure(EntityTypeBuilder<Order> builder)
  8. {
  9. builder.ToTable(nameof(Order), t => t.HasComment("상점 주문 헤더"));
  10. builder.HasKey(x => x.ID);
  11. builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.Restrict);
  12. builder.HasOne(x => x.Channel).WithMany().HasForeignKey(x => x.ChannelID).OnDelete(DeleteBehavior.NoAction);
  13. builder.HasMany(x => x.Items).WithOne(x => x.Order).HasForeignKey(x => x.OrderID).OnDelete(DeleteBehavior.Cascade);
  14. builder.Navigation(x => x.Items).HasField("_items").UsePropertyAccessMode(PropertyAccessMode.Field);
  15. builder.HasMany(x => x.Refunds).WithOne(x => x.Order).HasForeignKey(x => x.OrderID).OnDelete(DeleteBehavior.Cascade);
  16. builder.Navigation(x => x.Refunds).HasField("_refunds").UsePropertyAccessMode(PropertyAccessMode.Field);
  17. builder.Property(x => x.OrderNumber).HasMaxLength(20).IsRequired().HasComment("주문 번호 (UNIQUE)");
  18. builder.Property(x => x.MemberID).IsRequired();
  19. builder.Property(x => x.GiftToMemberID).HasComment("선물 수신자 회원 ID (null=본인구매)");
  20. builder.Property(x => x.GiftMessage).HasMaxLength(200).HasComment("선물 메시지");
  21. builder.Property(x => x.ChannelID).HasComment("후원 채널 (선택)");
  22. builder.Property(x => x.TotalAmount).IsRequired().HasComment("총 결제 금액");
  23. builder.Property(x => x.PlatformFeeAmount).IsRequired().HasComment("dpot 몫");
  24. builder.Property(x => x.GameRevenueAmount).IsRequired().HasComment("게임사 정산 큐 적재 금액");
  25. builder.Property(x => x.ChannelRewardAmount).IsRequired().HasComment("채널주 채널 보상 입금 금액 (비활성 — 과거 주문 호환)");
  26. builder.Property(x => x.Status).HasConversion<int>().IsRequired().HasComment("주문 상태");
  27. builder.Property(x => x.CancelReason).HasMaxLength(500);
  28. builder.Property(x => x.RefundReason).HasMaxLength(500);
  29. builder.Property(x => x.CreatedAt).IsRequired();
  30. builder.Property(x => x.PaidAt);
  31. builder.Property(x => x.RowVersion).IsRowVersion();
  32. builder.HasIndex(x => x.OrderNumber).IsUnique();
  33. builder.HasIndex(x => new { x.MemberID, x.Status, x.CreatedAt });
  34. builder.HasIndex(x => new { x.Status, x.CreatedAt });
  35. builder.HasIndex(x => x.ChannelID);
  36. }
  37. }