ANTOOZA-BACKEND/Infrastructure/Persistence/Configurations/Donations/CrewInvitationConfiguration.cs

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

namespace Infrastructure.Persistence.Configurations.Donations;

public class CrewInvitationConfiguration : IEntityTypeConfiguration<CrewInvitation>
{
    public void Configure(EntityTypeBuilder<CrewInvitation> builder)
    {
        builder.ToTable(nameof(CrewInvitation), x => x.HasComment("크루원 초대 이력"));
        builder.HasKey(x => x.ID);

        builder.HasOne(x => x.Crew).WithMany().HasForeignKey(x => x.CrewID).OnDelete(DeleteBehavior.Cascade);
        builder.HasOne(x => x.TargetMember).WithMany().HasForeignKey(x => x.TargetMemberID).OnDelete(DeleteBehavior.NoAction);
        builder.HasOne(x => x.InvitedByMember).WithMany().HasForeignKey(x => x.InvitedByMemberID).OnDelete(DeleteBehavior.NoAction);

        // 동일 (crewID, targetMemberID, status) 빠른 lookup (중복 초대 방지)
        builder.HasIndex(x => new { x.CrewID, x.TargetMemberID, x.Status });

        // 만료 처리 background용 (status, expiresAt)
        builder.HasIndex(x => new { x.Status, x.ExpiresAt });

        builder.Property(x => x.Nickname).HasMaxLength(40).IsRequired();
        builder.Property(x => x.Role).HasMaxLength(50);
        builder.Property(x => x.Status).HasConversion<int>();
    }
}