MemberDailyRewardCounterConfiguration.cs 1.4 KB

12345678910111213141516171819202122232425262728
  1. using Domain.Entities.Members;
  2. using Microsoft.EntityFrameworkCore;
  3. using Microsoft.EntityFrameworkCore.Metadata.Builders;
  4. namespace Infrastructure.Persistence.Configurations.Members;
  5. public sealed class MemberDailyRewardCounterConfiguration : IEntityTypeConfiguration<MemberDailyRewardCounter>
  6. {
  7. public void Configure(EntityTypeBuilder<MemberDailyRewardCounter> builder)
  8. {
  9. builder.HasOne<Member>().WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.Cascade);
  10. builder.ToTable(nameof(MemberDailyRewardCounter), x => x.HasComment("일일 보상 캡 원장 (d3 M2)"));
  11. // 복합 PK (MemberID, RewardDate[KST], ActionType)
  12. builder.HasKey(x => new { x.MemberID, x.RewardDate, x.ActionType });
  13. builder.Property(x => x.MemberID).HasComment("회원 ID");
  14. builder.Property(x => x.RewardDate).HasColumnType("date").HasComment("KST 기준 일자");
  15. builder.Property(x => x.ActionType).HasConversion<byte>().HasComment("액션 유형 (Post=1..PaperReward=8)");
  16. builder.Property(x => x.Count).IsRequired().HasComment("오늘 지급 횟수");
  17. builder.Property(x => x.ExpTotal).IsRequired().HasComment("오늘 지급 경험치 합계");
  18. builder.Property(x => x.PointTotal).IsRequired().HasComment("오늘 지급 토큰 합계");
  19. // 보존기간 경과 정리 배치용
  20. builder.HasIndex(x => x.RewardDate);
  21. }
  22. }