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

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

namespace Infrastructure.Persistence.Configurations.Feed;

public sealed class FeedPostMentionConfiguration : IEntityTypeConfiguration<FeedPostMention>
{
    public void Configure(EntityTypeBuilder<FeedPostMention> builder)
    {
        builder.HasIndex(x => x.FeedPostID);
        builder.HasIndex(x => x.MemberID);
        builder.HasIndex(x => new { x.FeedPostID, x.MemberID }).IsUnique();
        builder.HasIndex(x => new { x.MemberID, x.CreatedAt }).IsDescending(false, true);

        builder.HasOne(x => x.FeedPost).WithMany(x => x.FeedPostMention).HasForeignKey(x => x.FeedPostID).OnDelete(DeleteBehavior.Cascade);
        builder.HasOne(x => x.Member).WithMany().HasForeignKey(x => x.MemberID).OnDelete(DeleteBehavior.Cascade);

        builder.ToTable(nameof(FeedPostMention), t => t.HasComment("피드 포스트 멘션"));
        builder.HasKey(x => x.ID);
        builder.Property(x => x.ID).ValueGeneratedOnAdd().HasComment("PK");
        builder.Property(x => x.FeedPostID).IsRequired();
        builder.Property(x => x.MemberID).IsRequired();
        builder.Property(x => x.RawHandle).HasMaxLength(64).IsRequired().HasComment("원문 @handle");
        builder.Property(x => x.Start).IsRequired().HasComment("본문 내 시작 인덱스");
        builder.Property(x => x.Length).IsRequired().HasComment("길이");
        builder.Property(x => x.CreatedAt).IsRequired();
    }
}