CommentFileDownLogConfiguration.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 CommentFileDownLogConfiguration : IEntityTypeConfiguration<CommentFileDownLog>
  6. {
  7. public void Configure(EntityTypeBuilder<CommentFileDownLog> builder)
  8. {
  9. builder.HasIndex(x => x.CommentID);
  10. builder.HasIndex(x => x.CommentFileID);
  11. builder.HasIndex(x => x.MemberID);
  12. builder.HasIndex(x => new { x.CommentID, x.CommentFileID });
  13. builder.HasIndex(x => new { x.CommentID, x.CommentFileID, x.MemberID });
  14. builder.HasOne(x => x.Comment).WithMany(x => x.CommentFileDownLog).HasForeignKey(x => x.CommentID).OnDelete(DeleteBehavior.Cascade);
  15. builder.HasOne(x => x.CommentFile).WithMany().HasForeignKey(x => x.CommentFileID).OnDelete(DeleteBehavior.Restrict);
  16. builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.Restrict);
  17. builder.ToTable("CommentFileDownLog", x => x.HasComment("댓글 파일 다운로드 로그"));
  18. builder.HasKey(x => x.ID);
  19. builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
  20. builder.Property(x => x.CommentID).IsRequired().HasComment("댓글 ID");
  21. builder.Property(x => x.CommentFileID).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. }