PostFileDownLogConfiguration.cs 1.7 KB

12345678910111213141516171819202122232425262728293031
  1. using Domain.Entities.Forum.Logs;
  2. using Microsoft.EntityFrameworkCore;
  3. using Microsoft.EntityFrameworkCore.Metadata.Builders;
  4. namespace Infrastructure.Persistence.Configurations.Forum.Logs;
  5. public sealed class PostFileDownLogConfiguration : IEntityTypeConfiguration<PostFileDownLog>
  6. {
  7. public void Configure(EntityTypeBuilder<PostFileDownLog> builder)
  8. {
  9. builder.HasIndex(x => x.PostID);
  10. builder.HasIndex(x => x.PostFileID);
  11. builder.HasIndex(x => x.MemberID);
  12. builder.HasIndex(x => new { x.PostID, x.PostFileID });
  13. builder.HasIndex(x => new { x.PostID, x.PostFileID, x.MemberID });
  14. builder.HasOne(x => x.Post).WithMany(x => x.PostFileDownLog).HasForeignKey(x => x.PostID).OnDelete(DeleteBehavior.Cascade);
  15. builder.HasOne(x => x.PostFile).WithMany().HasForeignKey(x => x.PostFileID).OnDelete(DeleteBehavior.Restrict);
  16. builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.Restrict);
  17. builder.ToTable("PostFileDownLog", x => x.HasComment("게시글 파일 다운로드 로그"));
  18. builder.HasKey(x => x.ID);
  19. builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
  20. builder.Property(x => x.PostID).IsRequired().HasComment("게시글 ID");
  21. builder.Property(x => x.PostFileID).IsRequired().HasComment("게시글 파일 ID");
  22. builder.Property(x => x.MemberID).HasComment("회원 ID");
  23. builder.Property(x => x.IpAddress).HasMaxLength(50).HasComment("IP Address");
  24. builder.Property(x => x.UserAgent).HasMaxLength(255).HasComment("User-Agent");
  25. builder.Property(x => x.CreatedAt).IsRequired().HasComment("등록 일시");
  26. }
  27. }