PostImageConfiguration.cs 2.3 KB

123456789101112131415161718192021222324252627282930313233343536373839
  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 PostImageConfiguration : IEntityTypeConfiguration<PostImage>
  6. {
  7. public void Configure(EntityTypeBuilder<PostImage> builder)
  8. {
  9. builder.HasIndex(x => x.BoardID);
  10. builder.HasIndex(x => x.PostID);
  11. builder.HasIndex(x => x.UUID).IsUnique();
  12. builder.HasIndex(x => new { x.PostID, x.HashedName });
  13. builder.HasIndex(x => new { x.PostID, x.HashedName, x.IsDisabled });
  14. builder.HasOne(x => x.Board).WithMany().HasForeignKey(x => x.BoardID).OnDelete(DeleteBehavior.Restrict);
  15. builder.HasOne(x => x.Post).WithMany(x => x.PostImage).HasForeignKey(x => x.PostID).OnDelete(DeleteBehavior.Cascade);
  16. builder.ToTable("PostImage", x => x.HasComment("게시글 이미지"));
  17. builder.HasKey(x => x.ID);
  18. builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
  19. builder.Property(x => x.BoardID).IsRequired().HasComment("게시판 ID");
  20. builder.Property(x => x.PostID).IsRequired().HasComment("게시글 ID");
  21. builder.Property(x => x.UUID).IsRequired().HasComment("이미지 ID");
  22. builder.Property(x => x.FileName).HasMaxLength(255).IsRequired().HasComment("원본 파일명");
  23. builder.Property(x => x.HashedName).HasMaxLength(255).IsRequired().HasComment("저장 파일명");
  24. builder.Property(x => x.Path).HasMaxLength(500).IsRequired().HasComment("저장 경로");
  25. builder.Property(x => x.Url).HasMaxLength(1000).IsRequired().HasComment("URL");
  26. builder.Property(x => x.Extension).HasMaxLength(10).HasComment("확장자");
  27. builder.Property(x => x.ContentType).HasMaxLength(100).HasComment("MIME 타입");
  28. builder.Property(x => x.Size).HasComment("용량(byte)");
  29. builder.Property(x => x.Width).HasComment("가로 해상도(px)");
  30. builder.Property(x => x.Height).HasComment("세로 해상도(px)");
  31. builder.Property(x => x.IsDisabled).IsRequired().HasComment("비활성 여부");
  32. builder.Property(x => x.DisabledAt).HasComment("비활성 일시");
  33. builder.Property(x => x.CreatedAt).IsRequired().HasComment("등록 일시");
  34. }
  35. }