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

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

namespace Infrastructure.Persistence.Configurations.Donations;

public sealed class DonorTitleSelectionConfiguration : IEntityTypeConfiguration<DonorTitleSelection>
{
    public void Configure(EntityTypeBuilder<DonorTitleSelection> builder)
    {
        builder.HasOne(x => x.Donor).WithMany().HasForeignKey(x => x.DonorMemberID).OnDelete(DeleteBehavior.NoAction);
        builder.HasOne(x => x.Channel).WithMany().HasForeignKey(x => x.ChannelID).OnDelete(DeleteBehavior.NoAction);
        builder.HasOne(x => x.SelectedTitle).WithMany().HasForeignKey(x => x.SelectedTitleID).OnDelete(DeleteBehavior.SetNull);

        builder.ToTable(nameof(DonorTitleSelection), x => x.HasComment("후원자가 선택한 채널별 대표 칭호"));
        builder.HasKey(x => x.ID);
        builder.Property(x => x.ID).ValueGeneratedOnAdd();
        builder.Property(x => x.DonorMemberID).IsRequired().HasComment("후원자 회원 ID");
        builder.Property(x => x.ChannelID).IsRequired().HasComment("채널 ID");
        builder.Property(x => x.SelectedTitleID).HasComment("선택 칭호 ID");
        builder.Property(x => x.UpdatedAt).HasComment("수정 일시");
        builder.Property(x => x.CreatedAt).IsRequired().HasComment("생성 일시");

        builder.HasIndex(x => new { x.DonorMemberID, x.ChannelID }).IsUnique();
    }
}