ANTOOZA-BACKEND/Infrastructure/Persistence/Configurations/Feed/FeedPostConfiguration.cs

using Domain.Entities.Feed;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;

namespace Infrastructure.Persistence.Configurations.Feed;

public sealed class FeedPostConfiguration : IEntityTypeConfiguration<FeedPost>
{
    public void Configure(EntityTypeBuilder<FeedPost> builder)
    {
        builder.HasIndex(x => x.MemberID);
        builder.HasIndex(x => x.IsDeleted);
        builder.HasIndex(x => x.CreatedAt);
        builder.HasIndex(x => new { x.IsDeleted, x.CreatedAt });
        builder.HasIndex(x => new { x.MemberID, x.IsDeleted, x.CreatedAt });
        builder.HasIndex(x => new { x.IsDeleted, x.Likes, x.Comments, x.Views });

        builder.HasMany(x => x.FeedComment).WithOne(x => x.FeedPost).HasForeignKey(x => x.FeedPostID).OnDelete(DeleteBehavior.Cascade);
        builder.HasMany(x => x.FeedPostImage).WithOne(x => x.FeedPost).HasForeignKey(x => x.FeedPostID).OnDelete(DeleteBehavior.Cascade);
        builder.HasMany(x => x.FeedPostMedia).WithOne(x => x.FeedPost).HasForeignKey(x => x.FeedPostID).OnDelete(DeleteBehavior.Cascade);
        builder.HasMany(x => x.FeedPostTag).WithOne(x => x.FeedPost).HasForeignKey(x => x.FeedPostID).OnDelete(DeleteBehavior.Cascade);
        builder.HasMany(x => x.FeedPostMention).WithOne(x => x.FeedPost).HasForeignKey(x => x.FeedPostID).OnDelete(DeleteBehavior.Cascade);
        builder.HasMany(x => x.FeedLike).WithOne(x => x.FeedPost).HasForeignKey(x => x.FeedPostID).OnDelete(DeleteBehavior.Cascade);
        builder.HasMany(x => x.FeedBookmark).WithOne(x => x.FeedPost).HasForeignKey(x => x.FeedPostID).OnDelete(DeleteBehavior.Cascade);

        builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.Restrict);

        builder.ToTable(nameof(FeedPost), t => t.HasComment("피드 포스트"));
        builder.HasKey(x => x.ID);
        builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
        builder.Property(x => x.MemberID).IsRequired().HasComment("작성 회원 ID");
        builder.Property(x => x.Content).HasMaxLength(5000).IsRequired().HasComment("본문");
        builder.Property(x => x.Thumbnail).HasMaxLength(1000).HasComment("썸네일 URL");
        builder.Property(x => x.Images).IsRequired().HasComment("이미지 개수");
        builder.Property(x => x.Medias).IsRequired().HasComment("미디어 개수");
        builder.Property(x => x.Tags).IsRequired().HasComment("태그 개수");
        builder.Property(x => x.Likes).IsRequired().HasComment("좋아요 수");
        builder.Property(x => x.Comments).IsRequired().HasComment("댓글 수");
        builder.Property(x => x.Bookmarks).IsRequired().HasComment("북마크 수");
        builder.Property(x => x.Views).IsRequired().HasComment("조회수");
        builder.Property(x => x.Reports).IsRequired().HasComment("신고 수");
        builder.Property(x => x.IsDeleted).IsRequired().HasComment("삭제 여부");
        builder.Property(x => x.IpAddress).HasMaxLength(50).HasComment("작성자 IP");
        builder.Property(x => x.UserAgent).HasMaxLength(255).HasComment("작성자 User-Agent");
        builder.Property(x => x.DeletedAt).HasComment("삭제 일시");
        builder.Property(x => x.UpdatedAt).HasComment("수정 일시");
        builder.Property(x => x.CreatedAt).IsRequired().HasComment("등록 일시");
    }
}