MemberLoginLogConfiguration.cs 1.6 KB

123456789101112131415161718192021222324252627282930
  1. using Domain.Entities.Members.Logs;
  2. using Microsoft.EntityFrameworkCore;
  3. using Microsoft.EntityFrameworkCore.Metadata.Builders;
  4. namespace Infrastructure.Persistence.Configurations.Members.Logs;
  5. public sealed class MemberLoginLogConfiguration : IEntityTypeConfiguration<MemberLoginLog>
  6. {
  7. public void Configure(EntityTypeBuilder<MemberLoginLog> builder)
  8. {
  9. builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.SetNull);
  10. builder.HasIndex(x => x.MemberID);
  11. builder.HasIndex(x => x.Account);
  12. builder.HasIndex(x => new { x.MemberID, x.Success });
  13. builder.ToTable(nameof(MemberLoginLog), x => x.HasComment("로그인 기록"));
  14. builder.HasKey(x => x.ID);
  15. builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
  16. builder.Property(x => x.MemberID).HasComment("회원 ID");
  17. builder.Property(x => x.Success).IsRequired().HasComment("로그인 성공 여부 (0: 실패, 1: 성공)");
  18. builder.Property(x => x.Account).HasMaxLength(120).IsRequired().HasComment("로그인 시도한 계정");
  19. builder.Property(x => x.Reason).HasMaxLength(225).HasComment("실패 이유");
  20. builder.Property(x => x.Referer).HasComment("이전 페이지 주소");
  21. builder.Property(x => x.Url).HasMaxLength(500).HasComment("요청 주소");
  22. builder.Property(x => x.IpAddress).HasMaxLength(45).HasComment("IP Address");
  23. builder.Property(x => x.UserAgent).HasMaxLength(512).HasComment("User Agent");
  24. builder.Property(x => x.CreatedAt).IsRequired().HasComment("등록 일시");
  25. }
  26. }