ANTOOZA-BACKEND/Infrastructure/Persistence/Configurations/Members/ChannelConfiguration.cs

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

namespace Infrastructure.Persistence.Configurations.Members;

public sealed class ChannelConfiguration : IEntityTypeConfiguration<Channel>
{
    public void Configure(EntityTypeBuilder<Channel> builder)
    {
        builder.HasOne(x => x.Member).WithOne(x => x.Channel).HasForeignKey<Channel>(x => x.MemberID).OnDelete(DeleteBehavior.Cascade);
        builder.HasIndex(x => x.MemberID).IsUnique();
        builder.HasIndex(x => x.SID).IsUnique();
        builder.HasIndex(x => x.Name).IsUnique();
        builder.HasIndex(x => x.Handle).IsUnique();
        builder.HasIndex(x => x.YouTubeUrl).IsUnique();
        builder.HasIndex(x => new { x.MemberID, x.IsVerified });
        builder.HasIndex(x => new { x.MemberID, x.IsActive });
        builder.HasIndex(x => new { x.MemberID, x.IsVerified, x.IsActive });

        builder.ToTable(nameof(Channel), x => x.HasComment("채널 정보"));
        builder.HasKey(x => x.ID);
        builder.Property(x => x.ID).ValueGeneratedOnAdd();
        builder.Property(x => x.MemberID).IsRequired().HasComment("회원 ID");
        builder.Property(x => x.SID).HasMaxLength(24).IsRequired().HasComment("채널 ID");
        builder.Property(x => x.Name).HasMaxLength(200).IsRequired().HasComment("채널 이름");
        builder.Property(x => x.Handle).HasMaxLength(30).HasComment("핸들");
        builder.Property(x => x.YouTubeUrl).HasMaxLength(255).IsRequired().HasComment("YouTube 채널 URL");
        builder.Property(x => x.PlatformFeeRate).HasPrecision(10, 7).IsRequired().HasComment("후원 수수료(%) — dpot 몫, 0~100, 소수점 7자리");
        builder.Property(x => x.StoreCommissionRate).HasPrecision(10, 7).IsRequired().HasDefaultValue(0m).HasComment("상점 매출 보상률(%) — 채널 몫, 0~100, 소수점 7자리");
        builder.Property(x => x.IsVerified).IsRequired().HasComment("인증 여부");
        builder.Property(x => x.IsActive).IsRequired().HasComment("활성 여부");
        builder.Property(x => x.WidgetToken).HasMaxLength(32).IsRequired().HasComment("위젯 토큰");
        builder.HasIndex(x => x.WidgetToken).IsUnique();
        builder.Property(x => x.DonationCode).HasMaxLength(7).HasComment("후원 코드(4~7자 영문+숫자, 대문자). 1회성 발급, 변경 불가");
        builder.HasIndex(x => x.DonationCode).IsUnique().HasFilter("[DonationCode] IS NOT NULL");
        builder.Property(x => x.YouTubeLastSyncedAt).HasComment("YouTube API 마지막 동기화 시각(UTC) — 30일 정책 enforcement");
        builder.HasIndex(x => x.YouTubeLastSyncedAt);
        builder.Property(x => x.UpdatedAt).HasComment("수정 일시");
        builder.Property(x => x.CreatedAt).IsRequired().HasComment("등록 일시");
    }
}