AttendanceConfiguration.cs 1.3 KB

1234567891011121314151617181920212223242526
  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 AttendanceConfiguration : IEntityTypeConfiguration<Attendance>
  6. {
  7. public void Configure(EntityTypeBuilder<Attendance> builder)
  8. {
  9. builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.NoAction);
  10. builder.ToTable(nameof(Attendance), x => x.HasComment("출석 기록"));
  11. builder.HasKey(x => x.ID);
  12. builder.Property(x => x.ID).ValueGeneratedOnAdd();
  13. builder.Property(x => x.MemberID).IsRequired().HasComment("회원 ID");
  14. builder.Property(x => x.Greeting).HasMaxLength(200).IsRequired().HasComment("출석 인사");
  15. builder.Property(x => x.ConsecutiveDays).IsRequired().HasComment("연속 출석 일수");
  16. builder.Property(x => x.ExpRewarded).IsRequired().HasComment("지급 경험치");
  17. builder.Property(x => x.PointRewarded).IsRequired().HasComment("지급 포인트");
  18. builder.Property(x => x.CreatedAt).IsRequired().HasComment("출석 일시");
  19. builder.HasIndex(x => new { x.MemberID, x.CreatedAt }).IsDescending(false, true);
  20. builder.HasIndex(x => x.CreatedAt).IsDescending(true);
  21. }
  22. }