PostReportConfiguration.cs 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637
  1. using Domain.Entities.Forum.Posts;
  2. using Microsoft.EntityFrameworkCore;
  3. using Microsoft.EntityFrameworkCore.Metadata.Builders;
  4. namespace Infrastructure.Persistence.Configurations.Forum.Posts;
  5. public sealed class PostReportConfiguration : IEntityTypeConfiguration<PostReport>
  6. {
  7. public void Configure(EntityTypeBuilder<PostReport> builder)
  8. {
  9. builder.HasIndex(x => x.BoardID);
  10. builder.HasIndex(x => x.PostID);
  11. builder.HasIndex(x => x.MemberID);
  12. builder.HasIndex(x => x.Type);
  13. builder.HasIndex(x => x.Status);
  14. builder.HasIndex(x => new { x.PostID, x.MemberID }).IsUnique();
  15. builder.HasOne(x => x.Board).WithMany().HasForeignKey(x => x.BoardID).OnDelete(DeleteBehavior.Restrict);
  16. builder.HasOne(x => x.Post).WithMany(x => x.PostReport).HasForeignKey(x => x.PostID).OnDelete(DeleteBehavior.Cascade);
  17. builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.Cascade);
  18. builder.ToTable("PostReport", x => x.HasComment("게시글 신고"));
  19. builder.HasKey(x => x.ID);
  20. builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
  21. builder.Property(x => x.BoardID).IsRequired().HasComment("게시판 ID");
  22. builder.Property(x => x.PostID).IsRequired().HasComment("게시글 ID");
  23. builder.Property(x => x.MemberID).IsRequired().HasComment("회원 ID");
  24. builder.Property(x => x.Type).HasConversion<byte>().IsRequired().HasComment("신고 사유");
  25. builder.Property(x => x.Reason).HasMaxLength(1000).HasComment("신고 내용");
  26. builder.Property(x => x.Status).HasConversion<byte>().IsRequired().HasComment("처리 상태");
  27. builder.Property(x => x.Memo).HasMaxLength(1000).HasComment("처리 내용");
  28. builder.Property(x => x.IpAddress).HasMaxLength(15).HasComment("IP Address");
  29. builder.Property(x => x.UserAgent).HasMaxLength(255).HasComment("User-agent");
  30. builder.Property(x => x.UpdatedAt).HasComment("수정 일시");
  31. builder.Property(x => x.CreatedAt).IsRequired().HasComment("등록 일시");
  32. }
  33. }